A little off-the-wall but I've run into similar problems with other things... the way I got around it was to run this type of thing on each server with an...

Actually, if your users are experienced in MS-Access, what's wrong with them using it?  The only other thing you could do is either write you own Web app to do...

Thank you for the feedback.  If you add tabs instead of commas, it'll open up in Excel without much of a conversion at all.  Didn't realize that the target of...

So, what your telling me is that @facturas_id2 is a VARCHAR like it needs to be?  Make sure because I didn't see it defined in any of the code you...

You'll take one look at this and think I'm as crazy as a cyclist on steroids... but try it... no real loop, nasty fast, and does not require a function...

My 2 cents...

 SELECT DATEADD(mi,30*Number,0) AS BW1

   INTO #v_hcdata_Total

   FROM MASTER.dbo.spt_Values

  WHERE NAME IS NULL

    AND Number < 48

Certification will require some tenacity on your part...

Anyway, take a look at this url...

http://www.microsoft.com/learning/mcp/sixsteps.asp

How true, how true... I'm still waiting for Ravi to post some code and maybe give us a hint as to the rowcounts in the tables. 

Ravi, while were waiting,...

Warning... most of those sub-queries contain inequality comparsisons that form triangular joins... I haven't looked super close at them but triangular joins normally mean "Death By SQL" on larger record...

If it were me, I'd search the Microsoft website for "certification" to get the info straight from the horse's mouth.

It may also be that the Customer table is actually some (synonym) view that someone changed or changed the underlying table on.  My recommendation is to do an execution plan...

The query does not make it's own deadlocks... the query is not wrong.  Take a look at Books Online... something else is wrong... it may be that someone added a...

Did you do a "search" in the "Search" box on this forum?  Look for "hierarchy" and "tree"... lot's of good posts on the subject...

Outstanding... you were correct from your other post in that...

1.  You would help others

2.  You could find it again.

I remember...

It's almost the same problem as this...

SELECT 'A'+1

You must convert the numeric variables to strings in order to concatenate them with other strings.