Thanks, I hate using temp tables too

and I was sure I wasn't thinking straight with #temp and ROW_NUMBER

Say yes to CTE and Subqueries/Derived Tables!

I am sure there's a better way, and less #temp tables involved

but here's my first try. Idea is to give Identity to each row, and find the streak, and select...

Since there's a missing row in the middle you didn't show, so you are looking for any X-consecutive rows right?

so in this case, only rows that fit the criteria would...

My first thoughts are either ROW_NUMBER, or Tally table

I'd say provide a sample data set (in SQL code) so that we can assist you better

To clarify though, shouldn't results be...

I imagine if a company has to comply to SOX, there has been modifications to data retention policies (at a significant cost)

But I do not ever want to be in...

Thanks for the script, I like it shows Orphan users too

For those situations, you almost need 1 dataset per 1 dropdown parameter (from query)

You could do cascading dropdown though

e.g.

1st dropdown is Country = select name from country

2nd one is...

I wonder if SQL Nexus to load 9GB trace file

http://www.codeplex.com/sqlnexus

What is SQL Nexus?

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It...

I'll double check the SMTP server is reachable from the SQL Server

The error log did seem to indicate that way, not login failure or mail rejected etc...

so you want only UNIQUE Field1 from Table1? is that the requirement?

and it's okay to have duplicate entries in Table2?

GROUP BY or ROW_NUMBER can mimic DISTINCT as well

I don't know how to do this, nor know why this is necessary

Identity is an artificial surrogate key, like someone said, do not give it a meaning 😛 it is...

Thanks for the script Peso

I am making a little modification to it so that startTime and endTime will use the infoDate date

otherwise it keeps showing "1900-01-01 05:00:00.000" for a Daily...

You can install it and not start/enable it, it won't hurt

and when you need it in the future, you don't have to go through the SQL Server installation again

Absolutely Stable I'd probably pick Windows 2003 R2 SP2 just because it's been out for long and tested

But in general I would pick Windows 2008, I've heard about the performance...

Note: watch out for ending previous statement with SEMICOLON

Here's a working code sample

CREATE TABLE #Test

(

EmpID INT,

EmpName VARCHAR(50)

)

INSERT INTO #Test VALUES(1,'Daya')

INSERT INTO #Test VALUES(1,'Daya')

INSERT INTO #Test VALUES(1,'Daya')

SELECT * FROM #Test;

WITH Emp...