ScottPletcher (8/31/2016)

---

That doesn't use a "global variable". It creates a proc name that starts with ##. Only table names like that become global temp tables. The proc...

Don't put it at the top of the procedure, put it at the top of the SELECT statement.

The same way you have INSERT INTO #TMP_AllNeonates

Mementos

Here's an article on generating random integers and floats. The best part is that it doesn't have to go row by row.

http://www.sqlservercentral.com/articles/Data+Generation/87901/

DECLARE @Range decimal(5,2) = 6.5-.25, @StartValue decimal(5,2) = .25;

SELECT...

I would say that it's because of a bad decision applied to the design. However, that could only be answered by the people who actually did the design or at...

You could use the following:

(DT_WSTR, 6)( (DATEPART( "HH", GETDATE())*10000) + (DATEPART( "MI", GETDATE())*100) + DATEPART( "SS", GETDATE()))

Or this other option:

REPLACE( SUBSTRING( (DT_WSTR, 30)GETDATE(), 12, 8), ":", "")

There were so many possible problems with the view and the update, that I concentrated in the wrong one.

I had a good solution, but I won't post anything without seeing some real effort.

The problem seems to be coming from these 2 threads:

http://www.sqlservercentral.com/Forums/Topic1808920-3077-1.aspx

http://www.sqlservercentral.com/Forums/Topic1809713-3077-1.aspx

Once I see real effort and...

Here are 2 options along with sample data. Apparently, your counts per date don't match the real values.

CREATE TABLE #Sample(

Territory char(8),

Letter_Code char(10),

...

The DDL and transaction myth might come from Oracle and deformed badly. Hopefully, the myth that DDL is not affected by transactions will be gone eventually.

Hugo Kornelis (8/29/2016)

---

Ed Wagner (8/29/2016)

---

Ray K (8/29/2016)

---

djj (8/29/2016)

---

Hugo Kornelis (8/29/2016)

---

Ed Wagner (8/29/2016)

---

Pink...

Unfortunately, there's no way to downgrade databases or their backups. You'll need to find another way to replicate prod data in your dev server, or simply upgrade it.

PS. Not a...

You need to add logging to your package and define a file destination for the log.

Phil Parkin (8/29/2016)

---

There is more than one syntax error here (I thought...

Try to understand them, so if there's an error you can correct it.