This is how I got it working.

need 2 variables @X as Xml &@WebSiteXmlData as varchar(max)

@X will give you the xml output & @WebSiteXmlData will give the varchar output.

We need...

Hi

Thanks for your suggestions. Ghirag I can't use the function because the stored procedure which I need to call already exists.

With Hari's reply I could able to solve my...

Hi

Even I am struggling with how to do the validation of the parameters before it could hit the stored procedure. But had no success till now.

if...

Thank you guys. I guess I will change my stored proc as suggested.

Thanks....This is what I was looking for. Results are perfect.

Thanks also for making me understand the process.

Yes I Checked & I did little manipulation accordingly. but the main approach was as you guided to join the views

Thank you, this is what I was looking for.

I cant do that. those views are really big & i just need only one column from that view.

Ex: view1 -

Date columnView1

----------------------

1/1/08 ...