I'd let the UI do the formatting. In the case of a system that I am currently involved in developing that includes international phone numbers you could include a...

Have you verified that the email address you provided is correct? The error message says that the user doesn't exist.

I know that I have sent email from an alert...

You can do this in an INSTEAD OF trigger as Matt mentions, but my preference is to use stored procedures for inserts and put this kind of validation in the...

Hey Barry here's the feed I'm using for Lynn's blog and it appears to working:

https://www.sqlservercentral.com/blogs/lynnpettis/rss.aspx

This is incorrect. As Matt already stated, a Default value...

I suggest you start by reading this article.

What about using replication?

Here's a way to do it. The date routines are from this blog post by Lynn Pettis.

SELECT

/*

0 is the first date...

So you want to insure that the rows in the Status table have a valid Message_Identifier from one of the 2 message tables? While not ideal, this situation is...

jsheldon (4/16/2009)

---

Hi Rajib,

I did the following query:

SELECT ISNUMERIC(column_13) from #temp

The column brought back 0 and 1s

Again this column that has budget data. So values like 100, 105, 105.67, 9845.43,...

That's definitely a good idea. I don't get emailed often, but in most cases if I do I'd prefer to reply via PM as well.

You can use the DatePart Fucntion to get the week number and group on that. Like this in your query:

SELECT

DATEPART(week, GETDATE()) as week

This returns 16...

I would be interested in using the external cloud for some of my personal stuff, but not for a business application at this time. Between security issues and potential...

I didn't really think we disagreed, I understood what you meant, and I wanted to make sure that you, and everyone else, understood what I meant. I also was...

raj more (4/16/2009)

---

Great intro. I like it.

I have seen tools like Intuit (now Quest S/w) Coefficient that do a phenomenal job of analyzing the output of a trace and...