Search results for query: *

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

Thanks vongrunt I will try to learn writing sql queries this way..i need to shed more light in writing these type of queries.. Difference type should return Difference between two classes.. ResourceClasses table contains two additional columns which used to hold classid's for...

Hi vongrunt Thanks very much for this query.I have just returned to the work and run the query againest my test data and it just rocks. I just felt like you saved me from the sinking ship when i have seen your solution. still i don't know how you approached the problem but certainly i thought...

Thanks vongrunt I am out of my mind.you are right they should be in the final output too. The reason i have omitted them in the desired output is to make the output simpler to go through.

Thanks vongrunt, That is exactly what i was looking for.What i want the output to contain is the intersection of Resourceclasses 3,6,4,5 so the final output should contain Just one Member which is 1001 so the outcome is 7 - 1001 when i look at the picture you drawn it looks easy to me but...

Hi I have stucked up with writing stored procedure to get the desired output.would appreciate help in from you all i would like to get the intersection,union and set of records based on the Type Here is the data in my table Resourceclasses ------------------- ResourceClassId Name Type...