Click here to Skip to main content
15,912,493 members

Comments by Firdaus Shaikh (Top 18 by date)

Firdaus Shaikh 28-Apr-16 6:52am View    
So is there any workaround for date and string values!?
Firdaus Shaikh 26-Apr-16 17:09pm View    
One more thing how to use string and datetime values with this method
i.e. if I use Sex column I get
Error converting data type nvarchar to float.
if I use WeighedDate column I Get
Conversion failed when converting date and/or time from character string.
Firdaus Shaikh 26-Apr-16 15:36pm View    
Sorry Don't know how to use code/pre tag in Reply.
Firdaus Shaikh 26-Apr-16 15:35pm View    
Thanks for Your Time and Efforts, Yes it worked Very Well,
I am very pleased with your Dynamic solution.
Just one thing Throwing Error was
<pre>''Child''+rn as Element, ''Child'' + rn as Value '</pre>
I changed it to
<pre>''Child''+rn as Element, Child as Value '</pre>
and it worked like charm!!!

Thank you very much, I also tried Inner Join on Two Tables and It Worked Fine!
Kudos to You.
Firdaus Shaikh 26-Apr-16 15:33pm View    
Deleted
Thanks for Your Time and Efforts, Yes it worked Very Well,
I am very pleased with your Dynamic solution.
Just one thing Throwing Error was
<pre>''Child''+rn as Element, ''Child'' + rn as Value '</pre>
I changed it to
<pre>''Child''+rn as Element, Child as Value '</pre>
and it worked like charm!!!

Thank you very much, I also tried Inner Join on Two Tables and It Worked Fine!
Kudos to You.