All these variables:

@type varchar(10),

@tempEmployeeCount INT,

@CurrentEmployeeID varchar(10),

@LastName varchar(20),

@FirstName varchar(15) ,

@VpOfOpName varchar(20),

@Date as varchar(12)

you declared as part of the parameter set which must be supplied when you invoke the...

I tried to do a life log, but I ran out of space and had trouble rolling back. So now I'm suspect.

The empty string ('') is NOT NULL so the first condition is true.

Encryption requirements?

Usage pattern (OLTP, DW, reporting, etc.)?

D'oh. I type too slowly...

Blocking on the system tables would be my first guess. Did you check for blocking locks?

The other thing you are leaving out is the vendor ecology. RDBMS technology and SQL had great success partly because it provided a consistent data manipulation method across multiple...

And another clarifying question:

Can a value change twice in a day such that there will be 2 values of an item for a given day? If so, how will...

Only reason I can think of for this would be you're either pointing at the wrong db or the wrong schema. I've never seen an alter successfully run but...

A variable or a column with data type char(10) should give you 10 spaces. If it's not, then at some point in your code or in the trigger it...

Did you upgrade the sql client software on the web server?

Under the Tools>Options menu, you have 'script dependent objects' turned on, I think.

Roger Zelazny - Lord of Light and/or Creatures of Light and Darkness. The Amber series would be interesting, but I can't imagine it would maintain interest over the number...

Don't know about the date, but this looks like it puts in the control characters correctly:

alter PROCEDURE dbo.Test

(

--@Dt DATETIME = '20140201'

,@tab VARCHAR(1)...

Don't have a place to test this right now but if setting DATEFIRST impacts the result, that could be why it might be considered non-deterministic.