No need for a loop in your function. This will work for any number of weeks up to 10.DECLARE @weeks tinyint;

DECLARE @no int;

SET @no = 16;

SET @weeks = 3;

WITH...

Please will you provide table DDL in the form of a CREATE TABLE statement, sample data in the form...

Celine

I'm sorry, you've lost me. Please will you provide table DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT statements, expected results,...

CASE

WHEN SUM([Contribution Amount]) <= 7500 THEN ''

ELSE 'Total over £7,500'

END

John

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