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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-08 : 09:44:50
|
| ramsatish writes "1)I wrote a query which retreives 5 different dates. (select top 5 monthyear from monthyear table)2)I want to store these dates in an array variable and i want tocheck the employees who joined in these dates and i want to check different conditions based on these dates.My requirement is I want to get each date in an array,and I want to check different conditions based on this dates.Thanks in advance" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-08 : 09:55:12
|
| The SQL Server lacks array concept but you can workaround it by using table variables.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-08 : 10:01:40
|
| TOP 5 ordered by what?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Regarding ( Date Time) array