Be sure to point to the correct filelocations !

(and they must be reachable for the sqlserver service account !!)

IMHO your clientidS column is a prove of bad design ! (one column containing a bunch of seperate dataitems)

Check out "normalization" at SSC.

You cannot execute a sproc in a...

just to add to Gails reply..

be sure to provide indexes that match your FK-declaration !

(because otherwise you 'll end up with dependant table scans !!)

It's been a while, but I've seen a solution for mainframe db2 where you could prepare a full set of (related) data to be loaded into an environment.

I cannot...

just a little remark:

avoid using left and right outer joins together.

Choose one and go with that. (I prefer left join because then you're result is formed from top to...

many thanks for this usefull proc.

All I needed to add is a @Versions2Keep parameter.

Regarding the first insert:

INSERT INTO #temp2

...

It seems is going to be a cosy SSC-evening at SQLPass this year,

and by now Steve will have gotten the picture for the SSC-T 208:

front: upper left: SQLServercentral.com and the...

Congratulations Jeff and Michael.

A virtual pint to your honor ! (maybe we'll materialize that at SQLPass 😀 )

Check RETURN in bol !

Return is not used to fillup output variables, but it gives an integer value to the calling object. (mostly used to indicate OK or not OK)

To...

Steve Jones - Editor (6/30/2008)

---

I'd question all third party apps on this.

We implemented Dynamics about 8 years ago and they said they required SA to run the application. I dug...

And keep in mind that sql2005 may work better if the dblevel is put to 90. (=sql2005) Afterward you can put it back to 80 if needed !

The upgrade path...

install SP2 + at least Cumulative update 2 (CU)

We install up to CU5.

(CU8 is current, but you'll need to test if that one works for you !)

Aha, the wood and the trees .... :w00t:

Been there, done that 😉

Every once in a while, a good dba needs to proove (s)he's human after all 😛

so just use a single select and modify your where clause

...[Entry Type] in (0,1)...