SQL IN operator string builder
Have you ever had a list in excel, that you need to query from a database? Something like this:
abc
def
ghi
jkl
mno
Then you had to turn it into a SQL query like this:
Select * from mytable where some_value in (’abc’,’def’,’ghi’,’jkl’,’mno’)
Yeah…not so bad when its four or five…or you don’t work on a trading floor where a trader is […]
Importing Excel data into MS SQL Server
I recently had to import a bunch of data from Excel into MS SQL Server. I kept getting failures, because I orignially tackled the problem by first designing and creating the table, then trying to import into my existing table. This was a pain in the neck. So what I decided to do was import […]
