Added some data (additional employees) to your original data:

select '102','Off','8/1/2010' union all --added

select '102','off','8/9/2010' union all --added

select '103','off','8/9/2010' union all --added

select...

Why oh Why do you want to use a cursor?...

Data copied and Before your editing at: Edited: Today @ 11:15 AM by naresh0407 93367

CREATE TABLE #Test1(Rownum INT IDENTITY(1,1),empno VARCHAR(3), MatchingOff varchar(10),

atnDate datetime)

/* added column Rownum ...

This is has nothing to do with SQL or any software for that matter. But turning on the TV news at 6 AM this morning and seeing the 10th...

In the subscription emails, when you click on a link, the target page opens in the same window. Many of the target pages have links that one follows to understand...

YOu may want to test this to determine if it fullfills your requirements.

No cursors, two temporary tables. By the way the major amount of the code below is from...

sbrochu

To help others help you, please post your table definition, sample data, required result and the code you have run following the directions contained in the first link in my...

Take a look at a function posted by Jeff Moden

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Using it with todays date and one day earlier:

SELECT Dbo.fn_WorkDays('10/11/2010','10/10/2010')

The function returned 1 as one working day.

Executing it as:

SELECT...

For a good discussion of why page splits occur and what happens, read the following (It contains sample code and results to make understanding much easier)

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/28/what-is-a-page-split-what-happens-why-does-it-happen-why-worry.aspx

The above blog also contains...

ldsudduth1

Actually, HIPAA only applies to medical records maintained by healthcare providers; but this device is *not* encrypted; making me extremely wary, since it also has personal information (name, address,...

Jeff

Ummm.... I happen to know that you're about 3 days older than dirt, Ron. How old is your mother-in-law and can I get some of whatever it is that she's...

Matt Miller (#4)

I sure hope that stuff is encrypted or those folks stand to get sued for a giant breach of HIPAA. And - even IF the data itself is...

Steve thanks for a great idea ... My mother-in-law has a medical bracelet which appears to be nothing more than be a thumb nail with a form and program which...

Here is an excellent article by Jeff Moden which might assist you. I suggest you read it, and run the sample code provided

http://www.sqlservercentral.com/articles/T-SQL/68467/

Does your procedure utilize the dynamic management view

sys.dm_db_index_physical_stats to check

"avg_ fragmentation_in_percent".

And then test that value to see if it exceeds say,

30 per cent to select...