Hey, Ken,

what is your avatar?

Please avoid cross posts. It's really hard to follow.

So, where should we continue?

Here or here?

I would run a count() on some INFORMATION_SCHEMA stuff.

That's a brilliant mindset

You mean my avatar? I was multiple times in cinema with my elder son. He can almost recite the whole...

Just kidding, but wasn't that the same Jonathan already demonstrated?

In Germany we have a saying that might translate to

"All good things...

Sorry Dave, haven't seen your response asking the same thing.

Give you give some sample data along with the desired result?

Got it finally !!!

WTF doesn't MS products speak the same language ????

Changing

.Parameters.Append .CreateParameter("@issue_date",adDate,adParamInput)

.Parameters.Append .CreateParameter("@maturity", adDate,adParamInput)

to

.Parameters.Append .CreateParameter("@issue_date",adVarChar,adParamInput,12)

.Parameters.Append .CreateParameter("@maturity", adVarChar,adParamInput,12)

did the trick.

Why reinvent the wheel?

I think I have seen on sourceforge.net web based administration tools for SQL Server.

Why not customized so a tool for your needs so that each customer...

Ok, a little bit further now.

With cm

.ActiveConnection = cnn

.commandText = "kapitalanlage_insert"

.CommandType= adCmdStoredProc

.Prepared=True

.Parameters.Append .CreateParameter("@bezeichnung",adVarChar,adParamInput,100)

.Parameters.Append .CreateParameter("@riskID", adInteger, adParamInput)

.Parameters.Append .CreateParameter("@issue_date",adDate,adParamInput)

.Parameters.Append .CreateParameter("@maturity", adDate,adParamInput)

.Parameters.Append .CreateParameter("@coupon", adVarChar, adParamInput,10)

.Parameters.Append .CreateParameter("@bSpezialfonds", adVarChar,adParamInput,1)

.Parameters.Append .CreateParameter("@bManualUpdate", adVarChar,...

Amazing what all can happen while typing. Fortunately I hit F5 before answering

Not to be picky, but what are you trying to do? It isn't very clear (at least to me).

Can you script your table and try via QA?

What front-end do you use?

Please avoid cross posts.

Let's use this thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=105360

That being said, what is your question?