[font="Verdana"]Here's some example code to give you an idea:

declare @IPAddress table(AddressID int not null primary key, IPAddress varchar(15) not null);

insert into @IPAddress

select 101, '8.143.46.' union all

select 102, '8.243.6.AC' union all

select...

[font="Verdana"]Well, thinking about it, it's actually a little tricky. The best solution would be something with full regular expression handling to cope with it.

However, you could use a pattern...

[font="Verdana"]This is the sort of thing I use a Calendar table for. I build a permanent table with the list of dates for the year (or next ten years)...

[font="Verdana"]Interesting start to a good topic.

I'm not sure I agree with the comment in the article that the "only way" to do things in the past has been with stored...

[font="Verdana"]I faced this very self same issue with a client a little over a year ago, who were running SQL Server 2005. The situation there was exacerbated by triggers.

The...

[font="Verdana"]Okay. So what's the problem with doing that?[/font]

[font="Verdana"]Okay, one thing I will add as a caution here.

If any of your five hours fields can be null, then adding them together will result as null, which means all...

RBarryYoung (6/11/2009)

---

What #temp table overhead are you talking about? One of the tings that Wayne's article reveals is that temp table and table variables have *almost* identical overhead.

The real...

[font="Verdana"]Thanks for your input guys. I'll be less hard on float going forward, I think.[/font]

[font="Verdana"]Here's something I wrote on the topic a while ago (note the Anglicised spelling versus the Americanised... just means we use an S instead of a Z.)

Normalisation is the...

[font="Verdana"]We do have a field named "calendar_date_ddmmyyyy", and I suspect it was created by one of the dodgy consultants we had in who we've been cleaning up after. I...

Jeff Moden (6/4/2009)

---

Other than a calendar table, do you have an example where storing a date in the format of 1/12/2009 in a table is actually the right thing to...

[font="Verdana"]You could set the referential constraint between Order_Line and Order to include the Work_Code. So long as the Order_Code has a separate unique constraint on it on the Order...

[font="Verdana"]We could have an argument about that, but in general I believe you are correct. The...

[font="Verdana"]Always a good thing! I don't know about you, but I usually learn more when I...