Never mind... I got it from one of the posts above... just to make sure, you're using this from one of Gus' posts?

create table NumberClean (

Number bigint,

Clean varchar(100))

go

set nocount on

set...

So, in the million and 4 million row tests, what does your table and data look like? Are you just making a table with a Primary Key and a...

Thank you for the compliment, Chirag... but you're giving me too much credit. The key phrase was "consumes the larger part of a 60 GB drive. There are...

Sorry Martin, I'm going to have to bow out... I don't know much about the reporting tools.

Ok, so just write the function and use it in that...

mailsar (4/22/2008)

---

Jeff,

When i logged on to SQL server central, there were different groups. I was confused into which group shud i post this question. I found 2 groups which...

Think a bit more... if...

Then, you need to trace the source to the root cause.

Heh... then why have you posted so much on this thread about speed? 😉 The real answer is that...

Yes, you can include the last ELSE with a function. I wanted you to post the CREATE TABLE statement so I could build something to it to show you...

DB2 date/times are much different than SQL Server (if memory serves me)... I believe they're based on something like the number of seconds since midnight 1970-01-01. You will need...

It's really a PITA when folks double post... have a little forum courtesy, please.

http://www.sqlservercentral.com/Forums/Topic487503-338-1.aspx

Gooed! Hope you don't mind your audit table being 16 times the...

Sure... post the CREATE TABLE command where you want the calculated column.

Perfect... thanks.