First, I tried just looking at the execution plan, which I had never seen before because I so rarely encounter a query that runs for any significant amount of time,...

First, I suspect the following code will run VERY POORLY, but here goes anyway, and if EmployeeId is not the Primary Key field in the Employee table, replace that in...

You'll have to look at the Orders table to ensure that Title is a field within it. If it's supposed to come from Employees instead, then I'll have to...

Matt,

I by no means advocate a loop solution, but was just trying to get the OP to come clean on the whole deal instead of feeding it in piecemeal. ...

Really? Perhaps you need to restate the problem. What it appears you are asking for is a solution to a general class of problem: Using...

Come to think of it, I realized this wasn't all that hard if a table variable is ok...

Try this on for size - I have no NORTHWIND available, so I...

I'm of the opinion that this is the old "TRICK QUESTION". I don't happen to have NORTHWIND available to me, nor have I ever done anything with it,...

Try looking up CONTAINS in BOL. FREETEXT may not always recognize a shorter version of a name, and I don't think it works with wildcards.

Steve

(aka smunson)

:):):)

Unless there's some reason to avoid using the LIKE operator, I think a rather minor recoding of the original will work just fine:

Declare @Ccode varchar(20)

set @Ccode='C022,C007,C044,C050,C020'

print @Ccode

select * from ReconciledSites...

Try this:

DECLARE @OLD_TABLE TABLE (CLNT_ACCESS varchar(3))

INSERT INTO @OLD_TABLE

SELECT 'Yes' UNION ALL

SELECT 'No' UNION ALL

SELECT 'Yes' UNION ALL

SELECT 'Yes' UNION ALL

SELECT 'No' UNION ALL

SELECT 'Yes' UNION ALL

SELECT 'Yes' UNION ALL

SELECT 'No'...

This solution is imperfect in that it doesn't identify a zero allocation, but it was fairly quickly developed, and perhaps someone with more skills can make it better:

DECLARE @RECEIPTSTABLE TABLE...

While openrowset may give you some data access, there may be other limitations that will cause problems. Most ODBC drivers for older database formats such as dBase or...

Well, Ivanna, that makes a total of three RELATIONAL verses in T-SQL Haiku... How database is that ???? :D:D:D

And as long as we're using a RELATIONAL language,...

OOPS !!! Wasn't familiar with the specifics on that... here's a fix:

BEGIN TO COMMIT

WHEN RECEIVE CONTAINS DUMP THEN

END CONVERSATION

Turns out I did have 5 on line 1,...

I think what's desired just needs a slightly different way to go about it. Start by having 4 parameters. One for the year, one for the...