Hi There,

Ye i did not read your reply, only after i posted i have yours. But cool stuff, at least he got his answer.

Regards,

TRY THE FOLLOWING:

Select I.ItemCode, I.ItemDesc, ID.ItemQty, ID.ItemUnitCost, SUM(ID.ItemQty x ID.ItemUnitCost) AS LineTotal

FROM Item I

LEFT JOIN ItemDet ID ON ID.ItemCode = I.ItemCode

GROUP BY I.ItemCode, I.ItemDesc, ID.ItemQty, ID.ItemUnitCost

Hi,

When executing the powershell script for Write-DbSpaceToDb.ps1 i get the following error :

PS SQLSERVER:\SQL\JHB-BARTUSD\DEFAULT> param($destServer, $destdb)

The term 'param' is not recognized as a cmdlet, function, operable program, or

script file. Verify...

Hi Guys,

What worked for me. Right click the sql server agent and look at the following tabs; general and connection. The general tab contains the information for starting up the...