Jeff Moden (7/3/2010)

---

Ah... I believe I see... the forum code (or something else) added a spurious ^C_R character. If you get rid of it, the previous code works just...

I try not to use undocumented procedures in anything other than a "one time" thing. I got it right, but personally I wouldn't have done it like that 😉

Yes, I was just in the process of writing you...

Steven, can you please have a look at formatting your data and requested output into something we can read.

I think your source data should look like this: -

DECLARE @sourcetable AS...

I agree with Gianluca. But if you insist on doing it in SQL, it can be done like this

DECLARE @test-2 AS TABLE(

id INT IDENTITY,

...

DECLARE @test AS VARBINARY(MAX)

SET @test = 0x4858FE25053CA4D236F3D61AE29668BA

SELECT @test

,Substring(( MASTER.dbo.Fn_varbintohexstr(@test) ), 1, 2) +

Substring(Upper(MASTER.dbo.Fn_varbintohexstr(@test)), 3, 8000)

I'm still learning SQL, so what I'll show below is definately not the best way to do this :hehe:

DECLARE @xml AS XML

SET @xml ='<ITEM RESPONDENT_ID="2" Business_Account_Name="ElectroDom" Category="Director" />'

DECLARE @pseudoxml VARCHAR(8000)

SET...

JoyKing (6/29/2010)

---

Xml data:

<ITEM RESPONDENT_ID="2" Business_Account_Name="ElectroDom" Category="Director" />

Required Output:

Respondent_id Business_Account_Name Category

2 ...

Paul, that's great! I was hoping that when the other thread about this came up one of you gurus would come in and shatter my little code. There's always more...

That query is doing exactly what you're asking it to 😉

SELECT SUM(a.t_data)

FROM (SELECT TOP 4...

captcrotch (6/25/2010)

---

well thanks for the response skcadavre but the data given is just example data, I need a general query to retrieve data following the logic I gave, whatever is...

Why would both 6 and 4 be returned if you want the...

Damn, confused me, went with A,B,C 😛

I'll happily discuss that with the OP if he ever reports back, but I'm fairly certain that the error is in the expected result he posted here rather than in...

I'm no longer at work, so can't do any testing, but. . . can you setup a trigger on "set langauge" then have a case statement that checks the current...