Oh... then the only thing you can do is to find out why it is there, what it should do and so on... otherwise you're stuck. You can not rewrite a...

Something like this should be closer to the correct result, but I still have no idea what the trigger should do, as it is not apparent for your code -...

OK, to start with, how do you expect this will work if multiple rows are updated? You are trying to assign multiple values to one variable.

declare

@incidentID varchar(50)

set @incidentID =...

What's DOD? The only thing that comes into my mind is Dead On Delivery... which somehow seems to be appropriate as I read what you are asked to do. We'll...

Yes please, post the trigger code and table structure. It will be a lot easier to look for solution and explain problems if we all know what it is about.

What...

Well, if existing rows are your problem, what about something like

INSERT INTO audit_table

SELECT * FROM inserted

WHERE NOT EXISTS (select * from audit_table where primary_key = inserted.primary_key)

You may be better...

That's right, John didn't say anything about special holidays and long weekends - but Calendar table is a universal solution that can be used on many places, not just in this...

Interesting coincidence... this weekend I decided to look at a stored procedure I wrote some 2 years ago. Original version of this procedure I inherited was unusable, because it ran...

OK, try this as first step:

SELECT a.MatNum,

a.VerNumMat,

a.MatDesc,

a.SpecSta,

a.OldMatID,

...

I will try to reproduce what I understood so far, please correct me if I'm wrong.

1) You have a table dbo.tb_MatSpec, which has 200k rows. Column MatNum identifies an "object"; there can...

I suggest to read some articles on http://www.sommarskog.se, dealing with Dynamic SQL and usage of parameters in stored procedures, before you decide which way to go.

Hi,

unfortunately you didn't supply DDL and the cursor is uncommented, so it is quite hard to understand what you are trying to do. Could you please somehow describe what is...

If you need to work with a table that already holds such values, you are in problems. You can try to calculate something, but you have no guarantee that it will work...

Hello,

functions don't work well when used in a select across a large number of rows. Maybe you could post your entire query that's using this function, plus DDL of respective...

Hi

CREATE procedure_name @start_dte datetime = NULL, @end_dte datetime = NULL, @all varchar(1) bit = 0

1. IF @end_dte IS NULL SET @end_dte = GETDATE()

2. IF @start_dte IS NULL SET @start_dte = GETDATE()...