anthony.green (11/9/2012)

---

Jason-299789 (11/9/2012)

---

Anthony's solution should work, or you could simply alias the converted field and reference that in the Order By

Eg.

SELECT distinct

pd.description

, convert(varchar(10),convert(datetime, pe.enc_timestamp, 103),103) enc_timestamp

, pd.icd9cm_code_id

, dsm.description

,...

Can you post the DDL and Sample data as well as expected results as this will help us help you with a solution.

Anthony's solution should work, or you could simply alias the converted field and reference that in the Order By

Eg.

SELECT distinct

pd.description

, convert(varchar(10),convert(datetime, pe.enc_timestamp, 103),103) enc_timestamp

, pd.icd9cm_code_id

, dsm.description

, pd.note

FROM...

I personally use a script to generate the drop constraints, this usually works and only needs tweaking

Select

'Alter Table ['+s.name+'].['+o.name+'] Drop Constraint ' +c.name

from sys.default_constraints c

JOIN sys.objects o on...

why are you doing this?

Are you looking to rename all the constraints or to change them?

The Dixie Flatline (11/9/2012)

---

There's a function for what you want: CONVERT()

select convert(varchar(6),convert(date,'01 Jan 1980'),12)

select convert(varchar(6),convert(date,'01 Jan 2000'),12)

The inner CONVERT function turns your string into a DATE character type. ...

You have some serious problems and the person responsible for dropping the century part of the date should be taken down a dark ally. (I've been reading too many of...

When I ran this in ssms

SELECT DATEADD(s, DATEDIFF(s, '1970-01-01 00:00:00', 1352325814), '1970-01-01 00:00:00')

I get an Arithmetic Overflow error reported.

And I cant for the life of me figure...

My personal favorite for SSAS is SQL SErver 2008 Analysis Services Unleashed,

http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Unleashed/dp/0672330563/ref=sr_1_6?ie=UTF8&qid=1352388963&sr=8-6

This one goes into the architecture as well as basic cube design best principles, about half way it starts...

Personally, I would have the developers build release scripts for applying to the Test environment then hand them over with release notes to the DBA.

He then handles the release process,...

I tend to use -1 with Unknown as the description, and occasionally also use -2 with Undefined at Source.

The two are very different especially when loading data from 2...

but if you built a bridge table between the Address and Name that just contained the Surrogate keys from either side, effectively creating a Tuple wouldnt that work?

EG

CREATE TABLE...

Could you not use a Bridge/Factless Fact table to accomplish this rather than a straightforward snowflake type join?

Then with a Many to Many relationship through the Bridge/factless fact you should...

Hi Kavita,

Sorry the CTE didnt help on the client site due to having SQL 2000 installed, just file it away for future reference, and beat the client with a big...

Can you post the DDL for Site, OrderHeader and OrderDetail as we might then understand the problem a little better.

What is the process for entering data into the OrderHeader...