Keyboard Face

when you find QWERTY imprinted on your cheek - it's time to go to bed.

Tags

asp CSS css menus dreamweaver flash gallery2 hosting iis7 Javascript jquery jquery ui left mac mssql os9 php printer rdp SEO sql sql server windows wordpress

MSSQL Large Sub Query Impossibility

by Leave a Comment

I recently had to query to find out how many records from one table were not in another really large table. When you do a select statement like this in MSSQL it overflows and gives you a response of 0. Not very helpful:

select count(*) from Table1 where Field Not In (Select Field from Table2)

All other ideas failing, I finally resorted to writing a query using a temp table variable:
set nocount on;
declare @Tables table (
PK int IDENTITY(1,1),
Field1 varchar(100), Field2 varchar(100)
);
insert into @Tables(Field1 , Field2 )

select t1.Field, t2.Field from Table1 t1
left outer join Table2 t2 on
t1.Field = t2.Field;

set nocount off;
select count(*) as Count, Field1 from @Tables
where Field2 is Null
Group by Field1
Having Count(*) < 2;

Talk about complicated! If you have any other better ways of doing this – please let me know!

Deactivating Youmail on IPhone

by 1 Comment

I just got an IPhone recently and set it to use Youmail. Youmail is a great service, but right now I actually found I wanted to just use the visual voicemail that comes with the IPhone. When traveling, I think I’ll want to be able to activate Youmail again because it is very handy the way it send you emails with your voicemails in them – it even transcribes them!

Anyway, I had a hell of a time finding the dialing codes to deactivate Youmail, so I put them here. I put them as contacts in my phone for future reference.

I previously posted a link to this article as having the codes I needed to deactivate Youmail:
http://arstechnica.com/journals/apple.ars/2008/08/16/on-disabling-voicemail-on-the-iphone

It turns out the codes only seemed to work. I ended up having to cancel my Youmail account and they then gave me the codes. Very frustrating.

To disable the Youmail service and revert to Visual Voicemail the code is ##004#. (This is on AT&T or Cingular).