How to filter this one by date

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 filter this one by date

Author

Topic

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-11 : 05:48:32

How can I make sql server show only the rows with the date I enter?
Here is the view :

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)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-11 : 05:55:21

SELECT * FROM (
... your query here
) AS d
WHERE beisodat ...something...

This has been suggested to you before.
Please remember what we have helped you with before.

If you want some optimization you have to add the date filtering for each and one select statement.

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

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-11 : 05:55:46

am assuming this is a follow on from
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93792&whichpage=1

you just need to add a where clause on the outside of the query. something like below...

(have assumed the same date column you wanted to group by)


SELECT beisodat, SUM(beisoa) AS beisoa, SUM(beisox) AS beisox, SUM(beisom) AS beisom, SUM(beisoe) AS beisoe, SUM(beisopre) AS beisopre, SUM(beisocas) AS beisocas, SUM(beisocca) AS beisocca, SUM(beisoxre) AS beisoxre, SUM(beisopax) AS beisopax, SUM(beisoepx) AS beisoepx, SUM(beisocpx) AS beisocpx, SUM(beisofpx) AS beisofpx, SUM(beisorom) AS beisorom, SUM(beisoprx) AS beisoprx, SUM(beisoxcc) AS beisoxcc, SUM(beisoxmc) AS beisoxmc, SUM(beisoxxr) AS beisoxxr, SUM(beisoxpi) AS beisoxpi, SUM(beisoxek) AS beisoxek, SUM(beisoxpr) AS beisoxpr, SUM(beisore1) AS beisore1, SUM(beisore2) AS beisore2, SUM(beprokra) AS beprokra, SUM(beproposo) AS beproposo, SUM(beprotropos) AS beprotropos

FROM
(
your big scary union query thing...
) t
where beisodat = UrDate
GROUP BY beisodat

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-11 : 06:15:59

Peso and other people.Thnx a lot for your help and understanding.I am an amateur uppon sql language.
I tried your query entering WHERE beisodat = 10/4/2007 but I get a view with null fields.beisodat field has also the time included.Maybe I should included too.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-11 : 06:17:12

SELECT beisodat, SUM(beisoa) AS beisoa, SUM(beisox) AS beisox, SUM(beisom) AS beisom, SUM(beisoe) AS beisoe, SUM(beisopre) AS beisopre, SUM(beisocas) AS beisocas, SUM(beisocca) AS beisocca, SUM(beisoxre) AS beisoxre, SUM(beisopax) AS beisopax, SUM(beisoepx) AS beisoepx, SUM(beisocpx) AS beisocpx, SUM(beisofpx) AS beisofpx, SUM(beisorom) AS beisorom, SUM(beisoprx) AS beisoprx, SUM(beisoxcc) AS beisoxcc, SUM(beisoxmc) AS beisoxmc, SUM(beisoxxr) AS beisoxxr, SUM(beisoxpi) AS beisoxpi, SUM(beisoxek) AS beisoxek, SUM(beisoxpr) AS beisoxpr, SUM(beisore1) AS beisore1, SUM(beisore2) AS beisore2, SUM(beprokra) AS beprokra, SUM(beproposo) AS beproposo, SUM(beprotropos) AS beprotropos

FROM
(
your big scary union query thing...
) t
where beisodat >= '20071210' AND beisodat < '20071211'

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

skiabox
Posting Yak Master

169 Posts

Posted - 2007-12-11 : 07:11:29

thnx a lot Peso!that format (yyyymmdd) worked like a charm!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-11 : 07:50:16

quote:
Originally posted by skiabox

thnx a lot Peso!that format (yyyymmdd) worked like a charm!

Thats the universal format which works fine regardless of the server's date settings. You should always express dates in that format to avoid error/ambiguity

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources