Hi Luis and Sean

Thanks a lot for your advise.

I tested Luis code it was working fine and I get the expected results.

Sorry I don't understand what duplicates will i...

Hi

I will have many rows on the records table.

What if if i want to pass 2 dates ie like between two dates.

HI Sean Lange

Sorry - I didnt check the post before. Thanks for your advise. I will follow it hereafter and these are not real table names and are with fake...

Hi All

I need your help Im not much good in Tsql.

I have 2 tables Rates and Records, I need to calculate the total cost for each country picking the rates...

Hi All

I even tried this way - using the name space as : \\.\root\cimv2 but no luck

USE [msdb]

GO

EXEC msdb.dbo.sp_add_alert @name=N'SimpleFolderWatcher',

@enabled=1,

@delay_between_responses=0,

@include_event_description_in=0,

@wmi_namespace=N'\\.\root\cimv2',

@wmi_query=N'SELECT * FROM __InstanceCreationEvent...

Hi

This doesnt work 🙁

It says Server '1.1.1.1' is not configured for RPC.

My real senario is to when ever there is an insert in audit table , and based upon these values ie the amount field (5,10,20), I need to insert a...

Hi

I have to call the stored procedures and i have to populate it on a temp table and my stored procedure will access the temp table

can any one...

Hi

Thanks for your reply

I am not familiar with Inline functions.

I have to run the stored procedures when ever the data gets inserted on audit table.

Regards