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...

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...

lmu92 (4/9/2010)

---

@Ron:

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...

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...

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...

Jason Selburg (4/9/2010)

---

I recommend that you use the Search feature on this site before you post in the future. 😀

SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)

Can be found from yesterday's article here -->...

Nice question ....

Boy was I lucky ... Security was the topic for last nights user group meeting (ONSIG)

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...

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...

Hey, hey, designed small rocket engines for non space...

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...

Take me back to the good old days ... first computer was the IBM 709, (used vacuum tubes) later released...

From an article...

(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...

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...