Juan,

I'm a bit confused.... you say the users are going to do deletes, sorts, filters, and analysis but you have concerns about their capabilities with the software (Access)?  I'm thinking...

Thanks David... and I agree, but it's nothing quite so serious... our standards currently have some fairly strict naming conventions that do not include Hungarian Notation (except for the letter "p"...

If you need a text column for Results, tell me why this won't work...

select RGnameLast+', '+RGnameFirst AS Adjuster, RGnameLast, COcity AS ClientOffice, IOofficeName, WRworkOfficeId,

WRid, SRnameLast+', '+SRnameFirst AS Subject,

CONVERT(CHAR(8),...

Seqiy,

Do you have a Microsoft URL for "And prefixing tables with "tbl" as well as all other objects in SQL decreases database performance. Just in case you did not hear...

Shyam,

Although Serqiy has gotten blunt as all get-out, he's absolutely correct.  Why on earth would you want to modify the content of the IDENTITY column?  If you run out of...

Unless you haven't posted all of the code, you, in fact, as the SQL Junkie suggested, do not need a cursor for this.  Did you try the SQL Junkie's code? ...

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...