(Update 9/29/2010: Fixed download link. Also new version is 1.02 – only thing different is that you don’t get a long preview of your clipboard. I found out that some people were copying up to 1,000 rows even!)
Do you want to go from this:
To this in 2 clicks?
Well, you can now!
For my job, I end up often having to do a lot of research in various tables to debug something. But I hate when I’m doing research via SQL, and the following happens:
You have numerous rows in a column in Excel or from your SQL results from your , and you wish you can just use that list instantly to run another query in another table, putting that list in a WHERE clause with the IN function.
But alas, you find yourself pasting that into notepad, and then manually entering all the commas, single quotes, and then that beginning and ending ( ) to make it work.
It’s tedious and inefficient!
So I used whatever little programming knowledge I know (using Autohotkey) to create a tiny program I call the “SQL Listifier”.
I think this little app will eliminate this problem once and for all and save everyone a lot of time!
In the end, it’s just a basic app based on search and replace, but I would appreciate even a donation of $1 (via paypal) if you think all the time you save is worth that much.
Download SQL Listifier [Zip File - just unzip anywhere and double click on the .exe file to use]
INSTRUCTIONS:
1. Copy a column of values (Control + C) from Excel of from the SQL results grid from your SQL tool
2. Launch SQL Listifier and paste the values into the edit box
\
3. Click on OK – now the results are formatted for SQL to use in your WHERE clause for the IN function, and already in your clipboard
4. Click OK again and then just press Control + V to paste in the values back into your SQL app.
This should save you a lot of time the more you use it.
