DECLARE @sid varbinary(39)

SET @sid = 0x0105000000000005150000008BB113BE47890628D2E79F97E8030000

SELECT 'S-1-5-21-'

+CAST(CAST(CAST(REVERSE(CONVERT(binary(4),'0x'+sys.fn_varbintohexsubstring(0,@SID,13,4),1)) as varbinary(4)) as bigint) as varchar(10))

+'-'+CAST(CAST(CAST(REVERSE(CONVERT(binary(4),'0x'+sys.fn_varbintohexsubstring(0,@SID,17,4),1)) as varbinary(4)) as bigint) as varchar(10))...

If @P2 is IP Adress then you need to make it varchar(15) for IPv4 and upto varchar(39) for IPv6.

I'm a developer and an

- accidental

- pretend

- you are aren't you?

- you have to be there is no one else!

DBA

so I am always arguing with...

DECLARE @test varchar(max)

SET @test = CHAR(1)+CHAR(87)+CHAR(179)

SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)

COALESCE(STUFF(SampleString,CHARINDEX(',',SampleString),1,';'),SampleString)

SELECT COALESCE(GroupName,'Total') AS [GroupName],SUM(NumberOfCases) AS [NumberOfCases]

FROM #TempTable

GROUP BY GroupName WITH ROLLUP

ORDER BY GROUPING(GroupName) ASC

Cursing twice in the same post, shame on you Jeff :w00t:

Now wash your mouth out with soap and say 3 Hail Mary's 😛

No problem 😀

Just a thought I had,...

If this data is for SSRS then you do not have to pivot in T-SQL as you can use a matrix to do the pivoting and simplify the query.

SELECT CONVERT(char(2),Times,108)+':00' AS [Times],SUM(ACD) AS [ACD],SUM(Other) AS [Other]

FROM SampleData

GROUP BY CONVERT(char(2),Times,108)

ORDER BY CONVERT(char(2),Times,108) ASC

To see checkboxes in a parameter you have to set 'Allow multiple values'.

This will show a drop down list with checkboxes.

You cannot prevent the user selecting multiple values or the...

Richard Cranston (12/12/2013)

---

So I was able to split column based on specific substring length and export the data to my target source; at which point I noticed data contained Line...

Why?

Because you are using a matrix when you apply fill to...

The value should not matter as you are testing the date for the column.

Please post the expression you are using.

An example would be

=Choose(Weekday(Fields!Date.Value),"Red","Blue","Blue","Blue","Blue","Blue","Red")

Lowell (12/12/2013)

---

there is some support for patterns/regular expressions in SQL

this does what you are asking, i think. one expression tests exactly ten characters, the other test the first ten characters

WITH...