Viewing 15 posts - 1,681 through 1,695 (of 3,221 total)
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...
October 14, 2010 at 11:30 am
Marv-1058651 (10/14/2010)
Would I be able to add my results from the second stored procedure into a cursor in the first procedure?Thanks
Why oh Why do you want to use a cursor?...
October 14, 2010 at 10:18 am
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 ...
October 14, 2010 at 9:53 am
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...
October 13, 2010 at 9:15 am
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...
October 11, 2010 at 3:11 pm
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...
October 11, 2010 at 3:06 pm
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...
October 11, 2010 at 2:23 pm
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...
October 11, 2010 at 7:17 am
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)
The above blog also contains...
October 10, 2010 at 1:07 pm
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,...
October 10, 2010 at 10:32 am
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...
October 10, 2010 at 10:16 am
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...
October 10, 2010 at 10:05 am
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...
October 9, 2010 at 3:36 pm
Here is an excellent article by Jeff Moden which might assist you. I suggest you read it, and run the sample code provided
October 8, 2010 at 5:28 pm
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...
October 8, 2010 at 11:57 am
Viewing 15 posts - 1,681 through 1,695 (of 3,221 total)