Quick thought, open all scripts in SSMS and do Find and Replace in All open documents

😎

Overruns

No worries, enjoy!

😎

Try copy the single row from the second query and paste it to a text editor, the full statement should be there.

😎

Since you don't need historical quantities, you can just summarize the current status

😎

SELECT

WM.ItemID

,SUM(WM.Quantity) AS CURRENT_QTY

FROM @WhareHouseMovement WM

GROUP BY WM.ItemID;

What does this query return?

😎

SELECT 'grant execute on ' +

...

Came across this few years back, caused some strange behaviour and took some effort to find the cause. Workaround was to call T-SQL GETDATE() once at the start of the...

Smell

Still cannot run the DDL and sample insert as the insert for the dbo.giftregistry is missing;-)

😎

Quick thought, no need for a dynamic sql statement here.

😎

The query you are constructing looks like this

SELECT

N_image_number

,N_image_name

,N_image_desc

...

dmayley (5/4/2015)

---

Eirikur Eiriksson (5/3/2015)

---

Quick questions, is the server running SQL Server? Is AWE enabled on the server? What are the memory (min/max) config of the SQL Server? What is the...

Quick question, why not create the symmetric key in the destination database?

😎

Good point Lowell, without the restrictions this is a proper time bomb, down the line it will...

Quick question, could it be seconds after midnight UTC?

😎

To convert to a time value, use DATEADD(SECOND....

DECLARE @TTIME TIME = CONVERT(TIME,'00:00:00');

DECLARE @SECONDS_AFTER_MIDNIGHT FLOAT = 75644;

SELECT DATEADD(SECOND,@SECONDS_AFTER_MIDNIGHT,@TTIME);

Further on Grant's post, recommend you have a look at Kalen Delaney's book SQL Server Concurrency:

Locking, Blocking and Row Versioning

😎