Remember that float is an approximate numeric data type. These things can happen when using it.

You could try rounding or other options to reduce the errors.

SELECT CAST( CAST( 2306.7555 as...

j-1064772 (6/8/2016)

---

Luis Cazares (8/5/2015)

---

You could use something as the differences of EXEC() and sp_executesql. Or just ask for them. You might want to ask about how to prevent SQL Injection...

Failing

If exporting to a flat file, it doesn't have to be on "individual rows", just add some line feeds.

SELECT Dept + char(10) +

( SELECT CAST( id...

Ray K (6/8/2016)

---

Kinda like wondering why...

Thom A (6/8/2016)

---

If the OP wants to follow this solution (yes, we have discussed maybe it's not the "right" one, but my point remains), then it's a good starting point,...

What's your impression on this campaign? https://youtu.be/vXeF6Uot8pk

I feel that the main message is correct, but it's not handled correctly which ends up on the message being lost.

There's something going on with your server. Taking 16 hours to complete a single query is insane.

We're assuming this is a table, but if it's a view, that could be...

BrainDonor (6/8/2016)

---

Ed Wagner (6/8/2016)

---

djj (6/8/2016)

---

Ed Wagner (6/8/2016)

---

Jeff Moden (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server...

For a fast sequential read of a table to move data from one system to another, you could also use SSIS.

You're doing ETL work, use the ETL tool.

pinheiroinfo (6/7/2016)

---

Good afternoon,

I have a SQL code where I can score with 1,2 and 3 the amount of time between the O.S.s , but would like to add the amount...

Actually,...

Here's the example for 2008 and 2012.

DECLARE @Sample TABLE(

ID int,

Value money)

INSERT INTO @Sample

VALUES

(1, 70 ),

(1, 90 ),

(2, 100),

(2, 150);

WITH CTE AS(

...

I would guess that blocking is happening somewhere in your db. Maybe there's an open transaction. Even with 2.6m rows, it shouldn't take hours to complete.

However, this should be faster...

Lynn Pettis (6/7/2016)

---

Luis Cazares (6/7/2016)

---

WayneS (6/6/2016)

---

PRO TIP:

If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup...