That would be the real turn on to buy a product.

I guess it could be done. If you were to re-run each script with alter proc... but I never...

I'd suggest you encapsulate all the logic in a single stored proc where both inserts would be executed and the new identity easily fetched ::

create proc dbo.demo param1 int, param2...

Select CAST(bkn as CHAR(1)) + ',' + CAST(bks AS CHAR(1))...

Why would you want to do that exactly?

HTH.

this assumes that jan 1st and 2nd are holidays and that jan 1st can be a Saturday (NDays.PkNumber between 3 and 5)

SELECT

  MIN(dtDates.Date) AS FirstBusinessDays

FROM   (

  SELECT

   DATEADD(YY, NYears.PkNumber - 1900, NDays.PkNumber...

...and deploy and night time when nobody's on the server.

can you just recreate the date??

MAX (CAST (field1 + field as datetime))

Why not go a different route.

DTS the new records in a temp table on the local server (so you go on the other server only once).

Then insert into debtor ...

>> "he only twists the knife in deeper and laughs while doing so."

This is how it's done in sql server.

Select * from dbo.Employees E inner join (Select EmpID, MAX(Date) AS Date from dbo.Employees) dtMax on E.EmpID = dtMax.EmpID and E.Date = dtMax.Date

Can you post your definition of the first business day of the year??

Would you be trying to invent me a fourth life Sue?? cause I don't have time for time right now .

Redeemed??? I wouldn't be the kind of person to make 2 mistakes in 3 characters, wolud Y?

Alright.

Post the table definition, some sample data and the expected results and we'll help you figure it out.

This shows good potential, however I think the article doesn't relate to the application as it doesn't seem to fix the sysdepends problems in any way. I think the...