venki (2/9/2009)

---

Thanks for your response.

But my question is I want to do it in single stmt.

Actually,...

You'd have to build something like that yourself, or set up your maintenance plan to have one backup and cleanup task per database. You can do that, but keep...

No clue on that one. I've never seen that happen before.

Will a drug have more than one price? How about more than one compliance value or more than one "treated days" value?

Perhaps the correct solution would be to do...

Bruce W Cassidy (2/9/2009)

---

[font="Verdana"]You can also persist the calculated column, in which case it will only be calculated the once. Bits are good choices for persistance, since they take...

GilaMonster (2/9/2009)

---

Why?

Alter Table Add .... and add the computed column to...

You're right. Didn't think it through quite far enough. Try this instead:

create table #T (

Ver char(10) primary key);

declare @Alpha char(26)

select @Alpha = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

insert into #T (Ver)

select substring(@Alpha, number,...

My personal policy is to trust everyone I meet until I'm given a reason otherwise. Same for respect. I'm also a firm believer that people can and often...

You might try something like this:

create table #T (

Ver char(10) primary key);

insert into #T (Ver)

select 'A' union all

select 'B' union all

select 'AA';

select *

from #T

order by reverse(ver) desc;

Returns:

AA

B

A

In maintenance plans, there's a "Cleanup Backup task" that can do that for you.

If you put two apostrophes in a row in that, SQL will allow it.

Your post includes "if either dollar type 1 or 2 > 0". Under what conditions would this not be true? Or does this mean something other than what...

I guess I'd rather have ignore_dup_key off and have the insert code validate the data with an Exception operation. That's going to be easier to document, and it's going...

Welcome to SQL. Like anything else, it certainly has its quirks. 🙂

Vijaya Kadiyala (2/9/2009)

---

Thats really a good tip. This will work if you are creating a new table.

What if the table already exists, so in this case we have to use...