It can get really difficult to test this fairly easily. It is difficult to test the second proc. You have to go back and figure out how to create the...

So get the right 2.

Is this at least getting the correct results? We can tweak the performance but totally pointless unless the result set is correct.

Not really sure what you mean but can you use ISNULL in your sql? That way you will get a default date if there is no date.

Something like this?

(max(Ac_Client_Ledger_Transactions.PostedDate) <='2011-04-20')

Sure Excel has this type of formatting built in. Just right click -> format Cells -> chose your desired format. You can do this on a whole column in 1...

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and then call...

Something like this should work...

declare @Date datetime = '2011-10-07 13:18:48.720'

select LEFT(CAST(@Date as varchar(20)), 3) + '-' + CAST(YEAR(@Date) as CHAR(4))

This type of formatting really belongs in the front end and not in t-sql. However if you have to format it from sql you will have to make liberal use...

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which...

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a...

You can't cast that as TIME. You are talking hours and minutes.

Given your description take a look at this.

;with MyData(col1)

as

(

select 2932 union all

select 624

)

select CAST(col1/60 AS VARCHAR(6)) + ':' +...

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and then...

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and then call a stored proc...

That can't possibly be the entire code for your proc. It is selecting data from temp tables that are not declared inside the proc.