No. The issue is...

That depends almost entirely on the nature, structure and format of the file....

There are 586 tables listed in your Excel file. Which are the 30 that you want to move?

I am not sure that I would want to retain the personal Views of expired or departed users. If they have production value they should not have been personally...

I am just saying, I do not see where a Tally table comes in? The query that I already posted works fine without it. And I am not...

OK, first execute this command (you have to edit it for your excluded user names)

Select U.Name as [Owner], U.TYPE_DESC as [OwnerType], S.Name as [SchemaName], O.*

From sys.objects o

...

Well, maybe try this:

SELECT Albums.AlbumID, Albums.AlbumName, Albums.PostedDate, Albums.Views, Resimler.ResimId, Resimler.AlbumID AS Expr1,

...

Hmmm, I can't see it either Sergiy. Unless you mean with Dynamic SQL?

OK, I think I see part of the problem: I misunderstood the role of the second column: you just want to eliminate all duplicates.

Easy enough:

Select Distinct *

Into #TempFATHAR

...

yaman bas (8/28/2008)

---

no it's working wrong,

Delete From FATHAR

Where EXISTS( Select * from FATHAR T2

Where FATHAR.FATHARREFNO = T2.FATHARREFNO

...

You want it to look like this:

UPDATE @mytable

SET

Field1 = CASE Field1 WHEN 'Jim' THEN 'Dave' WHEN 'Dave' THEN 'Jim' ELSE...

Vika (8/28/2008)

---

I thought that db and logs are just files. When files are deleted they go to the Recycle Bin. Maybe it's a crazy idea, but would it be possible...

Glad we could help.

@@TRANCOUNT will tell you if you have an open transaction (and how many).

Ok, my bad. Here is the corrected version for SQL 2000:

Delete From YourTable

Where EXISTS( Select * from YourTable T2

Where...