No, the order is predictable especially if you supress parallelism with MAXDOP... please see the following article...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

... and just say "NO" to cursors 😛

Heh... yeech... you can use a cursor, if you like... here's your's with the fix...

DECLARE @MyCmd VARCHAR(100)

declare @database nvarchar(128)

declare mycursor CURSOR LOCAL

FOR select name from master.dbo.sysdatabases where dbid>5

OPEN mycursor

fetch...

Yes there is... you will need to build a BCP Format File, but it's worth it for the sheer speed of Bulk Insert...

The format file would look something like this...

8.0

4

1...

Hi Bill,

I'm a little confused by the data you've posted. Take a look at the URL I carry in my signature line... providing data and table info in that...

Sorry, Simon......

Not with 60 points in 79 visits, you haven't 😉

Sorry, my mistake... you don't need a CASE at all...

DECLARE @DemoTable TABLE (Amount VARCHAR(15))

INSERT INTO @DemoTable (Amount)

SELECT '$102.50' UNION ALL

SELECT '-$57.75'

SELECT REPLACE(STR(ABS(CAST(Amount AS MONEY)*100.0),8),' ','0')

...

Don't need a case statement to figure the zero's...

DECLARE @DemoTable TABLE (Amount VARCHAR(15))

INSERT INTO @DemoTable (Amount)

SELECT '$102.50' UNION ALL

SELECT '-$57.75'

SELECT REPLACE(STR(ABS(CAST(Amount AS MONEY)*100.0),8),' ','0')

...

You want projects to practice on? Why go anywhere else... stay on this forum and start answering questions. You won't find a better or more diverse set of...

So, turn it on... end of proc trace takes no overhead and beats the heck out of modifying 300+ procs 🙂

Matt Miller (5/2/2008)

---

Grant Fritchey (5/2/2008)

---

How did you know what I had planned for the week-end... 😀

I have to ask though, what's drowning breath exercise? While we do incorporate a lot...

DFalso, if you get hit by a bus tomorrow and your boss can't figure out your code, then you're proving exactly what I said... your code is not production quality...

Thank you for the feed back, Poornima... are you all set now?

Funny, they work fine for me... they take me right to the post I wanted.

ebarsamian (5/2/2008)

---

Thanks for the help. This is the sql that puts the stored procedure into a temp table with a unique ID:

CREATE TABLE #trustgoals

(ID int IDENTITY,

Trust varchar(100),

InitialReview varchar(100),

ReReview varchar(100),

TotalReview...