Just use CONVERT(VARCHAR, PartsDueBy, 101) for the mm/dd/yyyy format.

You can check the BOL for other formats.

I can think of two ways, but I am not sure about the details.

1. Launch a command prompt (execute process task) and add the parameters when calling the application as...

Some ideas...

Do you have automatic growing of your DB's enabled? Maybe at the 1GB point, SQL Server starts to grow your database (or logs).

A second possible cause are the indexes....

Not sure what you exactly want. There are a lot of threads around here to build some kind of search engine.

If your problem is linking the advertiser to the category,...

I like Andy's solution. You could even have packages containing other packages.

As for the separation between business logic and database implementation, you could solve it using the isPackage bit you...

Very good solution, certainly adds the check for other inserts that are not performed through DTS.

But, if the number of records through DTS is large, performance will suffer. Maybe a...

And now, let's have a go at the 'remove duplicates' problem from Clive.

DELETE FROM picktable WHERE rowid NOT IN

(SELECT max(p.rowid) FROM picktable p GROUP BY --(whatever identifies one order uniquely)--)

This...

A try for the first problem.

SELECT t.Name, t1.Location as Location1, t2.Location as Location2

FROM (Select name from table group by name) t

left outer join table t1 on t.name = t1.name...

How about adding the column (at the end), renaming the table and constructing a view with the correct name AND the correct column order?

I like the 'solved it' post. Just to let other people in on your secret.

Just thinking about a solution for the problems I mentioned.

You could insert...

Just add this to the where clause. That should do the trick.

b.duedate <= a.dueDate

Two problems might arise.

1. The records are not sorted on duedate (is the total independent from...

I don't actually agree with putting the insert in the application code. At least not if the only reason for it is the lack of a stored query plan.

If you...

Provided that the 'Replace' stuff works correctly, you can write this as

UPDATE contsupp

SET LINKEDDOC = replace(CAST(LINKEDDOC AS varchar(200)), '~~FILENAME=%', ''~~FILENAME='+address1 + address2')

WHERE address1 like "\\bssql1\bssql1data\goldmine\MailBox\Att%"

and linkeddoc like "%FILENAME=\\bssql1\bssql1data\goldmine\MailBox\Attach\%"

The proposed methods work without any problem. Either using a second table for setting the relations, or adding the 'supervisor_id' to the personnel table.

However, there is no easy way to...

What kind of authentication mode are you running? SQL Server or Windows?

In the latter case, the login trying to connect, is the one the application is running in. So it...