Based on your last post (please note that I drop your table at the end to clean up my Sandbox database):

create table dbo.estr(

custo int,

product varchar(20),

val int,

billed_date datetime

);

insert into dbo.estr(custo,product,billed_date,val) values('10','Milk','2013-04-11','2000');

insert...

[font="Arial Black"]Merry Christmas to One and All from Afghanistan![/font]

May you all enjoy this festive time with family and friends. Please take a moment and remember those who are from...

At $75.00 USD or less, just buy the Developer Edition. I find it well worth the cost.

bkshn (12/22/2013)

---

Hello

I run code bellow.

declare @SQLstring nvarchar(max) , @ExeCommand nvarchar(max),@OutString nvarchar(max)

set @SQLstring = ' EXEC [dbo].[xmlGenerate] 20, 100001, 1 '

EXEC sp_executesql @SQLstring , N'@OutString nvarchar(max) output',...

sharpcnet (12/22/2013)

---

This code is to perform a Soft Delete. It deletes a record first. If the delete was successful, rollsback and then updates the flag column of the same record....

Care to provide a better description of the question?

I am not sure if you are asking what the difference between the parameters declared as input/output to the procedure and variables...

Well, not sure where to start since there is nothing from which to work, no DDL, sample data, expected results, or what you have tried so far to solve your...

Looks to me like you will have to uninstall and reinstall SQL Server with new license keys. As far as I know you can't just change the key. ...

ScottPletcher (12/20/2013)

---

...

And my original point that somehow upset so many was this since this code:

WHERE ( SomeCharacter IS NULL OR SomeCharacter = '' )

is both clearer and performs better, then...

Greg Edwards-268690 (12/20/2013)

---

Grant Fritchey (12/20/2013)

---

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of...

To the best of my knowledge, no. As long as your client has the proper documentation to show that the SQL Server software is properly licensed that should be...

IT2012 (12/19/2013)

---

Got it!! It's dog-eared and worn but within reach at all times!!! As well as Joe Celko's SQL for Smarties, Murach's SQL Server 2008, Microsoft's Inside T-SQL...

In SSMS I created your table (dropping the FK reference), then ran the insert into the table with no errors. Not sure what could be happening.

ScottPletcher (12/19/2013)

---

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use it in...

Have you looked in the error logs to see if there is more information there?