sorry it is not clear to me,

Are you trying to load data from a file?

or load some random test data into your table?

Backups on another server i can understand.

But you would want to have your transaction logs as close to your database as possible.

I would agree with the comment about NOLOCK,

only use this if you are absolutely sure what you are doing esp in a production db.

Have a look at your code...

I have seen the same thing, developers are good at what they know but some of them design databases that are completly un-scalabe and un-normalised, they grind to...

are the other fields unique for the ReviewIds?

could you post some sample data?

but you are selecting a lot of other fields

SELECT DISTINCT Top 5 [ReviewID],[ReviewType],[ReviewTypeName],[LoginID],[LoginForename],[LoginSurname],[Approved],[ReviewDate]

...

apparently you can't do a distinct select on a text field.

try casting them as varchar(max)

select distinct cast(FieldName as varchar(max))

Sorry misread the sql, ignore me 🙂

You can't do a group by on a text field.

GSquared (6/24/2008)

---

I don't think a batch file can do that. I could be wrong, but del doesn't seem to have a property that will read file date, just name...

There are some really useful examples of Batch files on this site;

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv.html

They should have what you are after or something close that you can modify.

As this is a SQL forum,...

I use

Microsoft® Visual C#® 2005 Step by Step

Is really useful if you have experience in another language and want to get a good understanding of C#

http://www.amazon.co.uk/Microsoft-Visual-C-2005-Step/dp/0735621292/ref=sr_1_1?ie=UTF8&s=books&qid=1214315454&sr=8-1

I have used this one

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

http://www.amazon.co.uk/Microsoft-Server-2005-Analysis-Services/dp/0735621993/ref=sr_1_1?ie=UTF8&s=books&qid=1214235403&sr=8-1

it is a very good book for learning SSAS from scratch..

Just say NO.

you wouldn't expect the sys admin to give everyone full access to the AD.

Security is a big advantage of saving it as a field in the database, you can control access to the image using sql server security.