Well Steve - I'm going to beat the aussies and the kiwis (& my fellow-countrymen) on this one...I saw this on the news the other day and should've guessed it'd...

Did you try only the "select...." to see if it returns any rows ?!

You say that "other insert statements are successful"...could you post the code for both..one of the successful...

well - you talked about an inner join in your first post...what is the actual query that you run in QA ?! Also, could you post some sample data from...

Expand your database...right click on "views" and you'll see the design window...add the tables you want to query etc...it's a breeze splly. when you want a step-by-step visual - and...

noel - i like my suggestion better..

"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime."..

I haven't come across this myself but apparently a whole bunch of others have (google) - suggestions include increasing timeout to size of tempdb...read these 2 links to see if...

The fastest way for you to "debug" this yourself would be to use the view designer in Enterprise Manager...with each join/filter that you check against a column you would be...

Since you want to use this dynamically is it safe to assume that the table names will also be dynamic and that there is more than one table you'll...

Too quick indeed - I could swear that when I read it I didn't see any updates, and the set statement was assigning values to the variables...apologies Joe...

After getting over the intial shock of seeing Sergiy advising use of EM (until I read on and realized it was only to use it as an aid to create...

If I could count the # of ways EM becomes a "blasted thing" I'd soon run out of fingers and toes...

sorry don't have time to delve deeper but i would do something like this....

declare a dateColumn variable...

then "set" the name based on @ApplyDtRangeTo..

and then have 2 queries based on "@StartDt...

sorry...before grouping you should add a further filter of...

where product_status not like 'sold out'

untried & untested but should be something like this...

select a.company_no as company_name, (sum(a.no_of_item) - b.sold) as current_product from
myTable a join
(select company_no, no_of_item as sold from myTable
where product_status = 'sold...

If your POX_NAME is of varchar type and UNIT & QTY of int types then convert the 2 columns to varchar first....

SELECT POX_NAME + SPACE(1) + CAST(POX_UNIT AS VARCHAR)...