Viewing 15 posts - 1,981 through 1,995 (of 3,221 total)
For those of you who expend a great deal of time / effort to share their knowledge of SQL .... here is one who really appreciaes your efforts.
Hope...
April 10, 2010 at 7:08 am
itskumar2004
Please follow the first link in my signature for posting information in a reasonably consumable format, i.e. Create table statements, sample data (be careful NOT to use real names...
April 9, 2010 at 5:05 pm
lmu92 (4/9/2010)
Unfortunately, your solution does lead to pay twice for one hour.
For example emp_id 222:
The hour between 17:00 18:00 is included twice in the sample data (for shift A and...
April 9, 2010 at 2:54 pm
Sorry did not read your last post (about using seconds) but this will compute total hours worked. I also edited / added some additional data to test for start...
April 9, 2010 at 2:26 pm
Sql Student-446896
For future use. To check for "hidden" characters such as a carriage return or line feed" try using this:
I added it to my tool box and...
April 9, 2010 at 8:47 am
Jason Selburg (4/9/2010)
SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)
Can be found from yesterday's article here -->...
April 9, 2010 at 7:43 am
Nice question ....
Boy was I lucky ... Security was the topic for last nights user group meeting (ONSIG)
April 9, 2010 at 7:34 am
I have copied and pasted your code into SSMS and executed same - no error reported. Now to get tested help please post using the directions given in the...
April 8, 2010 at 9:03 pm
Change your and to an OR
if not exists (select column1 from #test where column1 = 'test' OR column1 = 'test1')
But what are you doing ... inserting new rows, updating existing...
April 8, 2010 at 7:20 am
GSquared (4/7/2010)
WayneS (4/6/2010)
Does anyone else around here feel like a rocket scientist?[/u]I used to play with model rockets. Does that count?
Hey, hey, designed small rocket engines for non space...
April 7, 2010 at 5:35 pm
Lynn Pettis
I remember cleaning the 9-track tape drives, also. Some of the best tapes were the 3M Black Watch, but boy were they dirty. When using those we usually had...
April 7, 2010 at 4:31 pm
Tom.Thompson
You know, the first time I played with a computer
Take me back to the good old days ... first computer was the IBM 709, (used vacuum tubes) later released...
April 6, 2010 at 9:39 pm
Paul White NZ (4/6/2010)
Chris Houghton (4/6/2010)
Couldn't see the point in the question, unless it was teaching that this functionality existed.Seems like a pretty fine reason, right there 😛
From an article...
April 6, 2010 at 8:29 am
(The next time you post, please post the table definition and sample data as I have shown in the first code block. It will most likey get you a...
April 5, 2010 at 6:11 pm
Follow the first link in my signature block to post the table's definitions, including indexes (if any), column constraints (if any). Without knowing the details about the table it...
April 5, 2010 at 5:02 pm
Viewing 15 posts - 1,981 through 1,995 (of 3,221 total)