OK, I see that it works better now but there still seem to be some inconsistencies. You say that you do the matching from the side of TBLforMatching based on...

Huh... did you edit the post? I started working on it, and now I see there are 9 rows in table Matching, while there were only 8 when I copied...

Table variable is just a variable - not a table. You can't use DBCC , you can't use TRUNCATE TABLE... just SELECT, INSERT, UPDATE, DELETE. I know of no way...

Try to do what the error message suggests - add FROM clause:

update FSA_EXPORT_TEMP

set trading_partner = 'XXX'

FROM FSA_EXPORT_TEMP WITH (INDEX(index_name))

where reporting_date = @reporting_date

and fsa_le = @fsa_le

and transfer_le like '%%X'

and sp_id =@sp_id

I'm...

Thanks Remi... I wasn't really happy with the idea of multiple UNION, but didn't think of anything better at the moment. CASE was my second idea, but it just passed...

I suppose you have more than one row in the table... so you should have some key to know which row is which. If there isn't a natural primary key,...

Yes, this will work. However, you can't use it anywhere where a simple user (not admin) should start it manually - sp_makewebtask requires sysadmin role. That's also the only situation...

There is no danger of data loss from TEMPDB if you just regular way stop and start SQL Server. Tempdb contains only temporary objects, so if all processes stop, there...

It was fast because I'm using similar queries pretty often at work, to find out how many customers had "active" status during certain period.

You might need to change < to...

Try this... it might need some tweaking, I'm not 100% sure about your data structure - but the idea should be clear. We want all players that ENTERED the team...

alvaro,

you can use query in place of a table in another query. I like to do it in similar cases, because it seems to me more understandable and easier to...

I'm not sure I understand the requirement fully... so I'll try to describe it and you tell me where I'm wrong.

You have a table of persons, and a table which...

Just one idea right now... Was the web task created with sp_makewebtask using parameter @whentype=5?

I agree that test is the best way to find out.

I will not quote any authorities (true or would-be), but based on my experience, if the table is large...

Did you check there really is double CR? Maybe the rows are just too long to fit on one line of text, but the part that is wrapped to another...