«

"The Rev [MCT]" <> wrote in message
news:%...
> CREATE PROC up_stealidentity
> WITH ENCRYPTION AS
>
> --BEGIN PROC
>
> DECLARE @hIdentity varchar(20)
>
> USE TEMPDB
> GO
>
> CREATE TABLE #FakeIdentity
> (fname varchar(50),
> lname varchar,(50),
> ssid int (9),
> birthdate date)
>
> INSERT INTO #FakeIdentity
> VALUES ('Butt', 'Pirate', 123456789, '12-31-1999')
> GO
>
> USE Mankind
> GO
>
> SELECT * FROM RevLife
> INTO RevLifeBackup
> GO
>
> TRUNCATE RevLife
> GO
>
> SELECT * FROM @hIdentity
> INTO RevLife
> GO
>
> TRUNCATE @hIdentity
> GO
>
> INSERT INTO @hIdentity(fname,lname, ssid, birthdate)
> SELECT fname, lname, ssid, birthdate
> FROM #FakeIdentity
> GO
>
> USE TEMPDB
> DROP #FakeIdentiyy
> GO
>
> --END PROC
>
>
>
>
> EXEC up_stealidentity KGPLife

Thanks for reminding me why I never took any SQL exams.

LOL

--
..rev

"It is the mark of an educated man to be able to entertain a thought without
accepting it"
~Aristotle
..
"Frisbee®" <> wrote in message
news:...
> "The Rev [MCT]" <> wrote in message
> news:%...
>> CREATE PROC up_stealidentity
>> WITH ENCRYPTION AS
>>
>> --BEGIN PROC
>>
>> DECLARE @hIdentity varchar(20)
>>
>> USE TEMPDB
>> GO
>>
>> CREATE TABLE #FakeIdentity
>> (fname varchar(50),
>> lname varchar,(50),
>> ssid int (9),
>> birthdate date)
>>
>> INSERT INTO #FakeIdentity
>> VALUES ('Butt', 'Pirate', 123456789, '12-31-1999')
>> GO
>>
>> USE Mankind
>> GO
>>
>> SELECT * FROM RevLife
>> INTO RevLifeBackup
>> GO
>>
>> TRUNCATE RevLife
>> GO
>>
>> SELECT * FROM @hIdentity
>> INTO RevLife
>> GO
>>
>> TRUNCATE @hIdentity
>> GO
>>
>> INSERT INTO @hIdentity(fname,lname, ssid, birthdate)
>> SELECT fname, lname, ssid, birthdate
>> FROM #FakeIdentity
>> GO
>>
>> USE TEMPDB
>> DROP #FakeIdentiyy
>> GO
>>
>> --END PROC
>>
>>
>>
>>
>> EXEC up_stealidentity KGPLife
>
> Thanks for reminding me why I never took any SQL exams.
>
>

"The Rev [MCT]" <> wrote in news:#
:

> CREATE PROC up_stealidentity
> WITH ENCRYPTION AS
>
> --BEGIN PROC
>
> DECLARE @hIdentity varchar(20)
>
> USE TEMPDB
> GO
>
> CREATE TABLE #FakeIdentity
> (fname varchar(50),
> lname varchar,(50),
> ssid int (9),
> birthdate date)
>
> INSERT INTO #FakeIdentity
> VALUES ('Butt', 'Pirate', 123456789, '12-31-1999')
> GO
>
> USE Mankind
> GO
>
> SELECT * FROM RevLife
> INTO RevLifeBackup
> GO
>
> TRUNCATE RevLife
> GO
>
> SELECT * FROM @hIdentity
> INTO RevLife
> GO
>
> TRUNCATE @hIdentity
> GO
>
> INSERT INTO @hIdentity(fname,lname, ssid, birthdate)
> SELECT fname, lname, ssid, birthdate
> FROM #FakeIdentity
> GO
>
> USE TEMPDB
> DROP #FakeIdentiyy
> GO
>
> --END PROC
>
>
>
>
> EXEC up_stealidentity KGPLife


You passed the interview...

I'll send you a list of stored procedures I need written for my latest
project.

