How to ADD rows instead of UNION ALL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to ADD rows instead of UNION ALL

Author

Topic

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-06 : 07:25:35

I have a view that is using UNION ALL to make a view that has all the rows from a table.Is there any way I can ADD these rows that included in the script?
For example I get

column1 column2 column3
2 3 4
4 5 6
4 5 6
1 1 1

..and I want to get column1 column2 column3
11 14 17

Thnx!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-06 : 07:31:15

By using SUM aggregate function?

E 12°55'05.25"
N 56°04'39.16"

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-06 : 07:38:41

How can this be used in the place of UNION ALL?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-06 : 07:41:54

Please post your current code so we can see what the union is doing as without the code, there is no way we can tell you.

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-06 : 07:46:06

SELECT 1 AS betmhkey, beisodat, beisoa01 AS beisoa, beisox01 AS beisox, beisom01 AS beisom, beisoe01 AS beisoe, beisopre, beisocas, beisocca,
beisoxre, beisopax, beisoepx, beisocpx, beisofpx, beisorom, beisoprx, beisoxcc, beisoxmc, beisoxxr, beisoxpi, beisoxek, beisoxpr, beisore1,
beisore2, 0 AS beprokra, 0 AS beproposo, 0 AS beprotropos
FROM ErmisUser.beiso
UNION ALL
SELECT 2 AS betmhkey, beisodat, beisoa02 AS beisoa, beisox02 AS beisox, beisom02 AS beisom, beisoe02 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 3 AS betmhkey, beisodat, beisoa03 AS beisoa, beisox03 AS beisox, beisom03 AS beisom, beisoe03 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 4 AS betmhkey, beisodat, beisoa04 AS beisoa, beisox04 AS beisox, beisom04 AS beisom, beisoe04 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 5 AS betmhkey, beisodat, beisoa05 AS beisoa, beisox05 AS beisox, beisom05 AS beisom, beisoe05 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 6 AS betmhkey, beisodat, 0 AS beisoa, beisox06 AS beisox, beisom06 AS beisom, beisoe06 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 7 AS betmhkey, beisodat, 0 AS beisoa, beisox07 AS beisox, beisom07 AS beisom, beisoe07 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 8 AS betmhkey, beisodat, 0 AS beisoa, beisox08 AS beisox, beisom08 AS beisom, beisoe08 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 9 AS betmhkey, beisodat, 0 AS beisoa, beisox09 AS beisox, beisom09 AS beisom, beisoe09 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 10 AS betmhkey, beisodat, 0 AS beisoa, beisox10 AS beisox, beisom10 AS beisom, beisoe10 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 11 AS betmhkey, beisodat, 0 AS beisoa, beisox11 AS beisox, beisom11 AS beisom, beisoe11 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 12 AS betmhkey, beisodat, 0 AS beisoa, beisox12 AS beisox, beisom12 AS beisom, beisoe12 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 13 AS betmhkey, beisodat, 0 AS beisoa, beisox13 AS beisox, beisom13 AS beisom, beisoe13 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 14 AS betmhkey, beisodat, 0 AS beisoa, beisox14 AS beisox, beisom14 AS beisom, beisoe14 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 15 AS betmhkey, beisodat, 0 AS beisoa, beisox15 AS beisox, beisom15 AS beisom, beisoe15 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 16 AS betmhkey, beisodat, 0 AS beisoa, beisox16 AS beisox, beisom16 AS beisom, beisoe16 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 17 AS betmhkey, beisodat, 0 AS beisoa, beisox17 AS beisox, beisom17 AS beisom, beisoe17 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 18 AS betmhkey, beisodat, 0 AS beisoa, beisox18 AS beisox, beisom18 AS beisom, beisoe18 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 19 AS betmhkey, beisodat, 0 AS beisoa, beisox19 AS beisox, beisom19 AS beisom, beisoe19 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 20 AS betmhkey, beisodat, 0 AS beisoa, beisox20 AS beisox, beisom20 AS beisom, beisoe20 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 21 AS betmhkey, beisodat, 0 AS beisoa, beisox21 AS beisox, beisom21 AS beisom, beisoe21 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 22 AS betmhkey, beisodat, 0 AS beisoa, beisox22 AS beisox, beisom22 AS beisom, beisoe22 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 23 AS betmhkey, beisodat, 0 AS beisoa, beisox23 AS beisox, beisom23 AS beisom, beisoe23 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 24 AS betmhkey, beisodat, 0 AS beisoa, beisox24 AS beisox, beisom24 AS beisom, beisoe24 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 25 AS betmhkey, beisodat, 0 AS beisoa, beisox25 AS beisox, beisom25 AS beisom, beisoe25 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 26 AS betmhkey, beisodat, 0 AS beisoa, beisox26 AS beisox, beisom26 AS beisom, beisoe26 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 27 AS betmhkey, beisodat, 0 AS beisoa, beisox27 AS beisox, beisom27 AS beisom, beisoe27 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 28 AS betmhkey, beisodat, 0 AS beisoa, beisox28 AS beisox, beisom28 AS beisom, beisoe28 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 29 AS betmhkey, beisodat, 0 AS beisoa, beisox29 AS beisox, beisom29 AS beisom, beisoe29 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 30 AS betmhkey, beisodat, 0 AS beisoa, beisox30 AS beisox, beisom30 AS beisom, beisoe30 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 31 AS betmhkey, beisodat, 0 AS beisoa, beisox31 AS beisox, beisom31 AS beisom, beisoe31 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 32 AS betmhkey, beisodat, 0 AS beisoa, beisox32 AS beisox, beisom32 AS beisom, beisoe32 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 33 AS betmhkey, beisodat, 0 AS beisoa, beisox33 AS beisox, beisom33 AS beisom, beisoe33 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 34 AS betmhkey, beisodat, 0 AS beisoa, beisox34 AS beisox, beisom34 AS beisom, beisoe34 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 35 AS betmhkey, beisodat, 0 AS beisoa, beisox35 AS beisox, beisom35 AS beisom, beisoe35 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 36 AS betmhkey, beisodat, 0 AS beisoa, beisox36 AS beisox, beisom36 AS beisom, beisoe36 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 37 AS betmhkey, beisodat, 0 AS beisoa, beisox37 AS beisox, beisom37 AS beisom, beisoe37 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 38 AS betmhkey, beisodat, 0 AS beisoa, beisox38 AS beisox, beisom38 AS beisom, beisoe38 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 39 AS betmhkey, beisodat, 0 AS beisoa, beisox39 AS beisox, beisom39 AS beisom, beisoe39 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 40 AS betmhkey, beisodat, 0 AS beisoa, beisox40 AS beisox, beisom40 AS beisom, beisoe40 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 41 AS betmhkey, beisodat, 0 AS beisoa, beisox41 AS beisox, beisom41 AS beisom, beisoe41 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 42 AS betmhkey, beisodat, 0 AS beisoa, beisox42 AS beisox, beisom42 AS beisom, beisoe42 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 43 AS betmhkey, beisodat, 0 AS beisoa, beisox43 AS beisox, beisom43 AS beisom, beisoe43 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 44 AS betmhkey, beisodat, 0 AS beisoa, beisox44 AS beisox, beisom44 AS beisom, beisoe44 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 45 AS betmhkey, beisodat, 0 AS beisoa, beisox45 AS beisox, beisom45 AS beisom, beisoe45 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 46 AS betmhkey, beisodat, 0 AS beisoa, beisox46 AS beisox, beisom46 AS beisom, beisoe46 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 47 AS betmhkey, beisodat, 0 AS beisoa, beisox47 AS beisox, beisom47 AS beisom, beisoe47 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 48 AS betmhkey, beisodat, 0 AS beisoa, beisox48 AS beisox, beisom48 AS beisom, beisoe48 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 49 AS betmhkey, beisodat, 0 AS beisoa, beisox49 AS beisox, beisom49 AS beisom, beisoe49 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 50 AS betmhkey, beisodat, 0 AS beisoa, beisox50 AS beisox, beisom50 AS beisom, beisoe50 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 51 AS betmhkey, beprodate, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10,
0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14, 0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21,
0 AS Expr22, beprokra, beproposo, beprotropos
FROM ErmisUser.beprok
WHERE (beprostatus = 0)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-06 : 08:51:54

