Click here to Skip to main content
15,561,246 members
Home / Discussions / Database
   

Database

 
Questiondecimal not show zero [modified] Pin
tai-fun12-Jul-08 4:38
tai-fun12-Jul-08 4:38 
AnswerRe: decimal not show zero Pin
leoinfo12-Jul-08 8:07
leoinfo12-Jul-08 8:07 
Questionrow to column in sql Pin
ravindra_ee24811-Jul-08 20:58
ravindra_ee24811-Jul-08 20:58 
AnswerRe: row to column in sql Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:55
professionalVimalsoft(Pty) Ltd13-Jul-08 16:55 
QuestionMail Triggering in SQL_Server Problem Pin
sabaMCA11-Jul-08 14:43
sabaMCA11-Jul-08 14:43 
AnswerRe: Mail Triggering in SQL_Server Problem Pin
Vimalsoft(Pty) Ltd12-Jul-08 12:11
professionalVimalsoft(Pty) Ltd12-Jul-08 12:11 
QuestionMail Triggering in SQL_Server Problem Pin
sabaMCA11-Jul-08 14:42
sabaMCA11-Jul-08 14:42 
QuestionHow to store stored proc results to a temp table Pin
DotNetXenon11-Jul-08 11:52
DotNetXenon11-Jul-08 11:52 
insert into #temp exec dbo.MyStoredProc 89,1
(MyStoredProc requires 2 integer parameters.)

The above works fine but in my stored proc where I write this insert statement, I need to create the #temp table and MyStoredProc results in 100 columns.
Only 5 columns have to be stored in #temp.

I need something like below. (As you would know, am making it clear, below does not work!!)
select col1,col2,col3,col4 into #temp
exec dbo.MyStoredProc 89,1

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

AnswerRe: How to store stored proc results to a temp table Pin
Vimalsoft(Pty) Ltd12-Jul-08 12:17
professionalVimalsoft(Pty) Ltd12-Jul-08 12:17 
GeneralSQL Server connection timeout [modified] Pin
dlarkin7711-Jul-08 4:44
dlarkin7711-Jul-08 4:44 
GeneralRe: SQL Server connection timeout Pin
Simon P Stevens11-Jul-08 4:48
Simon P Stevens11-Jul-08 4:48 
GeneralRe: SQL Server connection timeout Pin
SimulationofSai11-Jul-08 5:07
SimulationofSai11-Jul-08 5:07 
GeneralRe: SQL Server connection timeout Pin
dlarkin7711-Jul-08 5:26
dlarkin7711-Jul-08 5:26 
GeneralRe: SQL Server connection timeout Pin
Member 9611-Jul-08 6:46
Member 9611-Jul-08 6:46 
GeneralRe: SQL Server connection timeout Pin
Tomz_KV11-Jul-08 6:48
Tomz_KV11-Jul-08 6:48 
QuestionSystem IP in Stored Procedure Pin
Member 400849210-Jul-08 19:51
Member 400849210-Jul-08 19:51 
AnswerRe: System IP in Stored Procedure Pin
N a v a n e e t h10-Jul-08 23:46
N a v a n e e t h10-Jul-08 23:46 
AnswerRe: System IP in Stored Procedure Pin
DerekFL11-Jul-08 5:50
DerekFL11-Jul-08 5:50 
QuestionInserting data into xml column Pin
DerekFL10-Jul-08 10:45
DerekFL10-Jul-08 10:45 
AnswerRe: Inserting data into xml column Pin
leoinfo10-Jul-08 17:31
leoinfo10-Jul-08 17:31 
JokeRe: Inserting data into xml column Pin
leoinfo10-Jul-08 17:39
leoinfo10-Jul-08 17:39 
GeneralRe: Inserting data into xml column Pin
DerekFL11-Jul-08 5:18
DerekFL11-Jul-08 5:18 
QuestionDTS Stopped working after motherboard change Pin
FrankLepkowski10-Jul-08 9:33
FrankLepkowski10-Jul-08 9:33 
AnswerRe: DTS Stopped working after motherboard change Pin
DerekFL10-Jul-08 9:53
DerekFL10-Jul-08 9:53 
GeneralRe: DTS Stopped working after motherboard change Pin
FrankLepkowski10-Jul-08 9:54
FrankLepkowski10-Jul-08 9:54 

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.