Click here to Skip to main content
13,044,428 members (124,502 online)
   

Database

 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Aner Bautista3-May-13 8:25
memberAner Bautista3-May-13 8:25 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell3-May-13 11:24
memberjschell3-May-13 11:24 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Eddy Vluggen1-May-13 6:37
mvpEddy Vluggen1-May-13 6:37 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell1-May-13 8:28
memberjschell1-May-13 8:28 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
Richard Deeming1-May-13 8:43
professionalRichard Deeming1-May-13 8:43 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
GuyThiebaut1-May-13 9:19
memberGuyThiebaut1-May-13 9:19 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pin
jschell2-May-13 7:59
memberjschell2-May-13 7:59 
Questionhow to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 3:49
groupmehdi.sabet1-May-13 3:49 
hi to all
i have a while loop like this
declare @Counter int
while(@Counter<1000)
 begin
  set @Counter = @Counter + 1
  select * from mytable where [my where clause]
 end
 

my where cluase change in each repeat.

i want to union all result to a table and return one table as query result
how can i do this ?
performance is very important for me
because while loop can be run for upper 15000
thanks for any help
AnswerRe: how to union some table in a while loop to a table Pin
Richard Deeming1-May-13 3:57
professionalRichard Deeming1-May-13 3:57 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 4:10
groupmehdi.sabet1-May-13 4:10 
GeneralRe: how to union some table in a while loop to a table Pin
GuyThiebaut1-May-13 4:31
memberGuyThiebaut1-May-13 4:31 
GeneralRe: how to union some table in a while loop to a table Pin
Richard Deeming1-May-13 4:33
professionalRichard Deeming1-May-13 4:33 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 5:04
groupmehdi.sabet1-May-13 5:04 
AnswerRe: how to union some table in a while loop to a table Pin
djj551-May-13 4:20
memberdjj551-May-13 4:20 
GeneralRe: how to union some table in a while loop to a table Pin
mehdi.sabet1-May-13 4:26
groupmehdi.sabet1-May-13 4:26 
GeneralRe: how to union some table in a while loop to a table Pin
Eddy Vluggen1-May-13 4:59
mvpEddy Vluggen1-May-13 4:59 
QuestionSSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 19:47
memberRichard.Berry10030-Apr-13 19:47 
AnswerRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 21:56
memberGuyThiebaut30-Apr-13 21:56 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 22:16
memberRichard.Berry10030-Apr-13 22:16 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 22:43
memberGuyThiebaut30-Apr-13 22:43 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 23:18
memberRichard.Berry10030-Apr-13 23:18 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 23:34
memberGuyThiebaut30-Apr-13 23:34 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 0:10
memberRichard.Berry1001-May-13 0:10 
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 1:57
memberRavikiran72p30-Apr-13 1:57 
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 9:49
mvpEddy Vluggen30-Apr-13 9:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 21 Jul 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid