Alexander-449406 (10/3/2012)

---

I understand this is a horrible design to expect an ordering without specifying it (this has been already fixed as you suggest). But I'm still trying to find out...

dwain.c (10/3/2012)

---

Jason-299789 (10/3/2012)

---

I think its the fact that the Row_number() requires an order by statement thus a sort, rather than an Identity which assigns the number as the data is...

I've answered the counting question before. I didn't get the job in the end, but I suspect it was due to experience rather than interview technique (when I asked them...

Mac1986 (10/1/2012)

---

from the below Query, I need a 3rd column which would calculate Runtime(Hours) from 12:00 AM to WorkQueueEndWorkDate.

DECLARE @XHours INT = 2160

SELECT StartDateTime=DATEADD(day, DATEDIFF(day, 0, WQ.WorkQueueEndWorkDate), 0),WQ.WorkQueueEndWorkDate as 'EndDateTime'

FROM...

I've had a backup of a DB linked to me in a PM once or twice.

Same as Gail, I'll generally just tell them that questions should be posted in the...

t.brown 89142 (10/1/2012)

---

The standard way of doing these casts is to go via varchar and back to datetime, truncating any data not required

e.g.

SELECT CONVERT(VARCHAR(10), GETDATE(), 120) -- get...

Glad it worked. Check this link for other formatting options for datetimes. Bear in mind that this is generally slower than a...

I guess the easiest thing to do would be to change your query to this: -

SELECT *

FROM [dbo].[DATAFLOW_CLOB]

WHERE RAW_CLOB LIKE 'AAA|E0221002|_|'+CONVERT(VARCHAR(8),GETDATE(),112)+'%ecp%';

You should look into string splitting, as well.

Sample data used: -

SELECT EID,AbsenceType,AbsenceStartDate,AbsenceEndDate

INTO #yourSampleData

FROM (VALUES(769,'Holiday','2012-06-25 00:00:00.000','2012-06-25 23:59:59.000'),

(769,'Holiday','2012-06-26 00:00:00.000','2012-06-26 23:59:59.000'),

...

Ummm. . .

YEAR(GETDATE());

http://msdn.microsoft.com/en-us/library/ms186313.aspx

skizzly (9/18/2012)

---

thanks Cadavre,

note taken on guidelines for posting 🙂

Very new to SQL and never used the APPLY operator. So learning hard and fast, or least trying to. Only one...

skizzly (9/18/2012)

---

Hi All,

new here so be kind....:)

I have a task to identify all students in a dataset of 49K that have multiple open attendances at schools.

I can pull all students...

ben.brugman (9/17/2012)

---

Hello All,

Thanks for the script en the results from the script. I have added some results. (Using 2 distinct machines and using two runs on each).

Used the script of...

ben.brugman (9/15/2012)

---

Another solution, I think shorter and more efficient, this because only 865 rows need to be generated and inspected.

with a as ( select 123 as n union all...

ChrisM@Work (9/14/2012)

---

dwain.c (9/13/2012)

---

And here's one specially built for ChrisM@Work, who loves cascading CROSS APPLYs:

;WITH SourceNums AS (

SELECT num FROM (VALUES (1),(2),(5),(7),(8),(9)) a (num)

), MyNums AS (

SELECT num=a.num + 10*b.num +...