SQL Kiwi (8/2/2012)

---

True; see the picture below of two hobbits winning our first gold medal in...

Hi Jay

We use VS2010Ultimate/AnkhSVN/SSDT for development here so I'm reasonably familiar with it - yet I'm not sure what you are trying to do or why. If you want to...

CREATE TABLE MyTable (

MyTableID INT IDENTITY(1,1) PRIMARY KEY,

.

.

.

Sometimes, just occasionally, when the target table isn't the first table listed in the FROM list, SQL Server gets its knickers in a twist. Try this:

UPDATE ceh

Set AEarned 1 =...

Anthony - "Chris's modified function"...

XMLSQLNinja (8/1/2012)<<snip>>

Each of these guys will blast through several hundred thousand rows in seconds. QU is still new to me and I'm playing around with it - it is usually...

Lynn Pettis (8/1/2012)

---

Take this as a "seal" (imagine a picture of a seal here) of approval? ...

😀 😀

I get around 15-60ms for either using the backup...

How did you time the runs, Anthony?

This function runs about 25% faster:

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,,>

-- =============================================

ALTER FUNCTION [dbo].[GetCIDs]

(@SID INT)

RETURNS @Result TABLE (LongCID VARCHAR(8000))

AS

BEGIN

DECLARE @Accumulator TABLE (seq INT, CID INT);

INSERT INTO...

I'm sorry Jerome, looks like you need a c# developer to help with...

texpic (8/1/2012)

---

That gets me the first report. Is there a way to dynamically create this report from those results? There would be more time periods and more users.

date...

SELECT Dept, UserId, x.[date], x.[Hour], COUNT(*)

FROM #CountsPerHour

CROSS APPLY (

SELECT

[date] = DATEADD(dd,0,DATEDIFF(dd,0,StartTime)),

[Hour] = DATEPART(hh,StartTime)

) x

WHERE Dept <> 2

AND StartTime >= @DateStart -- NOTE >=

AND...

Koen Verbeeck (8/1/2012)

---

ChrisM@Work (8/1/2012)

---

The WHERE clause doesn't generate an output column. Ever.

There are four well-known ways to...