Hey Me too..

This site

http://msdn2.microsoft.com/en-us/library/ms178134.aspx

says that A CLR Trigger can be either an AFTER or INSTEAD OF trigger. A CLR trigger can also be a DDL trigger.

So......

Or May be you can put the values into temp variables and copy them into the temp table. This would also work

Hey All,

It was quiet easy at my side as I use Vista.. I used the same method...

Hey All,

Thanks for all of the suggestions. I could not remove the permissions to the user as he seems to...

the trigger is like

create trigger u_authors on authors for update

as

Insert into log_authors (au_id) select au_id from inserted

go

I have tried this out. Hope it helps you out... But this shud atleast giv u an idea how u can proceed...

SELECT f.TankObjectID,

  f.ForecastDate,

  f.ForecastValue,

 Case

  when ml.MeasurementLogValue IS NOT...

Hi,

Sorry for troubling you. But please be clear of which Cal1 and Cal2 that you want to calculate and add and subtract... You had mentioned take 200 from the caluculated...

If I have slightly understood your problem then I feel you can try the following..

SELECT f.TankObjectID,

 f.ForecastDate,

 f.ForecastValue,

Case

 when ml.MeasurementLogValue IS NULL then <Update with the value you need>

 Else <perform the required...

Thanks..

Hi,

In SQL it is always that when you convert NULL to any of your preferred datatypes, it will be NULL again. It depends on we using intelligence to overcome that....

Hi,

This is really unfair to have it working with Business and Enterprise editions only. if it were all of Vista editions it would have been nice!!

When is the full version of SQL 2008 getting released??? And it doesn't work in all Vista editions!!

Select SUSER_SNAME() AS SECUREUSERNAME, SUSER_SID() AS SECUREUSERID, HOST_NAME() AS HOSTNAME, HOST_ID() AS HOSTID,

DB_ID() AS DBID, DB_NAME() AS DBNAME... Try this if you are using SQL2k. May be it works in...

Hi, I use this in the front end

Set f_objLabCenter = CreateObject("BO_LabCentre.ClsLaboratory", g_strCOMRepository)

    l_iStatus = f_objLabCenter.FetchResultInv(g_strConnection, g_strUserId, f_sPatID, f_sOtherInv, f_sErrMsg)

and this in the Business objects where i pass the inputs...