Glad you solved it

..next step is to figure out how to get rid of the temptable, huh?

I'm guessing it's 'temporary' in a global...

Heh, thought it would be a catch somewhere with all the different lenghts and such

Allen got it right on, substringing and concatenating the...

The COMPUTE clause is retuned as it's own separate resultset.

In you receiving end, it's the 2nd result returned, the first being the SELECT list.

You could look at ROLLUP, which can...

Though then the whole transaction thing would be for nothing if split up..

The same net effect would be to just omit the explicit...

Can you provide some code examples of the different variants, and an explanation on how each should be treated?

/Kenneth

Still, imo the design of things are still flawed, albeit there's perhaps not much you can do about it.

So, what does these two...

FWIW, when in doubt of what you see is what you really get, you could also do some 'sanity checks' on the material..

select len(@out) or select datalength(@out)

...would probably have indicated...

The way around a deadlock lies in the design of flow. Deadlocks happens as a result of a conflicting design (ie events does not occur in a consistent pattern or direction).

The...

Well, it does return a result, but are the numbers the ones you expect?

I can't tell unless you explain more about how the DPHEADER and F5574A tables are related...

As far as I've been able to find out, when changing an existing column - No. When adding a new column - Yes.

Though, what difference does it make anyway?

Whenever we...

You can find a way to handle the same kind of problem in this thread here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=253037#bm253123

(how to return only those who have all items in an IN list qualified)

/Kenneth

Though undocumented, here's another way which avoids dynamic SQL.

-- list name and filenames for all db's on the server

exec sp_msForEachDB 'SELECT...

Just a final note on dates...

If your date_of_transaction column also holds time that is different from all zeroes, you need to think about how to phrase the qualification.

The above works...

To create a new default and also seed with the WITH VALUES clause only works when adding a new column, not when changing an existing column.

What you need to do...

The Style doesn't work at all when converting from string to datetime, it's used only when converting from datetime to string.

Also, be aware of the language when dates are in such...