Select sum(Expr1) as Expr1, sum(Expr2) as Expr2,.........sum(Expr21) as Expr21 from
(
your above query
) as t

Madhivanan

Failing to plan is Planning to fail

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-06 : 09:40:46

thnx for the answer but after executing this query I get the following error :

Invalid column name 'Expr1'
Invalid column name 'Expr2'
.
.
.
Invalid column name 'Expr3'

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-06 : 09:48:04

you need to refer to the column names in your first select

Em

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-06 : 09:51:00

i'm not gonna go through your whole query but this demo's it...


select sum(col1),sum(col2)
from
(
		select 3 as col1, 4 as col2
union all	select 2 as colA, 1 as colB
) t

you need to reference col1 and col2, not colA and colB

Em

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-06 : 10:18:10

This is enough


select sum(col1),sum(col2)
from
(
		select 3 as col1, 4 as col2
union all	select 2, 1
) t

The first SELECT sets the standard for column names. All other SELECTS in the UNION only uses column position.

E 12°55'05.25"
N 56°04'39.16"

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 03:48:17

ok.I created this t table but where is it stored so that I can see it?Now I can see only the columns.

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 03:54:33

not sure what you mean actually. 't' in the examples we gave you is a derived table. it's just a way of selecting from the result of your query

Em

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 04:03:47

sorry guys.I see it now.I could not see it after verify syntax command.But if I run the query I can see the table.

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 04:31:20

Is there any way I can sum the columns based on the date?(the date is given in the beisodat column)
To be more specific if there are 3 entries at the same date I want one row only in the place of the 3 columns with let's say 11-10-2001 and with the other columns of this row filled with the sum of the fields of that date)

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 04:38:19

just select it as well and then group by it (look up GROUP BY in Books online).

does it have a time on it as well? if so you may want to strip it down to just the day. There's loads of posts on here for how to do that if you do a search.

Em

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 05:29:33

SELECT 1 AS betmhkey, beisodat, beisoa01 AS beisoa, beisox01 AS beisox, beisom01 AS beisom, beisoe01 AS beisoe, beisopre, beisocas, beisocca,
beisoxre, beisopax, beisoepx, beisocpx, beisofpx, beisorom, beisoprx, beisoxcc, beisoxmc, beisoxxr, beisoxpi, beisoxek, beisoxpr, beisore1,
beisore2, 0 AS beprokra, 0 AS beproposo, 0 AS beprotropos
FROM ErmisUser.beiso
UNION ALL
SELECT 2 AS betmhkey, beisodat, beisoa02 AS beisoa, beisox02 AS beisox, beisom02 AS beisom, beisoe02 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_49
UNION ALL
SELECT 3 AS betmhkey, beisodat, beisoa03 AS beisoa, beisox03 AS beisox, beisom03 AS beisom, beisoe03 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_48
UNION ALL
SELECT 4 AS betmhkey, beisodat, beisoa04 AS beisoa, beisox04 AS beisox, beisom04 AS beisom, beisoe04 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_47
UNION ALL
SELECT 5 AS betmhkey, beisodat, beisoa05 AS beisoa, beisox05 AS beisox, beisom05 AS beisom, beisoe05 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_46
UNION ALL
SELECT 6 AS betmhkey, beisodat, 0 AS beisoa, beisox06 AS beisox, beisom06 AS beisom, beisoe06 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_45
UNION ALL
SELECT 7 AS betmhkey, beisodat, 0 AS beisoa, beisox07 AS beisox, beisom07 AS beisom, beisoe07 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_44
UNION ALL
SELECT 8 AS betmhkey, beisodat, 0 AS beisoa, beisox08 AS beisox, beisom08 AS beisom, beisoe08 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_43
UNION ALL
SELECT 9 AS betmhkey, beisodat, 0 AS beisoa, beisox09 AS beisox, beisom09 AS beisom, beisoe09 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_42
UNION ALL
SELECT 10 AS betmhkey, beisodat, 0 AS beisoa, beisox10 AS beisox, beisom10 AS beisom, beisoe10 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_41
UNION ALL
SELECT 11 AS betmhkey, beisodat, 0 AS beisoa, beisox11 AS beisox, beisom11 AS beisom, beisoe11 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_40
UNION ALL
SELECT 12 AS betmhkey, beisodat, 0 AS beisoa, beisox12 AS beisox, beisom12 AS beisom, beisoe12 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_39
UNION ALL
SELECT 13 AS betmhkey, beisodat, 0 AS beisoa, beisox13 AS beisox, beisom13 AS beisom, beisoe13 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_38
UNION ALL
SELECT 14 AS betmhkey, beisodat, 0 AS beisoa, beisox14 AS beisox, beisom14 AS beisom, beisoe14 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_37
UNION ALL
SELECT 15 AS betmhkey, beisodat, 0 AS beisoa, beisox15 AS beisox, beisom15 AS beisom, beisoe15 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_36
UNION ALL
SELECT 16 AS betmhkey, beisodat, 0 AS beisoa, beisox16 AS beisox, beisom16 AS beisom, beisoe16 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_35
UNION ALL
SELECT 17 AS betmhkey, beisodat, 0 AS beisoa, beisox17 AS beisox, beisom17 AS beisom, beisoe17 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_34
UNION ALL
SELECT 18 AS betmhkey, beisodat, 0 AS beisoa, beisox18 AS beisox, beisom18 AS beisom, beisoe18 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_33
UNION ALL
SELECT 19 AS betmhkey, beisodat, 0 AS beisoa, beisox19 AS beisox, beisom19 AS beisom, beisoe19 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_32
UNION ALL
SELECT 20 AS betmhkey, beisodat, 0 AS beisoa, beisox20 AS beisox, beisom20 AS beisom, beisoe20 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_31
UNION ALL
SELECT 21 AS betmhkey, beisodat, 0 AS beisoa, beisox21 AS beisox, beisom21 AS beisom, beisoe21 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_30
UNION ALL
SELECT 22 AS betmhkey, beisodat, 0 AS beisoa, beisox22 AS beisox, beisom22 AS beisom, beisoe22 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_29
UNION ALL
SELECT 23 AS betmhkey, beisodat, 0 AS beisoa, beisox23 AS beisox, beisom23 AS beisom, beisoe23 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_28
UNION ALL
SELECT 24 AS betmhkey, beisodat, 0 AS beisoa, beisox24 AS beisox, beisom24 AS beisom, beisoe24 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_27
UNION ALL
SELECT 25 AS betmhkey, beisodat, 0 AS beisoa, beisox25 AS beisox, beisom25 AS beisom, beisoe25 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_26
UNION ALL
SELECT 26 AS betmhkey, beisodat, 0 AS beisoa, beisox26 AS beisox, beisom26 AS beisom, beisoe26 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_25
UNION ALL
SELECT 27 AS betmhkey, beisodat, 0 AS beisoa, beisox27 AS beisox, beisom27 AS beisom, beisoe27 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_24
UNION ALL
SELECT 28 AS betmhkey, beisodat, 0 AS beisoa, beisox28 AS beisox, beisom28 AS beisom, beisoe28 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_23
UNION ALL
SELECT 29 AS betmhkey, beisodat, 0 AS beisoa, beisox29 AS beisox, beisom29 AS beisom, beisoe29 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_22
UNION ALL
SELECT 30 AS betmhkey, beisodat, 0 AS beisoa, beisox30 AS beisox, beisom30 AS beisom, beisoe30 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_21
UNION ALL
SELECT 31 AS betmhkey, beisodat, 0 AS beisoa, beisox31 AS beisox, beisom31 AS beisom, beisoe31 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_20
UNION ALL
SELECT 32 AS betmhkey, beisodat, 0 AS beisoa, beisox32 AS beisox, beisom32 AS beisom, beisoe32 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_19
UNION ALL
SELECT 33 AS betmhkey, beisodat, 0 AS beisoa, beisox33 AS beisox, beisom33 AS beisom, beisoe33 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_18
UNION ALL
SELECT 34 AS betmhkey, beisodat, 0 AS beisoa, beisox34 AS beisox, beisom34 AS beisom, beisoe34 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_17
UNION ALL
SELECT 35 AS betmhkey, beisodat, 0 AS beisoa, beisox35 AS beisox, beisom35 AS beisom, beisoe35 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_16
UNION ALL
SELECT 36 AS betmhkey, beisodat, 0 AS beisoa, beisox36 AS beisox, beisom36 AS beisom, beisoe36 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_15
UNION ALL
SELECT 37 AS betmhkey, beisodat, 0 AS beisoa, beisox37 AS beisox, beisom37 AS beisom, beisoe37 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_14
UNION ALL
SELECT 38 AS betmhkey, beisodat, 0 AS beisoa, beisox38 AS beisox, beisom38 AS beisom, beisoe38 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_13
UNION ALL
SELECT 39 AS betmhkey, beisodat, 0 AS beisoa, beisox39 AS beisox, beisom39 AS beisom, beisoe39 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_12
UNION ALL
SELECT 40 AS betmhkey, beisodat, 0 AS beisoa, beisox40 AS beisox, beisom40 AS beisom, beisoe40 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_11
UNION ALL
SELECT 41 AS betmhkey, beisodat, 0 AS beisoa, beisox41 AS beisox, beisom41 AS beisom, beisoe41 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_10
UNION ALL
SELECT 42 AS betmhkey, beisodat, 0 AS beisoa, beisox42 AS beisox, beisom42 AS beisom, beisoe42 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_9
UNION ALL
SELECT 43 AS betmhkey, beisodat, 0 AS beisoa, beisox43 AS beisox, beisom43 AS beisom, beisoe43 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_8
UNION ALL
SELECT 44 AS betmhkey, beisodat, 0 AS beisoa, beisox44 AS beisox, beisom44 AS beisom, beisoe44 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_7
UNION ALL
SELECT 45 AS betmhkey, beisodat, 0 AS beisoa, beisox45 AS beisox, beisom45 AS beisom, beisoe45 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_6
UNION ALL
SELECT 46 AS betmhkey, beisodat, 0 AS beisoa, beisox46 AS beisox, beisom46 AS beisom, beisoe46 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_5
UNION ALL
SELECT 47 AS betmhkey, beisodat, 0 AS beisoa, beisox47 AS beisox, beisom47 AS beisom, beisoe47 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_4
UNION ALL
SELECT 48 AS betmhkey, beisodat, 0 AS beisoa, beisox48 AS beisox, beisom48 AS beisom, beisoe48 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_3
UNION ALL
SELECT 49 AS betmhkey, beisodat, 0 AS beisoa, beisox49 AS beisox, beisom49 AS beisom, beisoe49 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_2
UNION ALL
SELECT 50 AS betmhkey, beisodat, 0 AS beisoa, beisox50 AS beisox, beisom50 AS beisom, beisoe50 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso AS beiso_1
UNION ALL
SELECT 51 AS betmhkey, beprodate, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10,
0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14, 0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21,
0 AS Expr22, beprokra, beproposo, beprotropos
FROM ErmisUser.beprok
WHERE (beprostatus = 0)
GROUP BY beisodat

