astrid 69000 (3/26/2013)

---

but if i create the date table dont i have to add the dates manually?

to calculate the first period i go

select sum(Count) from #table where recordday >= '2008-01-01'...

;WITH Employees AS (

SELECT TOP 1

employeeid,

FIRSTNAME,

LASTNAME,

EMAILADDRESS,

STARTDATE

FROM linkedServer.linkedDB.dbo.AUEMPLOYEE

WHERE employee.ENDDATE IS NULL -- still active

ORDER BY ACTIONDATE DESC -- most recent

)

SELECT

e.*,

org.ORGANIZATIONID,

job.JOBTITLEID

FROM Employees e

LEFT...

astrid 69000 (3/26/2013)

---

Chris that but I need to add each row manually which I didn’t want to do (this is the one thing I know how to do lol.

Jayanth, I...

3 rows affected

Two rows affected

Are these both correct? The second sample...

Does this help?

;WITH MyData ([day], [Count]) AS (

SELECT '2008-01-01 00:00:00.000', 3 UNION ALL

SELECT '2008-01-01 11:00:00.000', 9 UNION ALL

SELECT '2008-01-01 22:00:00.000', 3 UNION ALL

SELECT '2008-01-02 09:00:00.000',...

Chandan, you're very welcome, thank you for your generous feedback.

This exercise, resolving a simple query from a more complex query referencing many more objects, often isn't successful because of cardinality...

bugg (3/25/2013)

---

ChrisM@Work (3/25/2013)

---

This article linked in my sig explains in detail how to post execution plans. They're active - .png graphics are not.

Right-click on the execution plan tab, select...

OK got it. You need to change two indexes.

1. Include orderhash and status in index IX_SessionID, like this:

CREATE NONCLUSTERED INDEX [IX_sessionid] ON [dbo].[orderha]

([sessionid] ASC, OrderHash ASC) INCLUDE (Status)

2....

This article linked in my sig explains in detail how to post execution plans. They're active - .png graphics are not.

Right-click on the execution plan tab, select "Save Execution...

bugg (3/25/2013)

---

ChrisM@Work (3/25/2013)

---

bugg (3/25/2013)

---

After applying that index update. I am now receiving another deadlock on that same table:

Node:1

KEY: 9:72057602492792832 (860067b2b9d1) CleanCnt:2 Mode:X Flags: 0x1

Grant List 2:

Owner:0x0000000198215A40 Mode: X Flg:0x40...

bugg (3/25/2013)

---

After applying that index update. I am now receiving another deadlock on that same table:

Node:1

KEY: 9:72057602492792832 (860067b2b9d1) CleanCnt:2 Mode:X Flags: 0x1

Grant List 2:

Owner:0x0000000198215A40 Mode: X Flg:0x40 Ref:1 Life:02000000...

Si Thu (3/24/2013)

---

Hi,

I have one huge table which has 1Billion records. I tried to delete unnecessary records but it took a lot of time to delete and the delete was...

Lynn Pettis (3/22/2013)

---

Megha P (3/22/2013)

---

Hello ,

you can also try below

;WITH CTE AS

(

SELECT docid,pages FROM #x

UNION ALL

SELECT C.docid,C.pages-1

FROM #x X INNER JOIN CTE C

ON X.docid =...

It's difficult to tell with all of those funky joins and no sample data, but you might get a win with this too;

SELECT CAST(ID AS NUMERIC(9))

INTO #Accounts

FROM dbo.SplitIDs(@vcAccountId, ',')

SELECT ...

Most folks put in this situation will look for a quick win to buy the time necessary for the complete overhaul which Grant correctly recommends.

I think you have some...