Utilizing ms sql temporary table

There are two types of temporary table in ms sql : local and global temporary table. You can read it further about that here and here.

For me, the best thing I found about this is that, this table will be created in tempdb table and it is only for temporary.It will be gone once you close your session.

I found out it very useful if I want to do patching or debugging with my data and many more reason for me to use it.

Below are few simple way how you can play around with temp table.

(more…)

Posted in Database, SQL/ETL | No Comments »

SQL – Not In vs Not Exists

I have stumble upon this great website talking about difference between “NOT IN” vs “NOT EXISTS” in SQL.

I’ve follow the step and create same table structure with same sample data into my temporary ms sql table.

Create temp table.

CREATE TABLE #EMP_MASTER
(
EMP_NBR INT NOT NULL PRIMARY KEY,
EMP_NAME VARCHAR(20),
MGR_NBR INT NULL
)

Populate sample data

INSERT INTO #EMP_MASTER VALUES (1, ‘DON’, 5)
INSERT INTO #EMP_MASTER VALUES (2, ‘HARI’, 5);
INSERT INTO #EMP_MASTER VALUES (3, ‘RAMESH’, 5);
INSERT INTO #EMP_MASTER VALUES (4, ‘JOE’, 5);
INSERT INTO #EMP_MASTER VALUES (5, ‘DENNIS’, NULL);
INSERT INTO #EMP_MASTER VALUES (6, ‘NIMISH’, 5);
INSERT INTO #EMP_MASTER VALUES (7, ‘JESSIE’, 5);
INSERT INTO #EMP_MASTER VALUES (8, ‘KEN’, 5);
INSERT INTO #EMP_MASTER VALUES (9, ‘AMBER’, 5);
INSERT INTO #EMP_MASTER VALUES (10, ‘JIM’, 5);

The aim of this query is to find all those employees who are not managers. The person is consider manager when MGR_NBR field is NULL.

hmm… query looks ok but the result is not.

(more…)

Posted in Database, SQL/ETL | 1 Comment »

HTTP 406 Error while posting using blogdesk.

I’m having weird problem while posting to my wordpress blog using blogdesk.

HTTP Errorcode: 406

NONE ACCEPTABLE

Googling around and the solution given is to add a few line in htaccess file.

<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>

I’ve update my htaccess file using that solution but no luck.I’m having 500 Internal server error instead after the changes.
Change htaccess file in root folder also give me same error.

I still can post using wordpress interface, but it is quite some time I have not using this features.

Any solution my dear friend ?

SOLVED. I don’t know what is the root cause. I have not done any changes since my previous attempt failed. maybe my hosting provided did something.

updated via -

Posted in My Life | 2 Comments »

My ubuntu installation – from Dapper to Gutsy

I received ubuntu CD long time ago. It’s is version 6.06 LTS. Few days ago I start installing ubuntu dual boot with my existing Window XP.

Since my streamyx is up and running, ugrading to new version went smoothly.

For malaysian, you can visit http://ubuntu.com.my/ if you are having problem with ubuntu.There are a lot of experts that can help and give their expertise advice.

Here is my ubuntu Gutsy screenshot.

Now I have new thing to explore.

Posted in *nix | 4 Comments »

My streamyx… up and running

Finally…i can update my blog using my own streamyx in my own sweet home .

All the while I’m updating my blog using internet connection in my office,cyber cafe,my mother in law neighbourhood “FREE” streamyx connection and any other place except my home.

Setting up my home wireless connection using Linksys WAG200G Wireless-G ADSL2+ Router is very easy ( after done some googling…of course)

The important thing is,make sure to update VPI/VCI value similar like below. everything else is just a straight forward

Hopefully I can blog more often after this.

adios….

p/s : life must goes on…

Posted in My Life | 7 Comments »