Well, sorry, can't really help you any more then. I tried reproducing the problem and couldn't get it to appear. I'm not seeing any trailing spaces in the result of...

I'm not sure what trailing spaces you're referring to. I don't get any.

Though you should realise that you probably need to change the ANSI_PADDING setting in the *database*, not in...

What's the problem? I tried running your query and got no errors.

The reason you're getting that problem is because, if you don't assign a value to a variable after declaring it, then it leaves the value of the variable as NULL....

This should work. Although it would be better if, instead, you just modified your original table to include that "TypeOrder" column, so you don't need to make two CTE statements.

create...

I'd agree with this suggestion.

Although you'll need to make one more change - You want only the first...

Yeah I know - I wouldn't recommend using xp_cmdshell, but if for whatever reason he doesn't have access to a visual studio environment to create a CLR with, then it...

Are you using the SQL Server backend to handle updating of the records, or is that being done through Access?

IE - are you running a stored procedure on SQL server...

I *think* that if you just schedule 13 jobs, and have them each start at the same time, it will execute all jobs simultaneously, and have them run in parallel....

GSquared (7/1/2011)

---

I don't think there's a way to do that in T-SQL. My solution on similar scripts has been to check for the existence of the folder, and have...

Hah wow. Yeah I was thinking about using that approach but for some reason decided it wouldn't work - of course it does. Thanks for correcting it 😛

Could try something like changing your CASE clause to:

DATEDIFF(dd, CAST(CAST(YEAR(PAIDDATE) AS VARCHAR(4)) + '/' + FYME AS SMALLDATETIME), PAIDDATE) > 0

But without much more info, can't really help you more...

Haha, wow, that is one cute solution. Faking the system into thinking the string is referencing a database table, and then using PARSENAME to display the name of the "table"....

In that case, this should do it:

DECLARE @String VARCHAR(MAX)

SET @String = 'RNL00:123456-3:123'

PRINT SUBSTRING(@String, LEN(@String) - CHARINDEX(':', REVERSE(@String)) + 2, LEN(@String))

Or, if there can be more than two ":" in string,

DECLARE...

Are there always going to be at most three values for each DOC? If so, you can do this:

CREATE TABLE #CLI_NU

(

DOC VARCHAR(8),

DDN VARCHAR(2),

TEL VARCHAR(9)

)

INSERT INTO #CLI_NU (DOC, DDN, TEL)

VALUES ('00065955',...