listi.netinc_db_routines: err logic = -2147217865 The Microsoft Jet database engine cannot find the input table or query 'settop'. Make sure it exists and that its name is spelled correctly.
exec settop
inc_db_routines: err logic = -2147217904 No value given for one or more required parameters.
select config_value from config where config_value = 'listi.net'

Listi.net

             


inc_db_routines: err logic = -2147217904 No value given for one or more required parameters.
select cookie from emails where email = '' and from_system = 'successalarm.com'
inc_db_routines: err logic = -2147217865 The Microsoft Jet database engine cannot find the input table or query 'goalpts'. Make sure it exists and that its name is spelled correctly.
select sum(goal_pts) from goalpts where email = '' and dt_goalpt = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

Creating SQL statements using Excel

Today I received a list of data from a colleague in an Excel spreadsheet. I needed to take this information and retrieve other information from a database.

On the spreadsheet data is in column A. In column B put the following:

="insert into #tmp value ('"&A1&"')"

Then fill down the data

in your SQL app

Create table #tmp (
f1 varchar(20)
)

copy and paste the SQL statements and run. You now have a temp table that can be used to extract other information from your database.