Use the tags [ code="xml" ] and [ /code ] without the spaces 😉

declare @appro_xml xml ;

set @appro_xml='

1020

210

11

12

14

15

'

select

x.col.value('SolicitationID[1]','INT')AS request_id ,

x.col.value('DeclineReasonCode[1]','varchar(500)')AS DeclineReasonCode

FROM @appro_xml.nodes('//ScoreAndDataRetrievalRequest') x(col)

--CROSS APPLY col.nodes('DeclineReasonCode')...

Hi

I just tried your script. Since I don't specify either "-T" or "-U user -P pwd" I also get an error. Try this to connect to a server by windows...

Why do you need the cursor? Try to use the Sql2k5 XML functions:

DECLARE @source TABLE (Id INT, Data XML)

INSERT INTO @source

...

You don't specify any authentication information in your command line string.

Greets

Flo

Derek Dongray (4/23/2009)

---

Sorry to put a fly in the ointment, but I've tried a variation on your double-barrelled tally solution based on a problem mentioned here (splitting sentences into words...

Hi Bob

Bob Hovious (4/22/2009)

---

I've got a minor tweak to the double-barrelled tally solution. I think it's running consistently quicker in elapsed time, but sometimes my laptop has the older...

Hi

Try this:

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = ISNULL(@sql, '') + 'USE ' + name + '

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET @start_dt = ''2008-10-01 00:00:00.000''

SET @end_dt = ''2008-12-31...

Great solution Mark! 🙂

doran_doran (4/22/2009)

---

wayne, where r u? I attached both sql to create tables and data. I can create exact logic in .net but I like to do it in sql server...

Hi Doran

As first, I took your attached SQL Scripts and just surround with [ code ] and [ /code ] (no spaces) for better reading for other people ;-).

CREATE TABLE...

Hi Lynn

Not containing all the different functions. If you want, I can try...

Hi Barry!

Yeah! Looks like the second youth of "Tally" 🙂

Sure you are right, a Tally should have a fillfactor of 100. Forgive me for my tests ;-).

@bob-2:

Your test results on your laptop look quiet strange to me (maybe time...

Hi Gus (hope I am allowed to call you Gus)

I just tried again and I think I figured out the problem. It depends on the C# code. As long as...

Matt Miller (4/22/2009)

---

Isn't 0 the successful return code in a C# process? In which case is it simply that because it gets that back, is simply doesn't look for...