oh and here is the code

DECLARE @sql VARCHAR(8000),

@ThreeMonthsAgo VARCHAR(10),

@FourMonthsAgo VARCHAR(10),

@FiveMonthsAgo VARCHAR(10),

@FirstDay_FiveMonthsAgo DATETIME,

...

Hi

You need to cast/convert your getdate values to VARCHAR's before trying to concatenate them to your main sql string.

Thats why you get the error.

Take note the you will need to...

Ok I got a solution for you!

Please not the proc requires a Tally table if you don't have one the code for it is commented out in the beginning of...

Ok I got a solution for you!

Please not the proc requires a Tally table if you don't have one the code for it is commented out in the beginning of...

What is the max number of search criteria?

In your above example, is description a word to be searched or does it mean search for anudeep in the description column?

THanks

IS this the same question as this:

http://www.sqlservercentral.com/Forums/Topic546066-338-1.aspx?Update=1

here is an example of how it will work.

DECLARE @vcSearch1 VARCHAR(100)

DECLARE @vcSearch2 VARCHAR(100)

DECLARE @vcSearch3 VARCHAR(100)

DECLARE @tbl TABLE

([Name] VARCHAR(1000))

INSERT INTO @tbl

SELECT 'Christopher Stobbs' UNION ALL

SELECT 'pkuchaliya' UNION ALL

SELECT 'Jack Smith'

--GET ALL...

SELECT *

FROM Employee

WHERE [Name] LIKE '%' + @vcSearch1 + '%'

OR [Name] LIKE '%' + @vcSearch2 + '%'

OR [Name] LIKE '%' + @vcSearch3 + '%'

etc

Hi all,

The one I have come across before, is for a candidate to explain how they would design a system or what they would look out for when designing a...

Ok Got it 🙂

I'll drop you an email now

Are you sure you can only weigh them once?

I can do it with two weigh in's but not 1 🙁

Jeff,

How would you best two queries to see which is performing better?

thanks

Chris

I agree, I can't get any errors ,so I'm curious about the data more than anything else

LeeLuv

Please could you let me know the error you get with the Case statement solution above????

AS mentioned by the other helpers the subquery will prob not give you the...