Click here to Skip to main content
16,016,076 members
Home / Discussions / Database
   

Database

 
GeneralRe: Stored procedure = Unit of work? Pin
AliasElias30-Jun-08 12:11
AliasElias30-Jun-08 12:11 
QuestionHow to monitor query in Pervasive.sql . Please help me it is very urgent for me Pin
Akash Agarwal29-Jun-08 23:59
Akash Agarwal29-Jun-08 23:59 
Questionselect count query(2 field) Pin
kabirkhan29-Jun-08 20:06
kabirkhan29-Jun-08 20:06 
AnswerRe: select count query(2 field) Pin
meeram39530-Jun-08 0:28
meeram39530-Jun-08 0:28 
AnswerRe: select count query(2 field) Pin
ChandraRam30-Jun-08 0:49
ChandraRam30-Jun-08 0:49 
QuestionGetting blank pages while exporting data into pdf format using SSRS 2005 Pin
prabhakaranns29-Jun-08 8:01
prabhakaranns29-Jun-08 8:01 
QuestionInserting into table from cursor Pin
iamdking28-Jun-08 21:41
iamdking28-Jun-08 21:41 
AnswerRe: Inserting into table from cursor Pin
Mycroft Holmes28-Jun-08 21:50
professionalMycroft Holmes28-Jun-08 21:50 
Presumably SQL server and I hope 2005

Declare @Tbl Table(Field1 int, Field2 varchar(20))

Insert @Tbl
Select Field1, Field2
From SomeTable

You now have a table var with your data - use a while or cursor to do your processing


Never underestimate the power of human stupidity
RAH

Question"Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 4:39
francoisdotnet28-Jun-08 4:39 
AnswerRe: "Stock Recon" type query .. most efficient route? Pin
Paul Conrad28-Jun-08 8:05
professionalPaul Conrad28-Jun-08 8:05 
GeneralRE: "Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 12:03
francoisdotnet28-Jun-08 12:03 
GeneralRe: RE: "Stock Recon" type query .. most efficient route? Pin
Paul Conrad28-Jun-08 12:32
professionalPaul Conrad28-Jun-08 12:32 
AnswerRe: "Stock Recon" type query .. most efficient route? Pin
Pete O'Hanlon28-Jun-08 10:57
mvePete O'Hanlon28-Jun-08 10:57 
GeneralRe: "Stock Recon" type query .. most efficient route? Pin
francoisdotnet28-Jun-08 12:06
francoisdotnet28-Jun-08 12:06 
QuestionCount all posts added before or in a specific month Pin
Sunday8PM28-Jun-08 2:38
Sunday8PM28-Jun-08 2:38 
AnswerRe: Count all posts added before or in a specific month Pin
Paul Conrad28-Jun-08 8:08
professionalPaul Conrad28-Jun-08 8:08 
GeneralRe: Count all posts added before or in a specific month Pin
Sunday8PM28-Jun-08 9:06
Sunday8PM28-Jun-08 9:06 
AnswerRe: Count all posts added before or in a specific month [modified] Pin
Luc Pattyn28-Jun-08 9:48
sitebuilderLuc Pattyn28-Jun-08 9:48 
GeneralRe: Count all posts added before or in a specific month Pin
Sunday8PM28-Jun-08 12:23
Sunday8PM28-Jun-08 12:23 
QuestionHelp in writting query Pin
Saiyed Alam27-Jun-08 22:20
Saiyed Alam27-Jun-08 22:20 
AnswerRe: Help in writting query Pin
subai28-Jun-08 20:17
subai28-Jun-08 20:17 
AnswerRe: Help in writting query Pin
Mycroft Holmes28-Jun-08 21:54
professionalMycroft Holmes28-Jun-08 21:54 
GeneralRe: Help in writting query Pin
Kjetil Svendsen1-Jul-08 10:44
Kjetil Svendsen1-Jul-08 10:44 
QuestionSQL Reporting 2005 (SSRS) Matrix Subtotal Color condition Pin
Member 384432027-Jun-08 10:59
Member 384432027-Jun-08 10:59 
QuestionDatabase logic... Pin
KORCARI27-Jun-08 5:10
KORCARI27-Jun-08 5:10 

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.