powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM [игнор отключен] [закрыт для гостей] / множественный выбор в Ole
2 сообщений из 2, страница 1 из 1
множественный выбор в Ole
    #34181952
nizar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Подскажите как реализовать? выбрать через OLE
в Table записи выбираемые следующим образом:

"select kc,kvo,sum([sum]) as s150,0 as s259,0 as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='150' group by kc,kvo";

"select kc,kvo,0 as s150,sum([sum]) as s259,0 as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='259' group by kc,kvo";

"select kc,kvo,0 as s150,0 as s259,sum([sum]) as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='421' group by kc,kvo";
и т.д.
...
Рейтинг: 0 / 0
множественный выбор в Ole
    #34181956
nizar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
а далее

select kc,
sum(s150) as s150,
sum(s259) as s259,
sum(s421) as s421,
sum(s422) as s422,
sum(s426) as s426,
sum(s427) as s427,
sum(s445) as s445,
sum(s448) as s448,
sum(s449) as s449,
sum(s453) as s453,
sum(s457) as s457,
sum(s465) as s465,
sum(s479) as s479,
sum(s480) as s480,
sum(s580) as s580,
sum(s581) as s581,
sum(s582) as s582

from Table
...
Рейтинг: 0 / 0
2 сообщений из 2, страница 1 из 1
Форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM [игнор отключен] [закрыт для гостей] / множественный выбор в Ole
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]