Depending on which string data type you use, have a look here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=153641

Doh, I thought he was after dynamically switching db context...

You need to use sp_executeSQL with an output parameter @ApplicID in order to reuse it after the dynamic stuff has finished. EXEC won't give you that functionality. So, something along...

Not only this, but AFAIK you can use the IDENTITY function only in conjunction with SELECT INTO. And SELECT INTO used in a proc will cause a recompile which might...

I might be wrong, but I think you're after this

USE NORTHWIND

SELECT

 OD1.UnitPrice

FROM

 [Order Details] AS OD1

INNER JOIN

 [Order Details] AS OD2

ON

 OD1.UnitPrice <= OD2.UnitPrice

GROUP BY

 OD1.UnitPrice

HAVING COUNT(DISTINCT OD2.UnitPrice) = 2

UnitPrice            ...

(or should I say "finger spitsen gefuhl for you?).

Hehe, sounds good. I like your country and its emphasize of the social and family component. Something we can learn very much...

http://www.databasedesign-resource.com/

http://www.datamodel.org/

http://www.inconcept.com/JCM/

Now this is almost a FAQ here and in all other communities.

I like the idea of narrowing down the certification to specific areas, but then again, how will you...

I would be lying if I say I have a clue what's going on here. I would carefully watch this issue, watch the...

I've downloaded the code and drop you a private mail when I had a look at it. In the meantime, like Phill said, there are many places you can add...

Even the idea that I want to scare anyone off this board is pathetically hilarious! I'm not even going to comment on this thought :

If...

While there is many truth in here, it takes a technically skilled person to judge the answers, methinks. You cannot see inside a...

And changes to the table or the app recently?

Stupid question, but you have verified that it is still DECIMAL(9,2) and nothing else?

What will this be used for? Do you need to store such data in your tables or is this for presentation purposes? Keep in mind that you sooner or later...

Aargh, okay, I was a little bit imprecise. I had the example in mind that you can find under IDENT_CURRENT.

Btw, what is IDENT_INDENT?