Hi

Did you try my example? Just copy to SSMS and execute.

In your SELECT just replace the GETDATE() with your column name.

Greets

Flo

Well I think it's time to join...

Maybe I oversight, but some classics are still missing in my opinion

Lord of the threads

Pulp threadtion

Hell Threader

No problem. Thank you all the same!

Hi Barry

Thanks for your help! I just tried. In contribution center click "Contribute Script" on bottom there is a upload text box it allows only images...

Greets

Flo

I'm not sure if it is possible to add different element names in same level. If it is I don't know. Sorry.

Best wishes

Flo

Hi

This is the...

Hi

If you want to use the database default collation you have to use on the function, not on the ",":

fnx_TitleCase(lastname) COLLATE YOUR_SERVER_COLLATION + ',' + master.dbo.fnx_TitleCase(firstname) COLLATE YOUR_SERVER_COLLATION as FullName

My...

Hi Barry!

Thanks for your reply.

I just tried with code="plain" Firefox needs about two seconds but can handle it. I tried from IE an it...

Hi

You could try:

fnx_TitleCase(lastname) + ',' COLLATE YOUR_SERVER_COLLATION + master.dbo.fnx_TitleCase(firstname) as FullName

Anyway, if your master has another collation than your database it seems that the server does. You should consider to...

I just want to confirm your consideration. I also don't know a reason to commit a transaction if there was an error.

Greets

Flo

Glad that I could help!

Greets

Flo

Hi

No problem 🙂

Thanks for the sample DDL and data!

There are some things I don't understand:

*...

Could you please post the complete error message?

Just want to confirm Gail. In best case the user name and a link to her/his user profile (if the user changed the nick name).

Greets

Flo

Hi

If you want to remove the time part of a DATETIME column you can use this:

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0)

If you have a different problem I join the others...