Sure! coming right up...

select TransactionID,

sum(case when Comm.GrossOrNet...

Jeff Moden (3/18/2008)

---

Gosh... ya gotta wonder, though... seems like the VarDecimal datatype option has a pretty limited application... you'd think they'd have spent more time on something important like getting...

Wow - I didn't even read the question correctly. Thanks Jeff for the wake-up there (pinging the caffeine IV).

I just came across this -

http://weblogs.sqlteam.com/mladenp/archive/2006/11/10/19546.aspx

It does seem to work...

As long as the system is small enough, and you are willing to spend the time at night - going UNC is certainly your call. I would still...

The only difference I can see between Decimal and Money data types is that Money has a fixed four digits after the decimal point, whereas the "regular" decimal is configurable....

DB_Newbie2007 (3/13/2008)

---

I could change the SQL Agent to just process multiple log backups on the days I know there is a lot of activity (great suggestion!), but what about the...

To echo GilaMonster's point - it's usally not a great idea to back up to a mapped drive/network drive. Even on a fast network - it's going to be...

For what it's worth - those types of joins are set to not work in 2008. So the "future version" isn't so future at all.....

How much data does that 12-month period represent? if that's small compared to the 2TB - it will be faster to copy out the stuff you want to keep...

unfortunately - yes they can be. They're not terrible at times if the output is small - but since TVF's essentially are materialized as table variables - they can't...

I don't see how this could work. You're passing in an ID (either character or integer) that identifies a program, and the function is expecting an object which IS...

Jack Corbett (3/17/2008)

---

But wouldn't the insert have an exclusive lock on the new row created until the end of the transaction and the update, without a where clause would need...

To the best of my knowledge - they all have ServerProperty('licensingMode') set to DISABLED.

Of course - that also applies to dev edition (whether or not you got it through MSDN).

So...

You're trying to back-door in what would be called dynamic SQL, which unfortunately requires being executed from EXEC or sp_executeSQL (both of which are prohibited in a function).

That being said...

Trying to cast '00000000' will result in an error since it can't be converted to a date - so you will need to suppress them somehow or replace them with...