Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rrchowdhary

    How to create seperate XSD files for each class to send with WSDL

    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"...
  2. rrchowdhary

    How to Parse XML in to tree structure

    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
  3. rrchowdhary

    Case in Where clause

    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, ','))...
  4. rrchowdhary

    Group by Rows in to columns

    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...
  5. rrchowdhary

    Query to return count using group by?

    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...
  6. rrchowdhary

    Help writing the stored procedure to get the following output?

    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...

Part and Inventory Search

Back
Top