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

    Getting returns from two SQL tables

    I have two SQL tables that hold zipcode info. One is for US and one is for Canada. I am working on a stored procedure that has a parameter @city, and then returns the City, State, and Zip from each table WHERE (City = @city). I can get it working for one table or the other, but not both...
  2. Bene1

    Assigning Boolean based on return value

    I am trying to assign a value to a variable based on the results of a view. For example, if the value of a column comes back as NULL then I want my variable to equal 0. If the column returns something other than NULL, then I want the variable to be assigned a 1. Is this even possible within...
  3. Bene1

    Problem with a JOIN statement (I believe)

    I have been working on this for a while now, and I am getting very frustrated. Hopefully someone out there will be able to help... I have two tables that I am linking together. I need to see all records out of the table 'GROUPS' and in another filed I need to see 'USER_NAME' from...

Part and Inventory Search

Back
Top