Michael Valentine Jones (10/31/2008)

---

It’s usually better to store elapsed time in a datetime column as an offset from zero time, 1900-01-01 00:00:00.000. It then allows you to use all...

Heh... even though...

You don't need a counter for that... just store a date on every row and then count the rows in a data range.

jlcampos71 (10/29/2008)

---

Thanks Again Jeff!

I almost Figured that out... but I didn't at all... I was figuring out that I should make in fact, 3 passes, because there is a second...

No problem... thanks for the feedback.

J (10/30/2008)

---

I am wondering WHY the HINT should be necesswary in the statement

UPDATE Products

SET @PrevF2 = F2 = CASE WHEN F2 IS NULL THEN @PrevF2...

Seems like there have been a lot of reasons to use it, lately.

jsteinbeck (10/29/2008)

---

I knew you would post...lol

I'll check it out...

But i did figure it out, see my other post

Running Total isn't working in the UPDATE CLAUSE... doesn't that look...

jlcampos71 (10/29/2008)

---

This "Passing Parameters" Stuff is great... it almost solves my problem...

I might sound like a beginner next to you but this is the best I have found...

I have a...

Solution eventually reached at the following URL...

http://www.sqlservercentral.com/Forums/Topic593999-8-1.aspx

If you'd always like it to return Jan - Mar of the CURRENT year, then you don't even need to know what the current year is...

SELECT ID

...

evaleah (10/29/2008)

---

Sorry about the missing information.

I deployed it to SQL 2005 and it appears in the Assembly area. The routine creates an iCalendar formatted email message and then sends...

Why? Try this and see why I ask... ask yourself "What is 1 divided by 3 times 3?" 😛

DECLARE @A DECIMAL(3,0), @b-2 DECIMAL(18,0),@F FLOAT

SET @A = 3

SET...

Is the "autoshrink" option turned on on TempDB??? If so, it must be turned off!.

Also, you need to figure out what the largest it will grow to, add 20 or...

Better than that, tell us what the CLR is supposed to do so we can try to show you how to do it without a CLR... there's usually a way......