Cool. Thanks, Grant. I'll get my thoughts together. 😉

so, if anyone else runs into this situation, i wrote a function to do this. it converts the db2 date, time, and datetimes into a sql server datetime. ...

hey, okay. thanks sqlbuddy. i'll set that up and see how it goes tonight.

my apologies, guys. i was pulled into an urgent issue. that is not going well. i think in trying to simplify my problem to present here, i've...

thanks for the reply. let me see if i can clarify:

Why would the sum of four values (all 1) be 1?

- for 'Email1' the quantity = 1 in the...

gotcha. so indexes and general performance tuning is an issue. I have done a good amount of performance tuning in my day. When tables grow over a...

right. unfortunately i don't have the error logs right now, but the log from our application, which contains some error messages returned from sql. When i get them...

Thanks guys. I am not sure of the exact build number right now. The issue and troubleshooting process is greatly complicated by the fact that i do not...

for help with the table thing, you'll need to include the code that creates the table. you say it is created in a proc. when is the proc...

first thing i would try is a 'GO' statement after your 'use' statement.

correct sytax would be

use [dbname]

GO

exec [procname]

but i also think lowell's syntax works.

let use know when and how...

do you currently have indexes on this table? could you include them?

this works nicely. i am still trying to figure out just how that final part works:

pivot

(MAX(ItemID) for RN in ([1],[2],[3],[4])) pivot_table

as it seems the row...

Thanks for all the replies so far, things are looking up!

coldcoffee: ideally i the query would have a variable number of items, but i'll take a fixed in...

oh, i forgot to mention: for you convenience, the whole original post is written so that you can cut and paste the whole thing into your query analyzer window...

btw - it seem that when i make a change to a proc, then his 'Reinitialize all Subscriptions' (and tell it to use a new snapshot) to sync up all...