Yep... same ol' stuff, too! Basically a summary of everything that everyone has spoken of so far except how lame some (supposedly) certified folks "real skills" actually are. ...

No problem, Mick... It's easy to miss stuff especially when it's new.

There's nothing stopping you from that... think about it...

. EH! Wrong again! You only read the title... you didn't even read the requirements from the first post of the OP. Worse yet, this...

Your wasting a lot of time to maybe get it wrong. I don't normally advocate 3rd party software, but RedGates SQL Compare will do everything you just asked for......

Also, try Decimal(38,0) or BIGINT....

For way to many...

annas (7/7/2008)

---

Hello

This is my first post here and I hope this is not an insanely stupid question, but how does N recieve values in the function listed by Jeff?...

Absolutely not... it's just going to grow again and all you're doing by shrinking it is cause fragmentation of the underlying files at the OS...

Tomm Carr (7/7/2008)

---

This works wonders for me:

alter table dbo.CallCost

add Seconds as DateDiff( ss, 0, '1900-01-01 ' + Duration );

Now you have a computed column which very quickly, and behind the...

Heh... translation... BOOOOOM! 😀

B.A. Cooper (7/7/2008)

---

The following code works, but either of the commented lines produce a syntax error in my environment. When the code from the article is cut and pasted...

Ok... now, to understand how the function works, you have to read the following...

http://www.sqlservercentral.com/articles/TSQL/62867/

If you want a super deep knowledge of how to do splits well beyond what's in that...

mick burden (7/7/2008)

---

Thanks lads for the info, I've actually used the SQL below, the only problem is if I set the date to today, I get last week's data.

DECLARE @Now...

If you're not going to finish it, you shouldn't start it. 😉 What do you want to race on... again? 🙂