So you are saying the you open SSMS on your local machine and connect to Server1 and the IsDate check returns 1.

Then you RDP to Server1, open SSMS and...

Lowell (2/28/2011)

---

I think you can do what you want as a set of case statements

let me know if this model works for you:

SELECT

OtherFields,

CASE

...

It is a pretty odd requirement but then this is obviously not the real table structure and data.

I created the ddl statements and data inserts so that I can test...

Are the "missing" ones NULL or empty string? have you tried something like

Where IsNull(open, '') <> ''

What exactly are you trying to do? Given the data you posted what is the desired output?

Ashwin9 (3/16/2011)

---

ok, let me explain it.

I’m sending messages to all staff members.

But I want to validate this when we are off.

i.e. messages should not be sent except office hours.

I know...

In spite of the very legitimate questions about your architecture I believe the following should get you what you need.

update TableName set asofdate2 = Cast(cast(asofdate as varchar) as datetime)

Wow changing columns names from 'H#res' to 'H.res' is going to open an enormous can of nastiness.

things like

select #gorge, H#res, Er#es

will have to become

select [.gorge], [H.res], [Er.es]

Just...

The Edit rows feature is by no means anything you should be using to edit your data. The edit feature runs a transaction until you close it and when you...

WayneS (3/15/2011)

---

😀

(You didn't think of my article for explaining...

you try this...

[/code]

left join PLNotice pln on pln.PolicyID = hm.PolicyID and pln.InceptionDate = hm.InceptionDate

and (

(hm.CodeDesc ='UNDERWRITING' and pln.noticetype = 'UW')

or

(hm.CodeDesc = 'NONRENEW' and pln.noticetype = 'NR')

or

(hm.CodeDesc In ('RENEWALDNOC','DNOC')...

Wayne it was your signature I was thinking of as I was adding my reply. Applies 100% in this case.

Why does your customer care if it is identity or not? Micro managing customers are the worst.

Unfortuantely you can't just remove the identity property directly. You will have to...

You are pretty close but you cant set a column equal to a select statement.

UPDATE TABLE_PRODS

SET PRODNO = RIGHT(TP.PRODNO, TPL.PRODNOLEN)

...

Looks a lot like homework.

select ROW_NUMBER() over (partition by deptname order by deptname), ename, deptname from t1 order by ename

You should read up on the ROW_NUMBER function and by all...