Thanks for the feedback!

Can't be done in T-SQL functions. You might be able to get away with...

I have to say - we haven't managed to trigger a full-out religious war on any topic in...

If you're using it as a Primary Key, then I'm on board with Jeffrey Williams - don't do it. This sets up "evil twin" scenarios and/or relational integrity problems...

Here's an improved version for fixing the ranges:

--drop table #ranges

;with Alpha1 as (select

...

Chocolate itself...

Are your member Id's actually just made up of numbers even though they are stored varchar? If so - you could simply use the Tally table itself to generate...

You seem to be running into the "2-digit year cutoff" property.

Your best solution might be to simply make sure that the remote system actually stores and passes 4 digit years...

The simple answer to how to copy is - don't do it from within SQL Server. Schedule something outside of SQL server (windows scheduled task, etc...) to do the...

The economy is suffering enough - we just can't curb our excessive caffeinated drink habits. Coca Cola and Pepsi might not survive the onslaught....:)

That being said - a couple...

Doug (12/4/2008)

---

Hi Matt,

I'm still working on Jeff's solution. It takes a while to run...

Agreed that the import objects trick Ninja mentioned has saved my bacon in these kinds of scenarios before.

That being said - have you tried simply holding the SHIFT key down...

Did you ever try my idea on? Just curious what you ran into.

Jonathan Kehayias (12/3/2008)

---

Matt Miller (12/3/2008)

---

Just about any scalar function can be used in this way. The idea is you're creating what is called a computed column (other DB's I've...

Here's an example of walking the clustered index:

drop table #ranges

;with AlphanumericCTE as (

select

char(N) digit,

char(N+1) nextdigit

from tally where

n between 48 and 57 or --digits 0 through 9

n...