Do you have access to teh AdventureWorks sample database? Can you use one or more of the tables there to formulate a similar problem?

As far as I am aware,...

Okay, now we are actually getting somewhere. How about providing us with the actual problem you are trying to resolve? Rather than asking piecemeal questions, put the whole...

hugh.hemington (8/5/2009)

---

The "Create Some Data" part of the "tutorial" is complete gibberish since it avoids showing how to assign static values to ANYTHING! (Kee-rist, who comes up with this...

emily (8/6/2009)

---

Lynn Pettis (8/6/2009)

---

A little confused as to what you are asking. Are you wanting the to return the last day of a month based on the current or...

This may be your requirement, but for every requirement, there...

You have provided the DDL for the table and sample data. The only thing I see missing that would help me is the expected results based on the sample...

A little confused as to what you are asking. Are you wanting the to return the last day of a month based on the current or given date, such...

donato1026 (8/5/2009)

---

That's a very good point....

That's the difference between a community (SSC) and a forum (all the others).

Thanks for the compliment (from all of us) and the feedback.

The...

I think I know what you are asking but it would help if you would provide the DDL for your tables, sample data for the tables, and expected results when...

donato1026 (8/5/2009)

---

Do you think it may have something to do with this line or the one a couple of lines below it (or both)?

else ((ABS(SUM(isnull(hmss.CREDIT_MEMOS, 0)) + SUM(isnull(hmss.EVEN_EXCHANGE, 0))))/(ABS(SUM(isnull(hmss.CREDIT_MEMOS, 0))...

homebrew01 (8/5/2009)

---

How do I merge this query with data from Table2 ?

Query 1:

Raw data:

[font="Courier New"]

Date Emp#LastFirstHours

8-1-2009 17SmithJohn2.3

8-1-2009 17SmithJohn1.6

8-1-2009 17SmithJohn3.3

8-1-2009 24Jonesmary1.7

8-1-2009 24Jonesmary4.2

8-1-2009 24Jonesmary1.1[/font]

select date, Last_name, First_name,...

Mitch2007 (8/5/2009)

---

Hi Lynn,

thanks for the reply and forgive my delay but things here have been swamped.

I ran your...