Hi Chris,

I decided to use table variables instead of temp tables, and that gave me a small performance increase, but the whole thing is still pretty slow. It's not...

I got it to work by breaking all of the conditions down into individual statements, as follows:

CASE WHEN @SortBy = 'S' THEN column1 END

CASE WHEN @SortBy = 'L' THEN column3...

John, CONCAT_NULL_YIELDS_NULL is set to false (according to the Properties window for the database).

Ken, I'm getting some wierd results with your solution. When sorting by column1 and column2, the...

I fixed the problem. I had forgotten to surround a group of OR-qualified statements in parenthesis, which had an odd effect on the rest of the query. Thanks...

I can't really post that much information (it's not mine to post). The query involves inner joins on seven very large tables, and the query is very much as...

The problem must lie with another part of the query because when I isolate the date comparisons they appear to work correctly, but when run with the other criteria the...

Can you please give me an example involving temp tables?

I think so. So how are you supposed to manage the group by clause when you have to return so many rows? Is there another way to do...

The problem is with the result set (assuming that my group by clause exactly mirrors my select clause). When the group by is so large, it seems like it...

Hi Chris,

This is essentially what I am attempting:

SELECTs.PartNumber, s.PartName, s.Date, s.Qty, s.Price, sr.Reason, pc.Description, psc.Description, s.SID, p.NonInventory, p.Return, p.Stock

FROMSales AS s, SaleReasons AS sr, PartClasses AS pc, PartSubClasses AS psc,...

@var2 is a cell in table A, but there could be several rows returned.  I think I got this working by nesting my selects and using IN as opposed to...

Hi Shaun,

I'm using Sql Server Express, but I am using it to make a Sql Server 2000 compatible db.  I am also using VS 2005 to make the web app. ...

I've got it working.  Thanks for all the help.  It's appreciated.

I am pulling data from nine different tables.  It makes the select statement very cumbersome.  If I want to use a field in the WHERE clause, it must be included...

Adding the length of the field did the trick.  I don't understand why that makes a difference, tho.  Can it only compare fields that defined as being the same size?