Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andru
Starting Member
10 Posts |
 Posted - 2005-06-30 : 17:46:37
|
| I am using Access VBA to work on my SQL Server 2000 database.I want to create a complicated piece of SQL code to create a large and complex table. I need to create a table as if when I designed a query I run into the maximum 256 queries error.So I wrote some code to generate a stored procedure, that repeatedly inserted records in a table. And again I ran into a problem this time, my SQL string to create a stored procedure was 180000 characters long and the maximum possible length of a SQL string using DoCmd.RunSQL is 32000 characters.This time I decided to create the table and then run chunks of SQL less than 32000 characters at a time, unfortunately again this didn't work and all that happened was a empty table was created. I guess the reason being that the Access RunCmd.RunSQL method counldn't handle inserting records with such a long and complicated SELECT.So I tried a new tack and this time, I created a table. Then a stored procedure using DoCmd.RunSQL and I called the stored procedure which inserted my records and did this repeatedly. It worked BUT I had the hassle of having to sit and repeatedly click OK to the message "The stored procedure executed successfully but did not return records".Surely there must be a better way?Yours in hope,Andru |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-30 : 19:46:49
|
| Please do not crosspost:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51837 |
 |
|
|
|
|
|
Creating a complicated query