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 bkrike 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: *

  • Users: astromenix
  • Content: Threads
  • Order by date
  1. astromenix

    Place "XML" Inside a Varchar Using FORXML

    Hi everyone I got a stored proc that is getting pretty big, and at this point I got some repeated functionality, which sounds like I need to create a UDF or a stored proc and call it from my main proc. Wot I want to achieve is pass to the function two sets of periods For exaple: FROM...
  2. astromenix

    table variables in stored procs

    hello, I m in the situation that I got to calculate room prices for given periods and depending on their occupancy generate different prices and then apply discounts on each day. So I need at some point, when i get data of different tables to loop through each date from check_in and check_out...
  3. astromenix

    database design - keep dublicate data in seperate tables

    Hello everyone My situation is that I m workin on this project that is about a travel management system. Now at the administration part, we have set up the tables n screens to collect the data for the types of rooms, periods, their discounts, and the rates that will b bought n sold. One of the...
  4. astromenix

    XmlElement to string...how to?

    Hello, I ve got a web service that accepts XmlElement as an input parameter. Then within my web method i would like to convert it to sting and then pass the string to my the stored procedure and use OPENXML to insert the values to SQL Server. [WebMethod] public string...

Part and Inventory Search

Back
Top