I need to lose between 30 and 40 depending on what you read on the net.

CirquedeSQLeil (3/31/2010)

---

Paul White NZ (3/31/2010)

---

Trey Staker (3/31/2010)

---

@paul-2 -- Thanks

Your links on that dear thread were very helpful. That is what I had on my study agenda today, it...

You are looking for something more like this:

declare @xx as datetime;

begin try

select @xx = convert(datetime, '2010-02-31 00:00:00', 102);

end try

begin catch

select 'only 28 days in February';

end catch

Not necessarily how I would...

Paul White NZ (3/31/2010)

---

Encrypt the compressed backup you mean?

Otherwise, encyption and compression do not...

The sample data is not in a usable format, should be provided as a series of INSERT INTO statements that can be cut/paste/run in SSMS.

Also need the expected results based...

I think people are just trying to find ways to get The Thread to 20,000 posts before the end of the year.

Time to clear the tables ............. Hippo style...

Lizards, snakes, and spiders Oh My! (Just keep them away from me!)

A few things tht would really help, the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (series of INSERT INTO statements) for the table(s) involved, expected results based...

We are using it in production as well. I am quite happy with the native compression. I am also quite happy with the speed with which our backups...

Your invoice for the product. I don't believe there is any way to query SQL Server 2005 to know how it is licensed. Please let me know if...

keepintouch2b (3/31/2010)

---

Thanks all who have replied.

To sum it up, "In general, you use table variables whenever possible except when there is a significant volume of data and there is repeated...

Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we have been having on this thread....

CirquedeSQLeil (3/30/2010)

---

Lynn,

Do you have any other jobs or processes that may be trying to fire it off? I ask because I have a ton of jobs that are setup...

See what happens when you provide both sample data AND expected results based on the sample data?

That's why we ask for all the info we do, to help...

Okay, I am getting a bit confused. Based on the sample data provided, what is the results set you are expecting to get?