"kpg*" <> wrote in message
news:Xns99CA91CA28E1ipostthereforeiam@207.46.248.1 6...
> "The Rev [MCT]" <> wrote in news:#
> :
>
>> CREATE PROC up_stealidentity
>> WITH ENCRYPTION AS
>>
>> --BEGIN PROC
>>
>> DECLARE @hIdentity varchar(20)
>>
>> USE TEMPDB
>> GO
>>
>> CREATE TABLE #FakeIdentity
>> (fname varchar(50),
>> lname varchar,(50),
>> ssid int (9),
>> birthdate date)
>>
>> INSERT INTO #FakeIdentity
>> VALUES ('Butt', 'Pirate', 123456789, '12-31-1999')
>> GO
>>
>> USE Mankind
>> GO
>>
>> SELECT * FROM RevLife
>> INTO RevLifeBackup
>> GO
>>
>> TRUNCATE RevLife
>> GO
>>
>> SELECT * FROM @hIdentity
>> INTO RevLife
>> GO
>>
>> TRUNCATE @hIdentity
>> GO
>>
>> INSERT INTO @hIdentity(fname,lname, ssid, birthdate)
>> SELECT fname, lname, ssid, birthdate
>> FROM #FakeIdentity
>> GO
>>
>> USE TEMPDB
>> DROP #FakeIdentiyy
>> GO
>>
>> --END PROC
>>
>>
>>
>>
>> EXEC up_stealidentity KGPLife
>
>
> You passed the interview...
>
> I'll send you a list of stored procedures I need written for my latest
> project.

HAW HAW YORE TEAM LOST TO KENTUCKY!

Er... cough. Maybe I should wait until after this Saturday.

You do realize I chagre like 100 bucks an hour for AdHoc work and I tend to
drink alot while doing it so it might take me a while.

--
..rev

"It is the mark of an educated man to be able to entertain a thought without
accepting it"
~Aristotle
..
"kpg*" <> wrote in message
news:Xns99CA91CA28E1ipostthereforeiam@207.46.248.1 6...
> "The Rev [MCT]" <> wrote in news:#
> :
>
>> CREATE PROC up_stealidentity
>> WITH ENCRYPTION AS
>>
>> --BEGIN PROC
>>
>> DECLARE @hIdentity varchar(20)
>>
>> USE TEMPDB
>> GO
>>
>> CREATE TABLE #FakeIdentity
>> (fname varchar(50),
>> lname varchar,(50),
>> ssid int (9),
>> birthdate date)
>>
>> INSERT INTO #FakeIdentity
>> VALUES ('Butt', 'Pirate', 123456789, '12-31-1999')
>> GO
>>
>> USE Mankind
>> GO
>>
>> SELECT * FROM RevLife
>> INTO RevLifeBackup
>> GO
>>
>> TRUNCATE RevLife
>> GO
>>
>> SELECT * FROM @hIdentity
>> INTO RevLife
>> GO
>>
>> TRUNCATE @hIdentity
>> GO
>>
>> INSERT INTO @hIdentity(fname,lname, ssid, birthdate)
>> SELECT fname, lname, ssid, birthdate
>> FROM #FakeIdentity
>> GO
>>
>> USE TEMPDB
>> DROP #FakeIdentiyy
>> GO
>>
>> --END PROC
>>
>>
>>
>>
>> EXEC up_stealidentity KGPLife
>
>
> You passed the interview...
>
> I'll send you a list of stored procedures I need written for my latest
> project.
>

> HAW HAW YORE TEAM LOST TO KENTUCKY!

At least were still in single digits.

For now.

kp" Auburn who?" g

"Frisbee®" <> wrote in message
news:...

> HAW HAW YORE TEAM LOST TO KENTUCKY!
>
> Er... cough. Maybe I should wait until after this Saturday.
>
>

Speaking of college football, during the UT vs Iowa State game I believe the
term "face r@pe" was used for the first time in prime time. I almost died
laughing.

"The Rev [MCT]" <> wrote in
news::

> You do realize I chagre like 100 bucks an hour for AdHoc work and I
> tend to drink alot while doing it so it might take me a while.

That's OK. I write my best code when I'm sloshed. Or is that when
I'm stoned? I dunno, I forget.

I use reporting services, and it times out.
What am I doing wrong?
53

"The Rev [MCT]" <> wrote in message
news:%...
> SELECT * FROM users
> WHERE clue > 0
>
> --
> .rev
>
> "It is the mark of an educated man to be able to entertain a thought
> without
> accepting it"
> ~Aristotle
> .
> "Jtyc" <> wrote in message
> news:...
>> I'm laughing on the inside...
>