Thanks Paul, much appreciated. Putting my learning head on now 🙂

Paul White (2/13/2013)

---

Debug version SQLCLR procedure (without bulk copy) loading the destination table: 1.4s on the same data...

anthony.green (2/13/2013)

---

I belive it is the custom one he is writing...

I knew I had rushed it earlier 😉 - this version packs 70,000 requests in about 13 seconds on my desktop.

Thanks for the test harness Dwain, I have borrowed and...

Good to just know you are aware 😀

Thanks for the feedback, glad to help.

:w00t: You're welcome, but really don't use that for anything important..you will get bitten eventually 😎

dubem1-878067 (2/12/2013)

---

I have a varchar column containing dates (not my design) with this format 2013-02-12

I need to extract records between two dates

this code will do the job

where convert(datetime,...

Sean is right, however in this one case you can make it seem like it works....

SELECT *

FROM (

SELECT*,row_number() OVER(PARTITION by TType ORDER BY TTime,TFunction,TStatus) AS rn

FROMMyTransactions

) a

ORDER BY rn,TTime, TType,...

Good job on the test data and description...:-D

SELECT

[Employee Number],

X.[Dated],

MIN(CASE [Clock In or Out] WHEN 'Clock In' THEN CONVERT(DATETIME,[Date]) ELSE CONVERT(DATETIME,'31 dec 2199') END) AS [Clock In],

MAX(CASE [Clock In or...

No cursors...but a WHILE LOOP...so :hehe:

SELECT

'Starting' -- just to get my first rowcount of 1 🙂

WHILE @@ROWCOUNT=1

INSERT tblScheduledRequests(RequestID,ScheduleID,RequestChunkStartTime)

SELECT TOP 1...

sku370870 (2/10/2013)

---

DECLARE @LastOne bit = 0

CREATE TABLE #tblTasks

(

TaskID int,

...

Is this a matrix report? what groups do you have for rows and columns?

skgudi2009 (2/10/2013)

---

I want to add this expression in SSRS 2008R2 For Column Heading

If {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then

'Amount1'

Else If {Reportname.value} = 'BAC'...

SELECT

DayNumber = nd.value('(Day/text())[1]','smallint')

, IsHoliday = nd.value('(Day/@IsHoliday)[1]','varchar(5)')

, Reason = nd.value('(Day/@Reason)[1]','varchar(50)')

, ActivityID = nd.value('(ActivityID/text())[1]','int')

, ActivityDescription = nd.value('(ActivityDescription/text())[1]','varchar(512)')

, StartDate = nd.value('(StartDate/text())[1]','date')

, StartTime = nd.value('(StartTime/text())[1]','char(9)')

, EndDate = nd.value('(EndDate/text())[1]','date')

, EndTime = nd.value('(EndTime/text())[1]','char(9)')

,...