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

How about the following?

BEGIN TO COMMIT

WHEN RECEIVE DUMP

THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...

especially when I considered how RELATIONAL it is :w00t::D:P:hehe:

Steve

(aka smunson)

:D:D:D

I hear you Lynn... I just think we're clashing on a difference of either specific values or perspective. My values say that if I were going to...

While I understand your point, why diminish the value of SSC by allowing something like QOTD to go so far off kilter? Perhaps it's time to consider making...

majorbloodnock (6/25/2008)

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've...

A.) No judgement was made, was just posing a question.

B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why...