Jeff Moden (5/30/2014)

---

Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at it and...

wolfkillj (5/30/2014)

---

SQLRNNR (5/30/2014)

---

wolfkillj (5/30/2014)

---

jcrawf02 (5/30/2014)

---

jasona.work (5/30/2014)

---

The impression I've gotten is that they already have a contract with NASA to ferry crew, it's just been waiting for the man-rated capsule to...

Do they really need to understand how it works in order to use it? I think it’s sufficient to know what it’s used for – “Pivot one or more columns...

sgmunson (5/30/2014)

---

ChrisM,

If the original poster needed an explanation of a fairly simple query, somehow, it just doesn't seem likely that they're going to consider FOR XML PATH as something easier...

If you want to make your code significantly faster, more compact, and more readable, try this:

SELECT

t.*,

x.[tMask_out]

FROM [test].[dbo].[test1] t

CROSS APPLY...

A different coding method may help Steve's description:

SELECT tmask,

b1 = CASE WHEN rem2 >= 1 THEN 1 ELSE 0...

eyric101 (5/29/2014)

---

It takes more then 30 seconds to run

DECLARE @intTmpTblCnt INT,

@strTmpSql VARCHAR(max),

...

How about a little bargaining here - you spend a little time and effort describing your...

GBeezy (5/29/2014)

---

I am not getting an error...

Before the function call I using the ASCII(RIGHT(t.OffensiveColumn,1)) to see what the ASCII character is, then calling the function, and returning the results to...

Do you get an error or...

ronan.healy (5/29/2014)

---

ya well once the new number is created its then stored in a file and re read into table so its always there.

it works well for the one account...

SQL Server has no explicit conversion from VARBINARY to FLOAT, but you can roll your own. Refer to this thread.

This inline table-valued function is based on the UDF described in...

Alvin Ramard (5/28/2014)

---

Luis Cazares (5/27/2014)

---

Alvin,

The code makes clear that there's a concatenation based on multiple values on a single column.

CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ',' ELSE...

Check BOL (the SQL Server help system) for the ISNULL() function, and have a look at the related functions COALESCE() and NULLIF() too.

Note that your output columns can only be...

Can you...