Click here to Skip to main content
       

Database

 
QuestionHow to get data from Gridview (gridview(checkbox)) using asp.net and c#...... Pingroupnukalarajesh1-May-13 22:19 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... PinmvpRichard MacCutchan1-May-13 22:27 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... PinmemberAANIL DHAKAD8-May-13 4:17 
Questionhow to upload a iamge file on web server in mvc4 asp.net c# Pingroupnukalarajesh1-May-13 22:06 
QuestionSQL Server null date 01/01/1900 possible issue - a question PinmemberGuyThiebaut1-May-13 6:51 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question PinprofessionalRichard Deeming1-May-13 7:04 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question PinmemberAner Bautista3-May-13 9:25 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pinmemberjschell3-May-13 12:24 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question PinmvpEddy Vluggen1-May-13 7:37 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question Pinmemberjschell1-May-13 9:28 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question PinprofessionalRichard Deeming1-May-13 9:43 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question PinmemberGuyThiebaut1-May-13 10:19 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pinmemberjschell2-May-13 8:59 
Questionhow to union some table in a while loop to a table Pingroupmehdi.sabet1-May-13 4: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 PinprofessionalRichard Deeming1-May-13 4:57 
GeneralRe: how to union some table in a while loop to a table Pingroupmehdi.sabet1-May-13 5:10 
GeneralRe: how to union some table in a while loop to a table PinmemberGuyThiebaut1-May-13 5:31 
GeneralRe: how to union some table in a while loop to a table PinprofessionalRichard Deeming1-May-13 5:33 
GeneralRe: how to union some table in a while loop to a table Pingroupmehdi.sabet1-May-13 6:04 
AnswerRe: how to union some table in a while loop to a table Pinmemberdjj551-May-13 5:20 
GeneralRe: how to union some table in a while loop to a table Pingroupmehdi.sabet1-May-13 5:26 
GeneralRe: how to union some table in a while loop to a table PinmvpEddy Vluggen1-May-13 5:59 
QuestionSSE 2008 R2 Backup Strategy [modified] PinmemberRichard.Berry10030-Apr-13 20:47 
AnswerRe: SSE 2008 R2 Backup Strategy PinmemberGuyThiebaut30-Apr-13 22:56 
GeneralRe: SSE 2008 R2 Backup Strategy PinmemberRichard.Berry10030-Apr-13 23:16 
GeneralRe: SSE 2008 R2 Backup Strategy PinmemberGuyThiebaut30-Apr-13 23:43 
GeneralRe: SSE 2008 R2 Backup Strategy PinmemberRichard.Berry1001-May-13 0:18 
GeneralRe: SSE 2008 R2 Backup Strategy PinmemberGuyThiebaut1-May-13 0:34 
GeneralRe: SSE 2008 R2 Backup Strategy PinmemberRichard.Berry1001-May-13 1:10 
QuestionGeneric column mapping PinmemberRavikiran72p30-Apr-13 2:57 
AnswerRe: Generic column mapping PinmvpEddy Vluggen30-Apr-13 10:49 
AnswerRe: Generic column mapping PinprofessionalMycroft Holmes30-Apr-13 14:56 
AnswerRe: Generic column mapping PinmemberGuyThiebaut30-Apr-13 22:49 
AnswerRe: Generic column mapping Pinmemberjschell1-May-13 9:34 
QuestionMariaDB on Linux Pinprofessionalmbadi27-Apr-13 11:57 
QuestionError on SQL server join Pinmemberdeveloper life26-Apr-13 14:12 
AnswerRe: Error on SQL server join Pinmembers_magus26-Apr-13 18:41 
AnswerRe: Error on SQL server join PinmemberAANIL DHAKAD8-May-13 20:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. [modified] PinmemberPrissySC26-Apr-13 13:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. PinprofessionalMycroft Holmes26-Apr-13 14:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. PinmemberPrissySC27-Apr-13 2:39 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pinmemberjschell27-Apr-13 12:32 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. PinmemberPrissySC28-Apr-13 2:41 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. PinprofessionalMycroft Holmes28-Apr-13 13:49 
AnswerAttached not seen over network still - will try ID values but .... PinmemberPrissySC7-May-13 8:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? PinmemberMember 767590023-Apr-13 7:31 
QuestionTrouble restoring a mysql database Pinmembersavedlema22-Apr-13 8:21 
AnswerRe: Trouble restoring a mysql database PinprofessionalBernhard Hiller22-Apr-13 22:33 
GeneralRe: Trouble restoring a mysql database Pinmembersavedlema2-May-13 0:44 
QuestionBack up database Error Pinmembersara-setare20-Apr-13 22:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid