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

Now, how about your code that isn't working? It would be helpful to see what you have done sofar.

Please read the first article in my signature block about asking for help. Follow the instructions in that article on what and how to post to get the best...

sqluser (8/5/2009)

---

1. If all the fldCID (101,102 for fldCID = 1) are available in AT then i have to get the maximum fldDates fldMID.

In this example only...

Can you post your code that you are have problems with?

Eswin (7/17/2009)

---

Hi Expertz

These procedures are blocking other processes.

Lock created is "LOCK_M_S".

In Most case the blocking is started from the Host_A which at that moment is exec "SP_UNPREPARE" and the...