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

    Update with lastest

    I'm having a problem trying to update a customer master table with the latest broker to be invoiced. my table structure is: customer master (cm_mstr) cm_nbr cm_name cm_cur_brk AFFAMA0 some customer <blank> invoice table inv_nbr cm_nbr brk_nbr inv_date 1 AFFAMA0...
  2. h0gg1e

    shaky picture when connecting my philips hdtv via dvi to my geforce 52

    I'm not 100% sure on the termonology to use but, I have a geforce 5200 that connects via dvi to my philips 55" hdtv using 1080i display. The problem is that my picture on the tv is shaky. I have the resolution set to 1920 X 1080 with the refreh set at 60mhz. If I drop the resolution down to...
  3. h0gg1e

    problem with a linked server query and different 'sa' passwords

    I have a two sql servers that have been sucessfully linked, using sp_addlinkedserver. The problem is server1 has a blank 'sa' password and server2 has a 'sa' password. When ever I try to run a linked query: SELECT Distinct PONumber, OrderNumber, LoadNumber, CarrierID from tblOrderMasterfile...
  4. h0gg1e

    problem with a linked server query

    I have a two sql servers that have been sucessfully linked, using sp_addlinkedserver. The problem is server1 has a blank 'sa' password and server2 has a 'sa' password. When ever I try to run a linked query: SELECT Distinct PONumber, OrderNumber, LoadNumber, CarrierID from tblOrderMasterfile...
  5. h0gg1e

    check constraint sql syntax help

    I'm trying to create a simple check contraint in access without going into access's table designer. basically in sql server 2000 I would do this .... CREATE TABLE tblCHECKtest ( item_code char(4) CONSTRAINT CK_tblCHECKtest CHECK (item_code = '0000') ) how can I do the above in access via a...
  6. h0gg1e

    finding number sequence gap problem

    I'm having a difficult time figuring out how I can find out the first gap in a numeric col. I tried the faq and I just can't get it to work with my data. I have a table set up like this schedID (bigint id), lineID (varchar), schedStatus (varchar), prodSeq (int) I need to find the first gap...

Part and Inventory Search

Back
Top