If you need to update existing records and insert new records you need to program a kind of MERGE command. Several samples can be found on this site.

Here's a very...

dcarpenter (10/7/2008)

---

select u.username +' '+u.surname,sum(total_boarded), sum(placementfee), count(p.placementid) from targets t

join users u on u.userid = t.userid

left join placementconsultants pc on pc.userid = u.userid

join placements p on p.placementid = pc.placementid

group by...

jpim3nt3l (10/7/2008)

---

1. Are there other ways wherein I could do the export / import more easily?

2. What's the best delimiter to use when exporting data?

3. What's the best way to...

Storing photo's in your database will certainly increase the database size. This will have impact on your backups and recovery. But this option will give you enhancements about integrity, because...

If the login is originated from your computer and the error is captured every 5 minutes, it could be a scheduled task.

Else I suggest to look with task-manager on your...

Looks like the SQL Engine tries to open the file 'D:\Master_Files\Model_Data', but it doesn't exist. Copy your msdb.mdf file to this location (and...

The time-difference between the two computers are to large. See if the answer on these two websites give you the solution:

http://support.microsoft.com/kb/297234

http://suppot.moonpoint.com/os/windows/domain/clocks-skewed.html

I thought putting the integer value 500000 into a varchar(5) would result in a string with value '50000' (removed last 0). Now I learned it's resulting in a string with...

You can try to periodically run a job that checks if a new database is added. If so, grant users the permissions to that database (using dynamic SQL?).

You need a network-service account when the service needs to read from or write to a network location. When this is not required you can use a local account.

Did it ever run correct? If so, what has changed?

Under what service-account is the service running? Try using the same account as the SQL Server Engine Service.

Matt Miller (9/26/2008)

---

Actually - no. A row is only updated once in each operation, so if a join might yield the same left rowmultiple times, the row is updated...

If you mean a 'Carriage Return' by CR then look at the "char" function: char(10) = linefeed, char(13) = carriage return.

Replace the '~~' with the technique Lowell showed in a...

It's easier to add filters to your reports to only use data before {today}-00:00hr.

Even when you start a job at exact 24:00hr it can take some time before the action...

try this:

SELECT *

FROM [Option]

LEFT OUTER JOIN

(SELECT VehicleOption.OptionID, VehicleOption.VehicleOptionID, VehicleOption.VehicleID, VehicleInfo

FROM VehicleOption

LEFT OUTER JOIN Vehicle ON VehicleOption.VehicleID = Vehicle.VehicelID

WHERE VehicleInfo = 'TOYOTA' --...