this code produces an invalid column name beisodat

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 05:33:47

no, it needs to be with the sums etc, as in...

select UrDateCOl, sum(col1), sum(col2)
from
(
Ur big scary union query
) t
group by UrDateCol

Em

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 06:06:07

I used

select betnhkey,UrDateCOl, sum(col1), sum(col2)
from
(
Ur big scary union query
) t
group by UrDateCol

and I get an error about betmhkey.

thnx for helping guys!

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 06:08:41

any column you add into the select that you don't put in an aggregate function (i.e. betnhkey / date coloumn etc) will need to go in the GROUP BY as well.

did you look at GROUP BY in Books Online?

Em

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-07 : 07:02:38

This query below works fine but I get Expr1,Expr2,...Expr25 as Column names.
I tried to use SUM(column1) AS column1 at the first line but it produces an error.

SELECT beisodat, SUM(beisoa) , SUM(beisox) , SUM(beisom) , SUM(beisoe) , SUM(beisopre) , SUM(beisocas) , SUM(beisocca) , SUM(beisoxre) , SUM(beisopax) , SUM(beisoepx) , SUM(beisocpx) , SUM(beisofpx) , SUM(beisorom) , SUM(beisoprx) , SUM(beisoxcc) , SUM(beisoxmc) , SUM(beisoxxr) , SUM(beisoxpi) , SUM(beisoxek) , SUM(beisoxpr) , SUM(beisore1) , SUM(beisore2) , SUM(beprokra) , SUM(beproposo) , SUM(beprotropos)
FROM
(
SELECT 1 AS betmhkey, beisodat, beisoa01 AS beisoa, beisox01 AS beisox, beisom01 AS beisom, beisoe01 AS beisoe, beisopre, beisocas, beisocca,
beisoxre, beisopax, beisoepx, beisocpx, beisofpx, beisorom, beisoprx, beisoxcc, beisoxmc, beisoxxr, beisoxpi, beisoxek, beisoxpr, beisore1,
beisore2, 0 AS beprokra, 0 AS beproposo, 0 AS beprotropos
FROM ErmisUser.beiso
UNION ALL
SELECT 2 AS betmhkey, beisodat, beisoa02 AS beisoa, beisox02 AS beisox, beisom02 AS beisom, beisoe02 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 3 AS betmhkey, beisodat, beisoa03 AS beisoa, beisox03 AS beisox, beisom03 AS beisom, beisoe03 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 4 AS betmhkey, beisodat, beisoa04 AS beisoa, beisox04 AS beisox, beisom04 AS beisom, beisoe04 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 5 AS betmhkey, beisodat, beisoa05 AS beisoa, beisox05 AS beisox, beisom05 AS beisom, beisoe05 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 6 AS betmhkey, beisodat, 0 AS beisoa, beisox06 AS beisox, beisom06 AS beisom, beisoe06 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 7 AS betmhkey, beisodat, 0 AS beisoa, beisox07 AS beisox, beisom07 AS beisom, beisoe07 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 8 AS betmhkey, beisodat, 0 AS beisoa, beisox08 AS beisox, beisom08 AS beisom, beisoe08 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 9 AS betmhkey, beisodat, 0 AS beisoa, beisox09 AS beisox, beisom09 AS beisom, beisoe09 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 10 AS betmhkey, beisodat, 0 AS beisoa, beisox10 AS beisox, beisom10 AS beisom, beisoe10 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 11 AS betmhkey, beisodat, 0 AS beisoa, beisox11 AS beisox, beisom11 AS beisom, beisoe11 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 12 AS betmhkey, beisodat, 0 AS beisoa, beisox12 AS beisox, beisom12 AS beisom, beisoe12 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 13 AS betmhkey, beisodat, 0 AS beisoa, beisox13 AS beisox, beisom13 AS beisom, beisoe13 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 14 AS betmhkey, beisodat, 0 AS beisoa, beisox14 AS beisox, beisom14 AS beisom, beisoe14 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 15 AS betmhkey, beisodat, 0 AS beisoa, beisox15 AS beisox, beisom15 AS beisom, beisoe15 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 16 AS betmhkey, beisodat, 0 AS beisoa, beisox16 AS beisox, beisom16 AS beisom, beisoe16 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 17 AS betmhkey, beisodat, 0 AS beisoa, beisox17 AS beisox, beisom17 AS beisom, beisoe17 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 18 AS betmhkey, beisodat, 0 AS beisoa, beisox18 AS beisox, beisom18 AS beisom, beisoe18 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 19 AS betmhkey, beisodat, 0 AS beisoa, beisox19 AS beisox, beisom19 AS beisom, beisoe19 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 20 AS betmhkey, beisodat, 0 AS beisoa, beisox20 AS beisox, beisom20 AS beisom, beisoe20 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 21 AS betmhkey, beisodat, 0 AS beisoa, beisox21 AS beisox, beisom21 AS beisom, beisoe21 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 22 AS betmhkey, beisodat, 0 AS beisoa, beisox22 AS beisox, beisom22 AS beisom, beisoe22 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 23 AS betmhkey, beisodat, 0 AS beisoa, beisox23 AS beisox, beisom23 AS beisom, beisoe23 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 24 AS betmhkey, beisodat, 0 AS beisoa, beisox24 AS beisox, beisom24 AS beisom, beisoe24 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 25 AS betmhkey, beisodat, 0 AS beisoa, beisox25 AS beisox, beisom25 AS beisom, beisoe25 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 26 AS betmhkey, beisodat, 0 AS beisoa, beisox26 AS beisox, beisom26 AS beisom, beisoe26 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 27 AS betmhkey, beisodat, 0 AS beisoa, beisox27 AS beisox, beisom27 AS beisom, beisoe27 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 28 AS betmhkey, beisodat, 0 AS beisoa, beisox28 AS beisox, beisom28 AS beisom, beisoe28 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 29 AS betmhkey, beisodat, 0 AS beisoa, beisox29 AS beisox, beisom29 AS beisom, beisoe29 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 30 AS betmhkey, beisodat, 0 AS beisoa, beisox30 AS beisox, beisom30 AS beisom, beisoe30 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 31 AS betmhkey, beisodat, 0 AS beisoa, beisox31 AS beisox, beisom31 AS beisom, beisoe31 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 32 AS betmhkey, beisodat, 0 AS beisoa, beisox32 AS beisox, beisom32 AS beisom, beisoe32 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 33 AS betmhkey, beisodat, 0 AS beisoa, beisox33 AS beisox, beisom33 AS beisom, beisoe33 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 34 AS betmhkey, beisodat, 0 AS beisoa, beisox34 AS beisox, beisom34 AS beisom, beisoe34 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 35 AS betmhkey, beisodat, 0 AS beisoa, beisox35 AS beisox, beisom35 AS beisom, beisoe35 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 36 AS betmhkey, beisodat, 0 AS beisoa, beisox36 AS beisox, beisom36 AS beisom, beisoe36 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 37 AS betmhkey, beisodat, 0 AS beisoa, beisox37 AS beisox, beisom37 AS beisom, beisoe37 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 38 AS betmhkey, beisodat, 0 AS beisoa, beisox38 AS beisox, beisom38 AS beisom, beisoe38 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 39 AS betmhkey, beisodat, 0 AS beisoa, beisox39 AS beisox, beisom39 AS beisom, beisoe39 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 40 AS betmhkey, beisodat, 0 AS beisoa, beisox40 AS beisox, beisom40 AS beisom, beisoe40 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 41 AS betmhkey, beisodat, 0 AS beisoa, beisox41 AS beisox, beisom41 AS beisom, beisoe41 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 42 AS betmhkey, beisodat, 0 AS beisoa, beisox42 AS beisox, beisom42 AS beisom, beisoe42 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 43 AS betmhkey, beisodat, 0 AS beisoa, beisox43 AS beisox, beisom43 AS beisom, beisoe43 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 44 AS betmhkey, beisodat, 0 AS beisoa, beisox44 AS beisox, beisom44 AS beisom, beisoe44 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 45 AS betmhkey, beisodat, 0 AS beisoa, beisox45 AS beisox, beisom45 AS beisom, beisoe45 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 46 AS betmhkey, beisodat, 0 AS beisoa, beisox46 AS beisox, beisom46 AS beisom, beisoe46 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 47 AS betmhkey, beisodat, 0 AS beisoa, beisox47 AS beisox, beisom47 AS beisom, beisoe47 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 48 AS betmhkey, beisodat, 0 AS beisoa, beisox48 AS beisox, beisom48 AS beisom, beisoe48 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 49 AS betmhkey, beisodat, 0 AS beisoa, beisox49 AS beisox, beisom49 AS beisom, beisoe49 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 50 AS betmhkey, beisodat, 0 AS beisoa, beisox50 AS beisox, beisom50 AS beisom, beisoe50 AS beisoe, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3,
0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10, 0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14,
0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21
FROM ErmisUser.beiso
UNION ALL
SELECT 51 AS betmhkey, beprodate, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6, 0 AS Expr7, 0 AS Expr8, 0 AS Expr9, 0 AS Expr10,
0 AS Expr11, 0 AS Expr12, 0 AS Expr13, 0 AS Expr14, 0 AS Expr15, 0 AS Expr16, 0 AS Expr17, 0 AS Expr18, 0 AS Expr19, 0 AS Expr20, 0 AS Expr21,
0 AS Expr22, beprokra, beproposo, beprotropos
FROM ErmisUser.beprok
) t

GROUP BY beisodat

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 07:05:39

you'd need to say...

SELECT beisodat, SUM(beisoa) as beisoa, SUM(beisox) as beisox, etc....

Em

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources