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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- bprego
- Thread
- Replies: 2
- Forum: -Web site designers
-
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- bprego
- Post #8
- Forum: Microsoft SQL Server: Programming
-
can you help me with this query??
Incorrect syntax near the keyword 'group'.- bprego
- Post #5
- Forum: Microsoft SQL Server: Programming
-
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.- bprego
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- bprego
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
-
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... -
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...
