Sample data, in case anyone else wants to have a go: -

SELECT [MemberId(F.K)], [Event], [Event Date]

INTO #yourTable

FROM (VALUES(1, 'Test Event1', '2012-03-20 05:39:51'),

...

Just to illustrate what Gail was saying. . .

You could easily test this out yourself.

USE tempdb;

IF object_id('dbo.Employees') IS NOT NULL

BEGIN

DROP TABLE dbo.Employees;

END;

--10,000,000 Random rows...

Is this not just a catch all query? In which case, check out one of Gail's blog posts on the subject --> http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D.

sugiarttampubolon (4/18/2013)

---

i am have a problem to get overtime hours

the table

EmployeeNo TimeIn TimeOut BreakHours WorkingHours

001 06:20 ...

lewisdow123 (4/17/2013)

---

Hi,

Thanks all for your comments.

So I have disabled the trigger and you were right because that improved the performance. However the problem I have is that this problem...

/*

Missing Index Details from ExecutionPlan.sqlplan

The Query Processor estimates that implementing the following index could improve the query cost by 99.8419%.

WARNING: This is only an estimate, and the Query Processor is...

You may want to have a read about custom types.

lewisdow123 (4/17/2013)

---

Hi,

I have a standard update statement that updates one row at a time. The table size is 340,000 rows, so it's large but it's not huge.

The first time...

Lynn Pettis (4/17/2013)

---

Two things. One, why the cross applies here. I don't think they are really needed. Two, the OP did say to treat NULL using getdate()...

Why are you storing dates as INT? To get the number of days difference, you're going to need to convert to DATE.

Try something like this: -

IF OBJECT_ID('abc') IS NOT NULL

BEGIN

...

karthik.catchme (4/9/2013)

---

Hi,

Please let me know how to get the initial size of the database file using T-SQL.

sys.master_files, sys.database_files, sysfiles, sysaltfiles --> gives only the current size and not the...

Steve Jones - SSC Editor (4/5/2013)

---

Cadavre (4/5/2013)

---

I'm in Castle Marina Premier...

I'm not going to the Thursday, but will be getting to my hotel sometime in the...

I can find at least one person that would not only agree with you, but would print...

Evidently my geography is a little off 😀