Viewing 15 posts - 13,006 through 13,020 (of 18,923 total)
Now that's another problem
.
I'll have to add this possibility when I remake my dts version of this script.
HTH.
September 21, 2005 at 12:28 pm
Yes but the designer doesn't support it... so I usually build the bulk of the query there, then go back to QA and finish there.
September 21, 2005 at 12:07 pm
What part are you not getting??
September 21, 2005 at 12:06 pm
Works fine as long as you don't have 50 columns and 1M rows.
My version does a single pass per table, and all tables.
And as I said, it would be better...
September 21, 2005 at 12:05 pm
If you just need the final insert to work for now. I'd rebuild it from scratch. It think it would less of a headache.
Also in sqlserver, views are...
September 21, 2005 at 12:00 pm
My bad, did test on an old db that I don't know very well.. I assumed some nulls were caused by a lack of usefull data.
Here's a better version :...
September 21, 2005 at 11:49 am
Glad to hear it can't be that... but that doesn't help much in telling what did happen
.
September 21, 2005 at 11:43 am
You can't (read shouldn't) do that. Move that select into a view or a inline table function if you need parameters. Then you'll be able to do the...
September 21, 2005 at 11:41 am
I'd go further... It would be in your best interest to stop using EM manager for a few days/week just to see all you can do in QA (assuming your...
September 21, 2005 at 11:39 am
This corrects the problem server side. Access also caches metadata when it opens. So another part of the solution would be to go to the database window of...
September 21, 2005 at 11:35 am
Please do not cross-post, we monitor all boards.
Finish the thread here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=222242
September 21, 2005 at 11:33 am
Why not just add an identity column to the table??
September 21, 2005 at 11:32 am
In case anyone's wondering >> (a/b.0) * 100
September 21, 2005 at 11:31 am
This one only checks for the length of [n]chars and [n]varchars columns, prints the list of voided tables. This can be usefull if you only want to see the...
September 21, 2005 at 11:25 am
Viewing 15 posts - 13,006 through 13,020 (of 18,923 total)