Same principle. Check for [font="Courier New"]LIKE '000IDP______2%'[/font] or [font="Courier New"]'00SAQD______1%'[/font].

John

You won't get any SQL injection with that. In fact, you won't get anything, because it fails with a conversion error.

Please will you post your whole trigger definition? ...

So you always want to return the last seven day period in the month, regardless of what day of the week it starts on?DECLARE @Date datetime;

DECLARE @StartofNextMonth datetime;

SET @Date =...

You can parameterise @Text to stop this happening. The syntax below is from my memory, so please check it's correct before using.SET @Inserttbl = N'INSERT INTO Test.dbo.' + @TableName...

Yes, but you may not be...

If you don't have a trust relationship between the domains, then you'll need to somehow embed a password for the non prod domain into whatever process does the work. ...

I would do both, in that case. Take a backup, take a snapshot. Start testing. Revert to snapshot when finished. If anything goes wrong, you still...

WHERE LEN(MyCol) > 10

AND (MyCol LIKE '_____[1-6]1%'

OR MyCol LIKE '_____[7-9]2%'

OR MyCol LIKE '_____[0]2%')

The digit 6 appears in both your "1" and "2" requirements, so I guessed where to put it.

John

Have you tried the DATENAME function? You can choose week or iso_week as the datepart.

John

If you're not the DBA then you shouldn't even have access to create snapshots and backups. Is this a test server? It can't hurt to take a backup...

I think you might need to get someone in to help you with this. Your requirement is changing with every new post, and you're making up syntax and hoping...

Please will you share what you did? It will help anyone who's having a similar problem to yours.

On page 99 (https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ)...

Your screenshot doesn't show the whole value of the variable. Does it include the name of the csv file? Have you tried it with and without? Please...

Run the job every five minutes, say, and have it check whether the file exists. If it does, proceed to the part of the job that does the processing.

John

Sanjay

So you did. Please scrub "log files" from my response.

Can you please...