Archive for the ‘Technical’ Category

How to find multiple/duplicate rows with the same value

Just a short SQL script which will allow you to find the mutiple rows with the same values in the same table. I am not going to explain what the query does since its a very straight forward query
PLAIN TEXT
SQL:

SELECT [column_name]

FROM [tablename]

GROUP BY [column_name]

HAVING count(*)> 1

--  OR

 

SELECT * FROM [TableName] WHERE [ColumnName] IN (

SELECT [ColumnName] [...]

Read the rest of this entry »

How to write a CURSOR loop over multiple databases in MSSQL 2000

I sure lot of people might want to use the script where they would want to loop over multiple databases sitting on a Single server. In my case, I had to check for  a Login Record  in all the databases since the person left the company and we wanted to disable his/her access. SO I wrote simple [...]

Read the rest of this entry »

Troubleshooting Random null null Error in Coldfusion MX

I have been looking so much for this error in Coldfusion MX  but could not find any solution to my problem. null null is a very vague exception error which gets thrown once in a while. Below are the steps I did to troubleshoot and one of them did the solved the problem.
 1) Apply this [...]

Read the rest of this entry »

Some Windows Run Commands

I thought it would be beneficial to my blog readers to show some of the Windows RUN Commands which will take you directly to the place you want to go !
 To Access.. - Run Command
Accessibility Controls - access.cpl
Add Hardware Wizard - hdwwiz.cpl
Add/Remove Programs - appwiz.cpl
Administrative Tools - control admintools
Automatic Updates - wuaucpl.cpl
Bluetooth Transfer Wizard - [...]

Read the rest of this entry »