Click here to Skip to main content
15,434,219 members
Home / Discussions / Database
   

Database

 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 21:39
Memberpmarfleet11-Oct-07 21:39 
Questionupdate database(urgently) Pin
Milind Panchal10-Oct-07 22:51
MemberMilind Panchal10-Oct-07 22:51 
AnswerRe: update database(urgently) Pin
N a v a n e e t h10-Oct-07 23:09
MemberN a v a n e e t h10-Oct-07 23:09 
AnswerRe: update database(urgently) Pin
Rob Philpott11-Oct-07 4:46
MemberRob Philpott11-Oct-07 4:46 
Questionis the order of parameters addition to a command for update command realy required? Pin
nicolus10-Oct-07 20:23
Membernicolus10-Oct-07 20:23 
AnswerRe: is the order of parameters addition to a command for update command realy required? Pin
John Gathogo11-Oct-07 4:54
MemberJohn Gathogo11-Oct-07 4:54 
QuestionComplex Query Pin
Aavesh Agarwal10-Oct-07 20:21
MemberAavesh Agarwal10-Oct-07 20:21 
AnswerRe: Complex Query Pin
_Damian S_10-Oct-07 20:50
professional_Damian S_10-Oct-07 20:50 
This will give you what you are after, but will take a long time to run if your table is large, as it executes the subquery once for each line.

select EmpNo, EmpName,
(select sum(EmpSalary) from emp e2 where e2.EmpNo <= e1.EmpNo)
from emp e1
order by e1.EmpNo

Hope that helps!!

-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!

GeneralRe: Complex Query Pin
Aavesh Agarwal10-Oct-07 21:03
MemberAavesh Agarwal10-Oct-07 21:03 
GeneralRe: Complex Query Pin
Rob Philpott11-Oct-07 4:40
MemberRob Philpott11-Oct-07 4:40 
QuestionHow to use Form Authentication in SSRS Pin
krishbasu10-Oct-07 19:47
Memberkrishbasu10-Oct-07 19:47 
Questionwhile poop in stored procedure Pin
Sonia Gupta10-Oct-07 18:47
MemberSonia Gupta10-Oct-07 18:47 
AnswerRe: while poop in stored procedure Pin
joemonvarghese10-Oct-07 19:15
Memberjoemonvarghese10-Oct-07 19:15 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 19:17
MemberSonia Gupta10-Oct-07 19:17 
GeneralRe: while poop in stored procedure Pin
Christian Graus10-Oct-07 19:31
mveChristian Graus10-Oct-07 19:31 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 19:40
MemberSonia Gupta10-Oct-07 19:40 
GeneralRe: while poop in stored procedure Pin
Joe10-Oct-07 20:04
Member Joe10-Oct-07 20:04 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 20:27
MemberSonia Gupta10-Oct-07 20:27 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h10-Oct-07 22:54
MemberN a v a n e e t h10-Oct-07 22:54 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 23:43
MemberSonia Gupta10-Oct-07 23:43 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h11-Oct-07 0:39
MemberN a v a n e e t h11-Oct-07 0:39 
GeneralRe: while poop in stored procedure Pin
joemonvarghese10-Oct-07 19:48
Memberjoemonvarghese10-Oct-07 19:48 
Questionan intersting sql problem Pin
richardye10-Oct-07 18:46
Memberrichardye10-Oct-07 18:46 
AnswerRe: an intersting sql problem Pin
GuyThiebaut10-Oct-07 22:53
professionalGuyThiebaut10-Oct-07 22:53 
AnswerHow to shrink a transaction log - and make sure that it actually shrinks. Pin
GuyThiebaut10-Oct-07 23:04
professionalGuyThiebaut10-Oct-07 23:04 

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.