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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bprego

  1. bprego

    what is the problem?

    I keep getting this error when i try to execute a sp from my asp page. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. I can run the stored procedure in...
  2. bprego

    can you help me with this query??

    It works great. sunila7 thank you so much for your help and hneal98 you too. You just saved me from having to work through the weekend on this project. THANKS
  3. bprego

    can you help me with this query??

    Incorrect syntax near the keyword 'group'.
  4. bprego

    can you help me with this query??

    thanks for your help but I am getting a syntax error by the second group by that i cant figure out. any idea why? I will play with your idea for a while longer to see if i can make it work for me.
  5. bprego

    can you help me with this query??

    the union duplicates the Level2ID and Level2Name and I can't use the query this way. can any one help me out, PLEASE? the code is posted below. SELECT distinct Level2ID, Level2Name, count(Level3Name)as TOTAL_SUBS, '' as TOTAL_COMPANIES FROM tbl_Prod_Categories WHERE level2name in (Select...
  6. bprego

    I need to write this query with out the union

    the union duplicates the Level2ID and Level2Name and I can't use the query this way. can any one help me out, PLEASE? the code is posted below. SELECT distinct Level2ID, Level2Name, count(Level3Name)as TOTAL_SUBS, '' as TOTAL_COMPANIES FROM tbl_Prod_Categories WHERE level2name in (Select...
  7. bprego

    SELECT @StoredProc, NextField1, NextField2 FROM ....

    So if I understand you, The stored procedure runs and returns a value that you want to use in a select into statement?? have you tried something like 'call the procedure EXEC MyNewID @TableName = 'Account' 'then use the return value in the select or insert into where 'Account' is the return...
See more

Part and Inventory Search

Back
Top