yes .. but want to know is there is any other way w/o using xquery.

Got the answer.... 🙂

weitzera:

I need construction logic to write the code for trigger. The problem here is everything is dynamic. When the user configures the audit Primary & Secondary, something (SP /...

Hello,

As you'r using it in Search Criteria the UDF will be called for all records for matching the search criteria.

is there is any dependecies on this table?

you need to define the archiving strategy first.

1. define the tables wants to archive

2. what would be the archiving period.

are you working with getting paid! Boooooo. and on top of it you got fired big boooooooooooo.

Please provide more information on Job, what does it do?

I think you can't do it on one sever instance.

What is the case scenario?

Why do you want to delete records from all table?

I think you can use DATEFORMAT. it overrides the implicit date format settings.

try this....

select * from Purchasing.PurchaseOrderDetail

where case @OrderQty when 0 then OrderQty else @OrderQty end = OrderQty

and (@duedate IS NULL OR duedate = DATEADD(dd, DATEDIFF(d,0,@duedate), 0))

try this...

select * from Purchasing.PurchaseOrderDetail

where case @OrderQty when 0 then OrderQty else @OrderQty end = OrderQty

and (@duedate IS NULL OR duedate = DATEADD(dd, DATEDIFF(d,0,@duedate), 0))

trying doing it by using PIVOT operator. below is the example

DECLARE @params AS TABLE

(

ParameterID NVARCHAR(8) NOT NULL,

...

okay just putting my understanding what you are looking for is

If @assayid int > Then search by @assayid

and

If @dateassayrequested datetime is Valid date Then search by datediff

If this is...