u can use the data import wizzard and create a dtsx process to do this. setting it up can be a pain in the but. Thats comming from someone who...

also, u may want to use the sp_msforeachdb functionality. Me personally, i stay away from it but that only cause old habit die hard.

We designed this at my old place. We called it a monitor. It would allow us to monitor all sorts of things from a single monitoring instance. It can get...

i see. i didnt read the bottom of his post. my bad......carry on

He didnt ask for set based solution but a cursor alternative. Who knows maybe your right. My solution was pre cte days. Old habits die hard.....

the above is a quick and dirty solution w/ pseudo code because you're not really providing the proper preface to give a detailed solution however it should suffice. Pretty straight...

declare @fm int, @movtype varchar(100)

select fm

, movtype

, 0 processed

into #temp

from whereEverThisIsStored

while exists ( select top 1 * from #temp where processed = 0)

begin

select top 1 @fm = fm

, @movtype =...

thanks guys. That worked.

Excellent. I was unaware redgate offered this. I've used it for post migration analysis but never for erd. I had used visio previously and i have to say the redgate...

actually never mind. That worked "SSCrazy Eights". Thank you guys...again...

thanks guys. I'll provide more infor in an hour or so. just got slammed.

sorry. it's coming in a different column

select replace('1 - Apr',' ','') dt, 2010 [year]

into #test

select dt,year --how do i convert this varchar to a datetime

from #test

lol. Brilliant.

So how do i unhash it?

To be honest i dont think he cares if it's hashed or encrypted. I think he just doesnt want it stored verbatum.