Viewing 15 posts - 1 through 15 (of 18 total)
I am sorry. I googled this issue and got the forum--did not check the date and asked the question. I guess I will have to try to do...
April 30, 2012 at 7:45 am
Can you explain what exactly you did when you say
' a quick deletion and a quick disc repair and all is well '
April 23, 2012 at 1:55 pm
I am reading this article:
Eliminating Duplicate Rows using The PARTITION BY clause
By Suresh Maganti, 2010/09/22
whihc is useful and will help me figure this out.
Thank you for all you help.
February 22, 2012 at 12:10 pm
Yes, you are correct. I am trying to figure this thing out as I am getting the error-'The ranking function "ROW_NUMBER" must have an ORDER BY clause'
February 22, 2012 at 11:33 am
Yes, there is a field named DTS which has the date time stamp.
February 21, 2012 at 2:39 pm
I am trying to delete all the duplicates. The duplicates are obtained using the query I listed earlier. The primary key for this table is PID and SQ...
February 21, 2012 at 2:31 pm
Thank you for pointing out the forum etiquitte to me. I will keep that in mind from now on.
This is my problem.
I have a table that contains...
February 21, 2012 at 2:15 pm
Only problem this is a table taht has all the student transcripts. There are several records for one ID. There are duplciates only when I inlucde all those...
February 17, 2012 at 6:01 pm
delete from
tableA
where pid not in
( select pid, CN, mk, te, yr, st, cr, cc from
...
February 17, 2012 at 5:25 pm
This seems to be nice. However, I ahve a question. I am trying to get SQL to create a tab delimited text file but I keep getting a...
April 26, 2011 at 5:38 pm
I noticed if I use the stored procedure I have to map the suers one at a time. Even the statement
exec sp_change_users_login 'Auto_fix' needs parameters to be specified :w00t:...
June 11, 2010 at 2:29 pm
Perry,
Do I run this stored proc in SQL 2008? Also do I use the migration wizard to bring all the mapping of the roles to the users and grant...
June 11, 2010 at 10:39 am
I am migrating from SQL Server 2000 to 2008. I used the Copy Database Wizard and copied the database over to the new server. We are doing side-by-side...
June 10, 2010 at 3:13 pm
I tried to use the Copy Database Wizard to try and copy one database from SQL 2000 to SQL 2008 as part of migrating the database. I had some...
May 25, 2010 at 3:26 pm
Now, does the sa account for SQL server 2000 and SQL server 2008 have the same password--I have them set up with different passwords?
May 14, 2010 at 8:30 am
Viewing 15 posts - 1 through 15 (of 18 total)