Quick suggestion for a solution, if I got the description right;-)

😎

;WITH BASE_DATA(

DEP_ACCOUNT_NO

,DEP_SERVICED_AMT

...

Quick thought, is it possible that you were connecting to a different server yesterday?

😎

Quick thought, can you change this to a stored procedure and set default values for the parameters?

😎

Quick thought, run db-compare on source and destination to rule out changes on either end, something definitely has changed, question is what.

😎

Setting the nocount on eliminates network jitter such as count of affected rows, generally a good practice.

😎

No problem there, temp tables are isolated by sessions, as long as they are not global (start with a double hash ##).

😎

Quick thought, looks like the browser service is not working.

😎

Good stuff, make certain you get the spelling right:-D

😎

klgould1 (9/17/2014)

---

Hoping someone maybe able to assist with this procedure.

I am trying to increase the price of an product by a user entered % for items with Dishwasher in the...

Maybe this article Migrating a Database to SQL Azure using SSDT will help

😎

nikhil.desai1 (9/19/2014)

---

Hi,

I our SQL server project we are using xp_cmdshell to generate .txt or .csv file. As per SQL sever hardening xp_cmdshell is a security risk. Is there any alternative...

Guess...

okbangas (9/20/2014)

---

I've searched a bit, and from what I can see, both Geometry and Gography stores the coordinates as IEEE 754 64-bit float internally, hence there is no difference in...

enriquemallon (9/20/2014)

---

I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users,...

I thought that might be the case;-)

Here is an adjustment to the code, picks the two last entries for each subject

😎

create table #temp(candId int identity(1,1),CanNum int,name varchar(50),Attempt1 int,Attempt2 int,attempt3...