it was just a requirement,any way thanks for your suggestion i will handle it in presentation layer.
i know frank but what do you think regarding the performance will the performance decrease by doing this , and i think it require more work in...
Thanks Alot Mohammad Hasan problem is solved.
hi moh_assan i don't have adventure works database i tried in my own practice database , it still add two zeros to the end if it contains 0, but it...
i need select statement to remove trailing zeros from money column after decimal point else keep the column data in same format say there is a column...
hi,i want to diplayfirst the parant and then all it's subsequent children at differentlevel, then second parant and all it's subsequent children ,...
Thanks for providing the salution . another salution is to place the columns inside [].
How can i place Dynamic columns crosstabs which have escape character or ? or % or - in it;s name.. this crosstabs add columns which doesn;t have...
HI Adriaan , ALTHOUGH THERE IS NOT A HUGE DIFFERENCE IN PERFORMANCE BUT IT WAS EASY TO IDENTIFY QUERIES WITH HUGE EXECUTION PLAN MORE EASILY. AND...
Hi, can some one suggest me any alternative salution for improving the execution performance of this query becoze i am using this in a web page and...
<P mce_keep="true">i know the basic of <IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH:...
whether i know and advance query or not incase if you have the answer you have to reply that Adriaan.
hi friends, this query will return the column of a single mention table dbo.e but i need a query like this to return all the columns and it's data...
hi friends on which column we have tu user clustered index and which column we have to use non clustered .it is mention on websites that we have to...
Separate names with a comma.
