Viewing 15 posts - 1 through 15 (of 23 total)
Pretty sure there won't be a problem with violations because the database in the new location hasn't been modified since it was migrated.
Possibly dumb questions here: I import the...
August 28, 2014 at 10:00 am
I've got a few things that have slipped through the cracks (for whatever reason), but it looks like a manageable number. Thanks again for all the help!
December 7, 2012 at 3:09 pm
I've definitely backed up the database before trying this, but it looks like it works!!!!!!!!!
I should be able to fiddle with the code to take care of the rest of...
December 7, 2012 at 2:09 pm
So I ran the test code and it worked. I'm guessing my next step is to try it on a section of the real table, but I had a...
December 7, 2012 at 1:45 pm
These are the duplicates that need to be deleted for this site:
SELECT '154304W','3','2009','Diospyros virginiana','A','1','Aug 10 2009 10:06AM','1260'UNION ALL
SELECT '154304W','3','2009','Celtis occidentalis','C','1','Aug 10 2009 10:07AM','1261'UNION ALL
SELECT '154304W','3','2009','Ailanthus altissima','B','1','Aug 10 2009 10:08AM','1262'UNION ALL
SELECT...
December 7, 2012 at 12:55 pm
It looks like there are 38 rows of data in the table, but there should only be 19. Rows with sort_id's from 1136 to 1154 are one group and...
December 7, 2012 at 12:27 pm
It's my fault for using confusing syntax. I had a way of dealing with the duplicates in Access, but the presence of records with identical data entry dates was...
December 7, 2012 at 11:55 am
Tried running the code in your link (I just copied the code and pasted it) for practice before using my own data, got the following error messages:
Msg 156, Level 15,...
December 7, 2012 at 10:48 am
Here's the CREATE TABLE script for the full table, the consumable data is below. I had to exclude some of the variables due to length restrictions for QUOTENAME (if...
December 7, 2012 at 10:09 am
Yeah, that's what I was afraid of. I'm completely hosed because the data in the data entry database is usually deleted after it's merged into the master database. ...
December 6, 2012 at 2:12 pm
Thanks for the reply! Each record has a datetime stamp, but for some reason they're not consistent, meaning that some duplicated records have the same datetime stamp, but some non-duplicated...
December 6, 2012 at 11:34 am
So tulip is your SQL Server server and your domain controller? If tulip is not a domain controller, then the users and groups setup on it (tulip\CTAP_Professionals) only...
December 5, 2012 at 11:31 am
We're using Windows authentication and I've tried all sorts of permutations for setting up an ODBC connection. In management studio there is a user listed (with permissions to our...
December 5, 2012 at 9:00 am
The first part of your reply doesn't hold because all of the users I've tried to connect are part of the CTAP_Professionals group on the server.
How would I go about...
December 4, 2012 at 11:04 am
I should add (don't know if this is relevant), but the Access database is on one server (Panda), but the server that I use to access the SQL Server tables...
August 28, 2012 at 2:57 pm
Viewing 15 posts - 1 through 15 (of 23 total)