Click here to Skip to main content
15,851,915 members
Home / Discussions / Database
   

Database

 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
Kujtim Hyseni23-Jun-12 2:02
Kujtim Hyseni23-Jun-12 2:02 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
jschell24-Jun-12 13:17
jschell24-Jun-12 13:17 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
Kujtim Hyseni24-Jun-12 23:45
Kujtim Hyseni24-Jun-12 23:45 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
jschell25-Jun-12 10:34
jschell25-Jun-12 10:34 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
Kujtim Hyseni25-Jun-12 11:35
Kujtim Hyseni25-Jun-12 11:35 
GeneralRe: Cannot Register New Server in SQL Server 2008 Pin
jschell26-Jun-12 9:09
jschell26-Jun-12 9:09 
AnswerRe: Cannot Register New Server in SQL Server 2008 Pin
Eddy Vluggen25-Jun-12 2:23
professionalEddy Vluggen25-Jun-12 2:23 
QuestionInserting rows dynamiccaly on based on calculation Pin
vkap20-Jun-12 12:45
vkap20-Jun-12 12:45 
I have a db with following values :
col1 col2 col3 position
aaa rack1 1-3 3
bbb rack2 22-23 2
ccc rack3 19-20 2

Output should be
col1 col2 col3 position
aaa rack1 1-3 1
aaa rack1 1-3 2
aaa rack1 1-3 3
bbb rack2 22-23 22
bbb rack2 22-23 23
ccc rack3 19-20 19
ccc rack3 19-20 20

Basically, its taking the position and creating a row for each value from col3.

Can i do this on-fly and create a temp table? or i have to create a procedure?

thanks!!!
VK
AnswerRe: Inserting rows dynamiccaly on based on calculation Pin
Mycroft Holmes20-Jun-12 14:05
professionalMycroft Holmes20-Jun-12 14:05 
AnswerRe: Inserting rows dynamiccaly on based on calculation Pin
__TR__3-Jul-12 21:41
__TR__3-Jul-12 21:41 
Questionlan chat software Pin
Member 913183919-Jun-12 2:42
Member 913183919-Jun-12 2:42 
AnswerRe: lan chat software Pin
Richard MacCutchan19-Jun-12 3:01
mveRichard MacCutchan19-Jun-12 3:01 
AnswerRe: lan chat software Pin
Eddy Vluggen19-Jun-12 3:36
professionalEddy Vluggen19-Jun-12 3:36 
AnswerRe: lan chat software Pin
Paul Conrad19-Jun-12 9:19
professionalPaul Conrad19-Jun-12 9:19 
QuestionError 1064,.... please Help Pin
Jassim Rahma16-Jun-12 1:10
Jassim Rahma16-Jun-12 1:10 
AnswerRe: Error 1064,.... please Help Pin
Mycroft Holmes16-Jun-12 4:14
professionalMycroft Holmes16-Jun-12 4:14 
Questionif - else statement in sql Pin
begg15-Jun-12 9:36
begg15-Jun-12 9:36 
AnswerRe: if - else statement in sql Pin
Corporal Agarn15-Jun-12 9:41
professionalCorporal Agarn15-Jun-12 9:41 
AnswerRe: if - else statement in sql Pin
Michael Potter15-Jun-12 11:18
Michael Potter15-Jun-12 11:18 
AnswerRe: if - else statement in sql Pin
vvashishta18-Jun-12 20:49
vvashishta18-Jun-12 20:49 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 6:31
rimazuc20-Jun-12 6:31 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 6:40
rimazuc20-Jun-12 6:40 
AnswerRe: if - else statement in sql Pin
hearthofmine24-Jun-12 23:33
hearthofmine24-Jun-12 23:33 
QuestionHow can i select all dates between date range? Pin
RA|-|UL PATEL15-Jun-12 4:30
RA|-|UL PATEL15-Jun-12 4:30 
AnswerRe: How can i select all dates between date range? Pin
bobrien10015-Jun-12 9:11
bobrien10015-Jun-12 9:11 

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.