Viewing 12 posts - 61 through 72 (of 72 total)
Thanx Friend
but i have 200 to 300 tables in my db... i have to apply search for all tables like i descriged above .... i think its not good practise...
May 22, 2009 at 11:20 pm
Thanx ramesh..... How do Increase my Coding technique in Sql Server in an effective way...Could u plz help me...
May 12, 2009 at 2:23 am
Hi,Ramesh ..... May I know the reason for the Improvance of performance of your Query Over my Query....
I am keen to know ....
May 11, 2009 at 3:28 am
Thanx Ramesh....
But If the data is huge ,Is there any problem Occurs due to batch Insertion in terms of Network Traffic?
May 8, 2009 at 9:16 pm
Use Inner Join between Site and Customer_site tables...
because non ansi join act as inner join
May 1, 2009 at 10:51 pm
select field1 ,field2 ,(case when (rank() over (partition by LEFT(Field1, CHARINDEX('.', Field1, 1)) order by Field2 desc))=1 then 1
else 0 end)
from #TestRank
May 1, 2009 at 10:43 pm
If u use the Sub query its killing the Performance.. So..;-)
April 27, 2009 at 5:10 am
IdParentId
10
21
31
41
54
64
76
86
92
102
1110
1210
this is the structure of tree.... 1st column is Id and second one is parentId
I need result set as 1,4,6,7,8,5,2,10,11,12,9,3
April 27, 2009 at 5:09 am
Viewing 12 posts - 61 through 72 (of 72 total)