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 TouchToneTommy 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: worldpeace
  • Content: Threads
  • Order by date
  1. worldpeace

    Is it possible to convert a number (week number) back to date range?

    The sql statement below return a week number (10) select datename(week, '03/12/02') as number Now is it possible to do the opposite, like I have a week number 10 then the statement(s) would return a date range from 03/03/02 to 03/09/02. Appreciate your helps.
  2. worldpeace

    How can I join two tables from two different Servers

    Hello everyone. I am trying to do a SELECT statement joining two tables from two different SQL Servers that have different authentication. Is it possible? Do I make any sense? Please help, THANKS
  3. worldpeace

    What SQL 7.0 statements allows me to do ranking

    I have a table with these fields: Deptcode ID QTY Rank -------- --- ---- ---- 10 11 150 NULL 10 12 270 NULL 10 10 75 NULL 10 14 175...

Part and Inventory Search

Back
Top