In splitting string using number table is not this approch simpler?

DECLARE @S VARCHAR(80)='Army,Navy,Air Force,Marines'

;WITH c AS

(SELECT 1 AS n

UNION ALL

SELECT n+1 FROM c WHERE n...

Thank you,

I use ABS() function for solving the problem.

And put here some solution for splitting string, see:

SET NOCOUNT ON

DECLARE @S VARCHAR(8)='kill,ill'

;WITH c AS

(SELECT 1 AS n

UNION...

Try this:

INSERT INTO TABLERESULT

SELECT SECTION,

COURSECODE,

MAX(CASE WHEN rec_id = 1 THEN ParameterVALUES END) AS P1,

COALESCE(MAX(CASE WHEN rec_id = 2 THEN ParameterVALUES END), '') AS P2,

COALESCE(MAX(CASE WHEN rec_id = 3 THEN ParameterVALUES...

Steve Cullen (5/19/2010)

---

From OBJECTPROPERTY BOL:

The Database Engine assumes that object_id is in the current database context. A query that references an object_id in another database will return NULL or incorrect...

I use database name before the INFORMATION_SCHEM view but when I use the USE statement with another database name my result is incorrect.

I have two database with names "concat" and...

Thank you very much!

Thanks a lot ColdCoffee! 🙂

I have not used this function yet.

I fine the mistake!

Assume my string is: DECLARE @S VARCHAR(500) = 'abc 'SELECT LEN(@s) --The result will be 3! not 5! This was my problem

Why SQL Server...

Thanks. It is exactly what I was looking for!

ColdCoffee (5/19/2010)

---

You may probably wnat to read thro one excellent article from Jeff Moden on how to "REPLACE Multiple Spaces with One"

LINK : REPLACE Multiple Spaces with One[/url]

Hope this helps...

But how about this?

SELECT CHARINDEX('X', 'abcdx')

If we want compare just two characters your way is correct. But at this case we cannot do this.

Can I use something like COLATE in...

I got it! 🙂

select convert(varchar(150),0x202020202020202020202020202020202020202020202020202020202020292020202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202020202020202020202020202020202820202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202028202020202020202020202020282029202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202029202020202020202020202020202220202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202820292020202020202020202020202020202020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020202020202022202020207C202020202020202020207C2020202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020202020202020207C20202020202020282820202020202020202020292920202020202020202020202020202020) union all

select convert(varchar(150),0x202020202020207C2020202020292920202020202029292020202920202020202F2F2020202020202020202020202020202020) union all

select convert(varchar(150),0x20202020202020292920202028202920202020202F202F202020282020202028202820202020207C2020202020202020202020) union...

Yes.

Thanks, but I am looking for a query that generates the result and we cannot to see the result before running it.

Thanks. It seems...