Good to know for the future and hopefully I don't need to do that conversion stuff no more.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Ähem, I'm a little bit confused.

I thought the original question was how to select all those first name that do not start with an upper letter, or?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, but what exactly is your question?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

It's been a while since I done that conversion, therefore I'm not 100% sure, but I think something like this would work

DROP TABLE myName

GO

CREATE TABLE myName(

myn...

If you want again a starting value of 1, take a look at BOL for DBCC CHECKIDENT.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

good question

Frank

http://www.insidesql.de

http://www.familienzirkus.de

AFAIK there is no way using T-SQL.

This might be interesting http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12631

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Why???

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Frank seems to hate triggers I wonder why?

---

Not correct!

I only have no need for...

Although my company pays the subscription it is good entrepreneurial thinking to question any cost. And I doubt that I will renew subscription.

Maybe I missed this information but are...

One way could be

SELECT 

CONVERT(CHAR(10),MsgDatereceived,104) FROM mails_header

GROUP BY 

CONVERT(CHAR(10),MsgDatereceived,104) 

ORDER BY 

CONVERT(CHAR(10),MsgDatereceived,104)  DESC

I know M$ advocates using CAST, but this leaves you with less alternatives...

If you need to check which event caused the trigger to fire, I would write three different triggers. For me this way the code became more manageable.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, can't help you with an example, because I don't use triggers anymore, but there is an OBJECTPROPERTY 'ExecIsTriggerDisabled'.

It returns 1 when trigger is disabled, 0 when trigger is not...

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17434

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, Erik is right, this might be a good start http://www.sqlservercentral.com/columnists/bkelley/normalization.asp .

And, yes, there are more appropriate forum categories like T SQL or General (works always

But...