Viewing 15 posts - 256 through 270 (of 621 total)
Gail, it may be a little late now, but for what it's worth, I was unable to install 2000 standard on both a desktop and a laptop running XP pro....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 16, 2009 at 2:21 pm
bitbucket-25253 (12/9/2009)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 11, 2009 at 1:41 pm
dzirkelb, sorry, flu. I'll try to mess with it this week, but in the mean time, I would do what Jeff said if I were you.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 27, 2009 at 4:52 pm
Could you post the target table structure, and mabye the first 100 or so lines of the data file as an attachment?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 22, 2009 at 8:20 am
dzirkelb (10/7/2009)
When I run it as SQLINT, I get no erros; however, I get bad data. Example:What should be data of 1, results on the import of 153104672.
Any ideas?
Hmmm...not...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 21, 2009 at 8:06 pm
rahulsony111 (10/16/2009)
Even i dont know about my goal here exactly. I am very much confused.
I'm not trying to barge in here or anything, but I started reading this thread, and...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2009 at 3:48 pm
dzirkelb, your format file is set up to insert column 1 of the source file into column 1 of the destination table, column 2 of the source file into column...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2009 at 3:31 pm
That's a lot of lines with no sample data. My first suggestion would be to read this...http://www.sqlservercentral.com/articles/Best+Practices/61537/...then post some sample data. It would be easier to help if...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2009 at 10:17 pm
Yep, there are many days that I long to be back up in the bucket, splicing copper.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2009 at 12:22 pm
Thank you George, that worked.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 14, 2009 at 12:45 pm
The output is just what you asked for, which is if (SELECT * FROM #t2) exists. It does exist, so without any further WHERE criteria, everything from #t1 will...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 1, 2009 at 1:59 pm
GSquared (9/29/2009)
The first thing I'd do with this would be to switch to ANSI style joins
I got into a bad habit of using commas for joins, until I realized what...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 29, 2009 at 3:43 pm
Look up UNION in BOL.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 29, 2009 at 3:37 pm
Thanks again Seth, for your insight. Error handling...I've got a new toy to play with now. I never looked at master..sysmessages. They ought to put one in...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 22, 2009 at 3:22 pm
Christopher, first off, this is a SQL Server site, not Access. I would suggest you try http://www.accessmonster.com. Now, the first problem I see is this....
christopherk (9/22/2009)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 22, 2009 at 1:24 pm
Viewing 15 posts - 256 through 270 (of 621 total)