Create and delete static tables on fly is one of the worst possible ways to do things in SQL Server.

There are many other ways to do what you're doing, which...

NineIron (7/18/2016)

---

Here's my query.........I have dealt successfully with collating issues before but, they have been in the joins between tables. I don't know where to place the "collate database_default" in...

Lynn Pettis (7/8/2016)

---

By the standanrd that you...

Long enough - by which standard?

:hehe:

Jeff Moden (7/7/2016)

---

It is amazing, though, that such "multi million dollar" companies can't or won't get something so simple right. Forcing other companies to create work arounds is what...

It may be not entirely SQL2014 fault

I've set up a quick test in 2014 instance:CREATE TABLE #NUMBER_TEST

(

UNDEFINED NUMERIC (20,4)

)

INSERT INTO #NUMBER_TEST

SELECT -98.786 UNION

SELECT -98.785 UNION

SELECT -98.784 UNION

SELECT...

They are not.

I provided an example where CAST is not doing its job properly. and can add more.

which is true in the vast...

drew.allen (7/7/2016)

---

Actually, I did provide my rationale,...

Well, would not say "dripping".

-...

Lynn Pettis (7/6/2016)

---

How about a page from Mr. Celko's book (none of which I have or will read), because CAST is the ANSI standard and CONVERT isn't.

You should always write...

There are more.

You can easily filnd them if you look up for the article "CASR and CONVERT" in BOL.

That...

Will some of these work for you?

COUNT(case when [>7 Days] = 1 Then invoiceid else NULL end) as [Total >7 Days]

,COUNT(case when [>7 Days] = 1 Then NULL ELSE...

You do not use @DATABASE anywhere in @BCP query.

The database must have been set up as default for the user on that SQL 2005 instance, therefore the query worked there.

Now...

From the plan I can see the column [Date Time Beginning (EST)] belongs to table [bids_raw_da_miso]

But I don't see this table anywhere in the query.

And if you select by range...

Most likely...