Good to know, I wasn't aware that it rounded up.

It is wierd that if you do .998 it shows as .997.

declare @d datetime;

set @d = '2014-04-23 23:59:59.998'

select @d

Lynn Pettis (4/23/2014)

---

below86 (4/23/2014)

---

Wouldn't it be better to use the BETWEEN with these dates?

WHERE (ath_postype = 'NTC' OR ath_postype='NTD')

AND ath_postdate BETWEEN '2013-01-01 00:00:00.000' AND...

Wouldn't it be better to use the BETWEEN with these dates?

WHERE (ath_postype = 'NTC' OR ath_postype='NTD')

AND ath_postdate BETWEEN '2013-01-01 00:00:00.000' AND '2013-01-05 23:59:59.000'

I was trying to develop something similar, can't get time to get back to it. What I was thinking is if I know I'm adding a new entry and...

I got the same error, so I made them all Case statements.

CASE WHEN COALESCE(CL.COLUMN_DEFAULT, '')= COALESCE(CL1.COLUMN_DEFAULT, '') THEN '' ELSE '|COLUMN_DEFAULT IS CHANGE' END +

CASE WHEN COALESCE(CL.IS_NULLABLE,'')=COALESCE(CL1.IS_NULLABLE, '') THEN ''...

We have a table with about 80 million rows, only about 75 columns though. A couple of these columns are all NULL. I found looking at one at...

Me too, now that's at least two months in a row it has stopped.

Try the INTERSECT command. The either insert into or put the results into the table.

-- INSERT INTO TableC

Select field1, field2

-- INTO TableC

from tableA

INTERSECT

Select field1, field2

from tableB

;

Steve Jones - SSC Editor (3/27/2014)

---

below86 (3/27/2014)

---

I know this may not be what you meant by "The first is willfully taking part in any illegal activity.". But what about...

Gary Varga (3/27/2014)

---

below86 (3/27/2014)

---

I was once fired, on a Monday morning when I first came in. Now they had to know Friday before that, so why not do it...

I was once fired, on a Monday morning when I first came in. Now they had to know Friday before that, so why not do it then? Who...

Thanks for the reply Jeff, I was thinking that putting the data to a 'staging' table made more sense to me too.

Some stats, the table has about 75 columns. ...

This might be an option for some, but in our company we can not get to twitter, facebook, ect.

While I would almost never want to use code generated by some tool, I would also say stored procedures are not the silver bullet for everything or everybody. I...

I finally got it, but it was after 5 PM my time yesterday. I already got today's, so it looks like things are working again for me. 🙂