Hi Micky and Mitesh, thanks for your info

Hi Micky,

I don't need to consider the current month.

Hi Mitesh,

On your sample what is EO month? Is it a function?

Thank you Micky for your reply and hope the where clause has to be like the below

WHERE (cmp.loyaltystartdate >= dateadd(month,-7,getdate()) and cmp.loyaltystartdate < getdate())

or (cli.loyaltystartdate >= dateadd(month,-7,getdate()) and cli.loyaltystartdate <...

Hi Micky,

Thanks for your reply and from your sample query there is no logic to get last 6 moths data. i just gave the sample data. my actual table...

Here is my first try,

This is the query u tried to get the Companyloyalty data. but i am facing how to join with clientLoyalty to get mothly data not available.

one...

attached my screen how does it look like on my screen. please hit the image

Though i hit the cached link still the same message from browser. Will wait to read your article when it's up.

Attached my screen for your reference

I understand that the site is down. any clue when will be up. i would like to read your article.

Hi Gila,

nope. here is the issue am getting.

Oops! Google Chrome could not find sqlinthewild.co.za

Try reloading: sqlinthewild.­co.­za/­index.­php/­2009/­03/­19/­catch-­all-­queries/­

I have 20 mbps internet connection. my internet is working great.

Hi Sean,

I apologize for my mistake that i didn't see your sample code. It's perfect code gives expected result. Thank you so much.Also you posted a Gail's link which is...

Hi Luis,

Here is my try and please suggest me about this.

--DECLARE @val VARCHAR(50) = 'sugar';

DECLARE @val VARCHAR(50) = 'Cooking Waffles';

SELECT DISTINCT

Cooking.*,Cooking_Details.Provider

FROM

Cooking

INNER JOIN

Cooking_Details

ON Cooking.IDCooking = Cooking_Details.IDCooking

INNER JOIN

Cooking_Contents

ON...

Hi Sean and Luis thanks for the reply

Hi Luis,

I am sorry, small mistake i made. i did correct on my first post.

for example if i pass "Cooking Waffles" as...

Hi Luis,

Great learning today for me. Yes i do understand. you are the genius and really i am very thankful to you because i learned some good and important...

yes. you are correct. but how can i join those two individual queries to produce the result. could you please help me

Sure and i didn't tweak the pivot functionality as the data structure i gave is for testing purpose. but the logic will remains same. here is the full code.

use tempdb;

set...

Hi Sean,

It's awesome and thank you so much for your great help. I am able to plot my Pivot. Cheers!!!

Hi Luis,

Thank you so much for your time on this.