Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
programer
Posting Yak Master
221 Posts |
Posted - 2013-09-27 : 07:49:44
|
DECLARE @strValues varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,id)FROM tbl_BetSlipEventswhere id IN (175,205)select @strValuesI need to used row_number where =1,2,3Please help |
|
programer
Posting Yak Master
221 Posts |
Posted - 2013-09-27 : 08:20:29
|
I tried:DECLARE @strValues varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,ID)FROM (Select row_number() over(order by id) as Number from tbl_BetSlipEvents) as aWhere a.Number IN (1,2)select @strValuesreturnsMsg 207, Level 16, State 1, Line 2Invalid column name 'ID'.quote: Originally posted by programer DECLARE @strValues varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,id)FROM tbl_BetSlipEventswhere id IN (175,205)select @strValuesI need to used row_number where =1,2,3Please help
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-27 : 08:24:19
|
Add id also as a column in the inner query:DECLARE @strValues varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,ID)FROM (Select row_number() over(order by id) as Number, ID from tbl_BetSlipEvents) as aWhere a.Number IN (1,2)select @strValues |
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2013-09-27 : 09:11:14
|
DECLARE @strValues varchar(100)DECLARE @BetSlipEventId varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,ID)FROM (Select row_number() over(order by id) as Number, ID from tbl_BetSlipEvents) as aWhere a.Number IN (1,2)select @BetSlipEventId,@strValuesInsert into tbl_BetSlipSystem(BetSlipEventId,SystemBet)select @BetSlipEventId,@strValuesCheck now I need from tbl_BetSlipEvents to get in second table BetSlipSystem.BetSlipEventIdquote: Originally posted by James K Add id also as a column in the inner query:DECLARE @strValues varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,ID)FROM (Select row_number() over(order by id) as Number, ID from tbl_BetSlipEvents) as aWhere a.Number IN (1,2)select @strValues
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-09-27 : 09:19:24
|
FYI In this case the COALESCE could be replace by ISNULL. Just another way of doing the same thing.djj |
|
|
programer
Posting Yak Master
221 Posts |
Posted - 2013-09-27 : 09:25:05
|
Look this:DECLARE @strValues varchar(100)DECLARE @BetSlipEventId varchar(100)SELECT @strValues = COALESCE(@strValues+',', '') + CONVERT(varchar,ID)FROM (Select row_number() over(order by id) as Number, ID,BetSlipDetailId from tbl_BetSlipEvents) as aWhere a.Number IN (1,2)select @strValuesInsert into tbl_BetSlipSystem(BetSlipEventId,SystemBet)select @strValuesHow to insert tbl_BetSlipEvents.BetSlipDetailId to BetSlipSystem.BetSlipEventId ?quote: Originally posted by djj55 FYI In this case the COALESCE could be replace by ISNULL. Just another way of doing the same thing.djj
|
|
|
|
|
|
|
|