Hi Adi, thanks for your reply, sample and appreciate your time on this post.

Hi Jeff,

Thanks for your reply

So from your statement it's not good to use the function which i...

Hi Adi,

Thanks for your reply and sample. I just gave the sample data. Here is the table structure which i will import the query output to the table.

Create table DataFiles(IdData...

Awesome. We reached the exact output. Thank you so much and appreciate your great effort and help.

Thank you Gentleman.

My next try

SELECT @sql = N'

SELECT Name' +

(

SELECT ', [' + d + ']=MAX(CASE WHEN Date_Of_Day=''' + d +''' THEN Records ELSE (a.GrocessaryStoreDelay...

Hi Dwain,

Thanks for your reply. I am sorry if i didn't explain properly.

if you execute the query you have given, you can see some of the column values are 0....

Hi Dwain,

I tried to change the date logic as dynamic and he is my try

CREATE TABLE #GrocessaryStore

(

IdGrocessaryStore int Primary key

...

Hi dwain,

Thank you so much. I will definitely try and and if i struck up and if i really need your assistance i will drop it here.

Hi Dwain,

Thanks for your reply and i ran your logic. you have built logic just for as per my expected result. But i have gave some test data for executing...

Hi Lynn,

Thanks for your reply and here is the sample data.

Table: GrocessaryStore

IdGrocessaryStore int identity(1,1) Primary key,

Name varchar(50),GrocessaryStoreDelay int, DataFrequency int, StoreID varchar(20)

With GrocessaryStore as (

select 1 as...

Hi Jack,

Thank you Gentle Man. It worked perfectly. I am not aware of i can add AND condition with WHEN Statement. New learning today. Way to go. Great Tip and...

Hi Jeff,

Thank you so much for your time and great tip. I agree with your statement. even i also implemented to have only updated/deleted records on the audit table,...

Hi Jeff,

Thanks for your time. My Regular Table and Audit Table has the same schema other than the identity

TableName: Users

IdUser bigint identity(1,1) primary key

...

Can anyone please suggest me

almost 25 columns i need to track and put it in audit table. any suggestions please

Thank you Micky. I will work with EOMonth. Appreciate your time on this.