Try this:

select distinct

pat.vst_ext_id,

pat.adm_ts

from

DTR.paragon_rpt.dbo.TPM300_PAT_VISIT pat

/*

left join HPFDATA.his.dbo.ENCOUNTERS ENC

on pat.vst_ext_id = ENC.ENCOUNTER

*/

where

pat.vst_sta_cd = '14795' and

...

Please post your code, it will help. Also, which tables have which collation?

If you provide the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (as a series of INSERT INTO statements) for the table(s), expected results based on sample the...

Thinking procedurely instead of in a...

Basiclly, something like this:

update dbo.Employee set

Salary = Salary * 1.2 -- Increase Salary by 20%

where

DeptID = 3

and Salary...

Maxer (4/12/2010)

---

What I basically want to do is add up all 6 columns.

So NULL = 0 and NOT NULL = 1, then at the end I will add all 6...

Does this help?

create table #TestTab (

Col1 varchar(12)

);

insert into #TestTab

select '00123456' union all

select '0012345' union all

select '00234234' union all

select '0098765' union all

select '00012345';

select

right(Col1,...

bteraberry (4/12/2010)

---

And actually, using the +1 to correct the flaw GSquared pointed out negates the need to use the CEILING function since any non-null is going to be a number...

Please take some time to read the first article I reference below in my signature block. If you follow the instructions in that article you will get much better...

CirquedeSQLeil (4/12/2010)

---

Thanks Lynn.

I have to agree with the others in that thread - I don't see the relevance to a Masters Degree and I don't see why the person would...

bteraberry (4/12/2010)

---

GSquared (4/12/2010)

---

I'm pretty sure, if one of the values is 0, that will...

There is no way to turn off logging. Even in the SIMPLE recovery model updates, deletes, and inserts are still logged.

CirquedeSQLeil (4/12/2010)

---

Where is that one? I think it...

Something like this:

create table #TestCols (

Col1 int null,

Col2 int null,

Col3 int null,

Col4 int null,

...

TAMMYAUDETTE (4/12/2010)

---

My experience:

Company sales are down, freeze on spending and I lost 3 team members to downsizing.

Bottom line, I'm trying to do it all myself. We still need to...