Recent content by rrchowdhary

Hi I am developing a WCF service in .net and would like to give the wsdl file to the customer who can consume our service. I successfully Generated the wsdl which includes the following xsd import statements <xsd:import schemaLocation="https://URL/Service-v1.svc?xsd=xsd1" namespace="Service-v1"...

Hi All Can any one please point me in the right direction to have a class in C# which can parses XML string in to a tree structure without using XML Libraries - both input and output should be in memory Many Thanks RR

Thanks r937 This worked like a charm. What I am trying to do is get all the filters matching perticular @SectionFilter and this is being used in a stored proc.

Hi all I am struggling to get this query right but without any success. Any help would be really helpful here is my query SELECT * FROM tb_filters WHERE Id=@filterId AND CASE @SectionFilter WHEN 'NeedsAndRisks' THEN sq.NeedsAndRisks IN(SELECT item from dbo.fnSplit(@ScoreFilter, ','))...

Hi markros Thanks for your reply, but I am not looking for a group by solution, as I just need to get the data in the following format Country ID Company QuestionID Buildings(300) Machinery(301) AverageStock(302) ThirdParty(303) Mexico E627 Mexico 300...

Hi experts I am struggling to get my query right, as currently I am getting the following output, but what I am trying for is to get all my data in to the single rows. Could any one please shed some light and point me in the right direction. Many Thanks Country ID Company QuestionID...

you are right george, that's why i have used the query you have mentioned earlier, as i had to query the DB for nearly 500000 records..

This is what i have written initially and i am sure i understand your query SELECT Locationid FROM TableB WHERE Locationid in ( SELECT Locationid FROM TableA ) GROUP BY Locationid HAVING count(TableA.documentId) < 5 Thanks

Thanks George.. This works perfectly..

I am having trouble getting the count of records from tableA I need to find the LocationId whose count is < 5 here is the Sample Data TableA ======= LocationId 1 2 3 TableB ======= LocationId DocumentId 1 1000 1 1001 1 1002 1 1003 1 1004 2 1005 2 1006 2 1007 2 1008 2 1009 I...

Thanks vongrunt, What i have done to get Resources for a perticular ResourceclassId is to add where class in the Final select statement. select * from #results where ResourceClassID=@ResourceclasId order by ResourceclassID, ResourceID you are right it is not that efficient to process all the...

Thanks vongrunt This just works great.

Hi vongrunt, I did not quite get the first statement in the while loop(in your query).Can you please give me an idea What exactly it is holding the information.I think the logic lies in that statement. and also i have requested in one of the reply to, is there any way we could modify the query...

umm..unless i get this solution right i can't put my mind to what i am typing. that's right..it's my mistake

Type Difference {1, 2} and {2, 3} should return nothing as the Definition says We should get the Resources which belongs to ClassA but does not belong to classB and also DiffA and DiffB columns belongs to Resourceclass table