Bezan (9/1/2010)

---

WayneS, Result seems to be OK but there are fixed 5 periods and they have to be dynamic. I should be able to exec this with 3 or 20...

I would not call this paranoid, but prudent. Always remember:...

No problem. (Just look for < or >)

I can...

Craig Farrell (9/1/2010)

---

Rats, I'd hoped someone was going to come back with a way to do it by days that didn't end up tripping on the leap year for multiple...

Depending on how many of these you have to do, this may work better:

select top (1) Item

from dbo.DelimitedSplit8K(@sss, ',')

order by ItemNumber desc;

Click here for the latest...

How's this? Still needs to be made dynamic; I just want to make sure that it's working correctly first.

;WITH CTE AS

(

SELECT Partner, Account, Debit, Credit,

...

Bezan,

Given that @startdate = '2009-10-28', is Day1 = @startdate, or the following date?

irobertson (9/1/2010)

---

Lol,...

This looks like something that is being displayed to the user. This type of hiding of repeated values is usually handled in the displaying application.

I assume that you are using a cursor so that you can get the value of the identity column [dbo].[StockTransferNote].[WebSTNNo], so that it can be put into [dbo].[StnXItems].[WebSTNNo]?

In this case,...

Well, I'm in EST, which is GMT - 05:00. However, right now I'm showing a 4 hr difference, and we are in DST. So, since this is off of the...

GSquared (9/1/2010)

---

Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, but you get the idea) from...

Okay, so now that I blasted the previous query, here's one that will perform better.

Remarks are within the code.

if OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp;

CREATE TABLE #temp

(-- need to...

This form of a query is known as a "triangular join". You might want to check out this article[/url] for clues on why this query just might be the worse...

Marcia Q (9/1/2010)

---

Thanks for the responding, but maybe I need to make my question clearer.

We use SQL2005.

We are in the central time zone.

We observe daylight savings time.

We need...