Did you try putting a break point on post execute event of the execute SQL task try watching the variable value getting assigned?

A simple SSIS package can do the trick for you.

Why don't you pass the parameter like

If @alloc_id < 0

exec proc2 @alloc_id

Hi

This is a SQL server forum, so you can expect quick help for SQL questions.

Yet, looking at your code I think you need to rearrange your code, you can...

One always. Two many times. Its mostly the client's decision based on their priority and budget. My role is often to appraise the stakeholders honestly about the different options...

robert.sterbal 56890 (12/2/2016)

---

joeroshan (12/2/2016)

---

Hi Robert

I do not have any problem someone using the script to help their job done easy. In fact that is...

Hi Robert

I do not have any problem someone using the script to help their job done easy. In fact that is the point of...

ggrewe (12/1/2016)

---

I am not sure why are you dropping and recreating the Foreign Keys? Why not just disable and re-eanble them?

If the table has an Identity column, you cannot...

Bruce-12445 (11/30/2016)

---

Joe - it might be better to do both inner joins on the asset to attribute table which returns a match of 14,538 records a 40,355 difference from returning...

GilaMonster (11/30/2016)

---

That is specifically for...

It is recommended to create multiple data files with same size to optimize tempdb to take advantage of proportional fill algorithm and reduce allocation contention. Unless you have separate file...

Good call. I have always found linked server/ openrowset slower and resort to it only in case of emergencies. Thanks for posting the statistics.

Just curious, why are you not executing...

The plan with join looks better since you are getting a seek for the Asset table. But both cases the left join on the asset_attr table is going for a...

I think Gail has a point there.

I have had side by side many times but I can remember always it was the lower version first.

It would be good to test...

Got your point. You will use loops sparingly. But whenever using loop is it a good practice to use temp tables instead of the actual table. is that your query?

It...