Here on the forum this is seldomly discussed. You have better luck searching the Google Archive, maybe along with the name Steve Kass. Actually I picked this example from a...

Okay, okay, I'll do it right......

Hmpfh, php is quite different than VB. Should remember the MS way. So I guess quite a few questions to come very soon. 

Damn, I know this one, but have forgotten. However I should have also mentioned, that this app is used by at most 3 persons (not simultaneously) on two days a week. so,...

Read http://www.sommarskog.se/dynamic_sql.html and decide if that's the way for you to go. Erland has there a chapter on "dynamic cursors".

But I'm with Kenneth, each of both things isn't...

Thanks AJ,

that's also my understanding. I've commented the public declarations and now the code is breaking over and over. Aah, I really love cleaning up someone else's crap

Yes, that's right. Sorry, for this little bit bad copy and paste mistake. It's kind of a relikt, while I played with this example and tried to figure out a...

Please avoid multi cross posting!

That makes it very difficult to track who did answer what in which thread.

Where should we continue now? Here or there

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=150560

Don't suppose you could do a simple example?

I could, but Nic has done so already.

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.languages.csharp&cat=en_US_8927d559-4589-4144-af52-c018928e8b9b&lang=en&cr=US might be a place to go for c#

On a sidenote:

MONEY can be tricky, when you do calculations other than addition and subtraction. Consider this example:

declare @m1 money, @m2 money, @m3 money

declare @d1 decimal(19,4), @d2 decimal(19,4), @d3 decimal(19,4)

set @m1...

Put your stuff in a stored procedure which shouldn't be too difficult at all. Create then a job and schedule it for your needs.

And, btw, you should really use the...

IIRC there were memory problems with these sp_OA* procedures, but that should have ben fixed. I think, to say you're on the right track or completely off, it would help...

No, it doesn't affect all identity columns. Actually only one table at a time in a session can be  used with SET IDENTITY_INSERT, otherwise an error message is raised.

Once I do get it up & running would you be willing to link your site to it?

Sure, if the content is as good as your answers here and on...

SELECT IDENT_CURRENT()+IDENT_INCR() will return the next one. Still I wouldn't do it.