Snargables (3/23/2015)

---

I'm sure i could multiply it by something to get it to work however that doesnt explain why it will convert 1.35e6, 1.35e5, 1.35e4, 1.35e3, 1.35e2, 1.35e1, 1.35e-1, 1.35e-2,...

Try these

select cast( '1.550e-6' as float) * 100000

select '1.550e-6' *...

It is converting from varchar to float.

I'm not sure why it is displayed in exponential notation, but it is still a float and appears to have the right value.

If you use decimal instead, I think that...

Snargables (3/23/2015)

---

For whatever reason i'm unable to cast anything more thtan e-4 to a float which makes no sence. Am i missing something?

select cast( '1.550e-6' as float)

?????????

returns 1.55E-06

????????

select cast( '1.550e-5'...

Eric M Russell (3/23/2015)

---

If DATE_MODIFIED is populated when the row is initially inserted, and it's updated consistently by the application, and it's indexed, then that's...

Lowell (3/23/2015)

---

or is there an incremental primary key in the Oracle source that you can just select fromOracle where the...

Is there a 'DateCreated' column in your source data?

If you type

Me.Connections.

does Intellisense give you any options at all?

I just noticed another thing ...

If you do a LEFT JOIN from table A to table B, you are telling SQL to return all rows which match, plus all rows...

Perhaps. If you frequently need to filter based on year.

Alternatively, if there is already a suitable index on the datetime column, change your filter from

Year(col) = 2013

to

col >= '20130101'...

I see no way (or reason) to introduce windowing functions here.

I suspect that you would see a large performance improvement if you were to add a QuotaDateYear column to your...

I've read your posts and I don't understand 100% what...

Here you go

where (

dbo.ocsTimeHeader.tshStatus = 'ACTIVE'

or dbo.ocsTimeHeader.tshStatus = 'IDLE'

...

Steve Jones - SSC Editor (3/18/2015)

---

You can use datepart to extract the month, and day, and then concatenate them together.

cast( datepart(mm, mydatecolumn) as char(2)) + '/' + cast( datepart(dd, mydatecolumn)...