Found this, which might be useful to you:

Pattern matchingMatches patterns of characters

-- Author Gianluca Sartori

--http://www.sqlservercentral.com/Forums/Topic1008514-391-1.aspx

-- Table to hold the words to search for

DECLARE @Patterns TABLE (

...

subhankar02dey

First I altered your T-SQL code:

set @d='select * from employees where'+@a+@b+@c;

PRINT @d -- added

---???????????????????????????WHAT TO DO TO EXECUTE @d?

return

Then executed the resulting SP as procedure1 'NY','ABC','SAM'...

Thanks for considering it (us) ....

Steve, nice info for a beginners tract on a SQL Saturday. Now how to lure you to SQL SAT #60 (Cleveland)...

Blake

You will want to create a parameterized stored procedure along the lines of:

CREATE PROC [dbo].[Blake]

@Start DATETIME

AS

DECLARE @Syr VARCHAR(4)

DECLARE @Smon VARCHAR(2)

SET @Syr = DATEPART(yyyy,@Start)

SET @Smon = DATEPART(mm,@Start)

SET @Smon...

Let's hope what happens in Vegas stays in Vegas

robert693

Thanks for your reply, and I like you did not spot it first off, now let me ask did you use a blank character or stick with those NULLs?

Now this could be a result of your typing in the BCP command, and NOT an error in the actual BCP command you are using, however in looking at what...

Where you have NULL as [End Date], can you substitute a blank character as:

'' ' AS [End Date]

For example

SELECT Subject, ' ' AS [End Date], ' ' As [End...

Can anyone help this OP?

http://www.sqlservercentral.com/Forums/Topic1004378-149-1.aspx#bm1004658

Thaks

You might want to run this select statement and either output to text or to a file. Set SSMS to output text to a new window, you can cut...

Are you familiar with the TRY - CATCH construction? If not the following link will be most helpful.

http://technet.microsoft.com/en-us/library/ms179296.aspx

natalie_orlovsky

In order to receive a tested reply please post table(s) definitions, some sample data, and any T-SQL statements that you may have attempted to use to solve your problem.

Please click...

Is Mr Celko mellowing? Admitting there is something he does NOT know, or has his character drastically changed?

http://www.sqlservercentral.com/Forums/Topic1002440-1292-2.aspx

This code takes the data you wish to manipulate and places it into a temporary table

SELECT c.FirstName, c.LastName, e.Title, a.AddressLine1, a.City, sp.Name AS [State/Province], a.PostalCode

INTO #EmployeeAddresses

The results of the first...