help me Calling Sql Experts, Urgent Help

[Raja123]

yelp 

antha pedda sql aite loveindia ne correct ga chepagaladu anta

[4Vikram]

K

GM spammer Vaishali 

[4Vikram]

bhayaaa , 4vikram ki nuvve training ichavaaa? heard that your training is good.

aina kinda train aite itla nduku unta man 

[Appaji]

antha pedda sql aite loveindia ne correct ga chepagaladu anta

aithe vaake 

[Raja123]

aina kinda train aite itla nduku unta man 

[arshad]

poduna nunchi idane unav gintha aina help seyale, kanisam chesetolani nduku man ila gelkutaru 

 

gippude soosna.... office la pani kooda chesta nenu
 

[loveindia]

call me now man... we will fix it...

[loveindia]

antha pedda sql aite loveindia ne correct ga chepagaladu anta

 

just given solution man.. 

[loveindia]

4 vikram, use this for @iregion multiple values man... good luck man.. 

 

DECLARE @iRegion VARCHAR(100) = '1,2,3,4,5,6'
 
SELECT iRegion
FROM ( SELECT iRegion = x.i.value('(./text())[1]', 'int') 
  FROM (SELECT [xml] = CONVERT(XML, '<i>'+ replace (@iRegion, ',', '</i><i>')
+'</i>').query('.') ) AS a 
CROSS APPLY [xml].nodes('i') AS x(i)
)AS y 
WHERE @iRegion IS NOT NULL

[4Vikram]

just given solution man.. 

 

 

 

4 vikram, use this for @iregion multiple values man... good luck man.. 

DECLARE @iRegion VARCHAR(100) = '1,2,3,4,5,6'
 
SELECT iRegion
FROM ( SELECT iRegion = x.i.value('(./text())[1]', 'int') 
  FROM (SELECT [xml] = CONVERT(XML, '<i>'+ replace (@iRegion, ',', '</i><i>')
+'</i>').query('.') ) AS a 
CROSS APPLY [xml].nodes('i') AS x(i)
)AS y 
WHERE @iRegion IS NOT NULL

thank you bhaiyya.... you rock 

[Raja123]

just given solution man.. 

[loveindia]

thank you bhaiyya.... you rock 

 

SQL Rocks man not me... 

[4Vikram]

SQL Rocks man not me... 

if SQL rocks you are that Rock Hitter man 

[loveindia]

if SQL rocks you are that Rock Hitter man

You mean I am rallu kottukuney vaadu aa man...

[4Vikram]

You mean I am rallu kottukuney vaadu aa man...

no man i not that mean man.. i said thatuu, if sql is rock then you are rock breaker man for suppose if sql is diamond, you are that diamond shaper man... if examples given like this will go on man....