jcrawf02 (9/3/2014)

---

My wife keeps telling me I need to stop swearing around the two year old. I'm going to replace swearing with database jargon randomness now...

Flaming Firehose Cursors!

Backwards Compatibility!

Great Moden's...

I do not oracle but after a quick google search, try this

SELECT *

FROM OPENQUERY (LS_RDB_DWH, 'SELECT * FROM RDB_DWH.ENTITY_DIMENSION WHERE PD_RDB_ENTRY_DATE >= TRUNC(SYSDATE)')

The syntax error is due to insufficient quotes. You have use two single quotes to get one when using them inside OPENQUERY

ie

SELECT *

FROM OPENQUERY (LS_RDB_DWH, 'SELECT * FROM RDB_DWH.ENTITY_DIMENSION WHERE...

Your query is returning a date datatype, the gui interface (SSMS) is displaying as characters formatted as to the language of the login.

So

SELECT CONVERT(DATE,GETDATE()) AS CurrentDate;

and

SELECT CONVERT(varchar(10),GETDATE(),120) AS...

SYSDATETIME() will give you current date and time

CAST(SYSDATETIME() as date) will give you current date only

What are you referring to with 'Current Date'?

What do you mean by SQL Server Date...

Eirikur Eiriksson (8/27/2014)

---

In that case

SELECT a.steps,MIN(b.steps)

FROM #table1 a

CROSS JOIN #table1 b

WHERE b.steps >...

You're welcome 🙂

As an...

SELECTa.BOOKING_NUM,

d.COUNTRY_DSC,

CASE WHEN POL_LOCATION_CD IN ('DKAAR', 'DKCPH', 'FIHEL','FIKTK', 'IEORK', 'IEDUB', 'NLRTM', 'PTLEI', 'PTOPO', 'PTLIS', 'ESBIO', 'ESVGO', 'SEGOT', 'SEHEL', 'GBBEL') THEN 'NLRTM' WHEN POL_LOCATION_CD IN ('DKFRC',

'FIRAU', 'FIOUL', 'DEBRV', 'NOAES', 'NOBGO',...

CASE WHEN PATINDEX(REPLACE(LEFT(address,CHARINDEX('.',address)-1),'@','@exc.')+'%,',alias+',') > 0

THEN STUFF(alias,PATINDEX(REPLACE(LEFT(address,CHARINDEX('.',address)-1),'@','@exc.')+'%,',alias+','),

(CHARINDEX(',',alias+',',PATINDEX(REPLACE(LEFT(address,CHARINDEX('.',address)-1),'@','@exc.')+'%,',alias+','))

- PATINDEX(REPLACE(LEFT(address,CHARINDEX('.',address)-1),'@','@exc.')+'%,',alias+','))+1,'')

ELSE alias

END

Koen Verbeeck (8/19/2014)

---

higgim (8/18/2014)

---

Not a happy chap with some of the help being offered! Go figure 🙂

Qira (8/18/2014)

---

Dear Mr Higgam,

You're helping me sir. Thanks to you. But no thanks to...

If you want another alternative

LTRIM(PARSENAME(REPLACE(SomeString,'-','.'),1))

😀

*Edited*

p.s. BTW, before you start, I did not say it was a good alternative 😛

:sick:

This thread is becoming less Random and more Jung 😛

Jeff Moden (8/4/2014)

---

I'd let you...

Not waving, but drowning 😛

The thread is sure to test your sanity (unless you are already insane :w00t:)