He didn't pass the parameters in, though - they're all output parameters. The values were got from the tables.

John

How have you tried making the whole thing dynamic? Did you use sp_executesql? Please will you post what you tried?

John

Sean, I think he's wanting to insert the values into tblVoting, and at the same time return the inserted values as output parameters. Obviously that'll only work if that...

Are you doing transaction log backups? How often? There's no need to change to simple mode and back again - just back up the log and shrink it...

Thanks Koen. As a production DBA, I prefer the methods that don't involve BIDS/SSDT, since I don't want to be opening packages in the design tools just to deploy...

Smells like a homework question to me. Have you looked at sqlcmd? If so, what have you tried? By the way, a folder contains subfolders and/or files....

jon.wilson (9/23/2015)

---

I'm trying to figure out how to do the following:

Number of People receiving their second speeding ticket during this time frame

4 Jun 06 -3 Jun 07

4 Jun 07 -3...

Why do a delete followed by an insert, instead of just doing an update? What is the nature of your random performance issues? Only use READ UNCOMMITTED if...

Another option is to drop indexes instead of disabling. Drop the non-clustered index, then drop the clustered index. Do your load, then recreate the clustered indexes followed by...

OK, paste that into your favourite search engine - you should get quite a few suggestions.

John

What is in the SQLAgent.OUT file? You can find the location by right-clicking on SQL Server Agent and choosing Properties.

John

Or, given that (I think) you only have five columns, you could bubble sort:

WITH MyTable (col1, col2, col3, col4, col5) AS (

SELECT 222, 444, 555, 111, 333

)

, FirstSort (col1, col2,...

Not if you're already on service pack 3, no. Are you sure it's not referring to a Windows service pack? Do you have any other instances on the...

Thiago

What happens if you try to use the GUI to drop the table?

John

Phil

I think it would be simpler. With Execute Process, you can use sqlcmd to execute the script from wherever it is. With another Execute SQL, you'd need somehow...