your double quotes are messing you up. here's the line

SET @strSql = 'SELECT rowid AS id,description INTO '+@tablename+' FROM OPENROWSET( ''Microsoft.Jet.OLEDB.4.0'', ''Excel 8.0;Database=D:\webs\cig.org.ec\www\CO\Uploads\files\'+@file+'',''SELECT * FROM [Sheet1$]'') ORDER BY id'

Note...

Switching between HTTP and HTTPS in itself usually will drop the session info in IIS. Are you in a position on that IIS server to only allow https? That...

Kristin Echols (10/4/2007)

---

I have a mixed marriage: I manage a SQL Server team and my husband manages an Oracle team.

We have agreed to disagree...for the children's sake.

p.s. ...

jay holovacs (10/4/2007)

---

When my son got married I went out for drinks with a bunch of his friends.

You haven't lived till you get roasted by a bunch half drunk Oracle...

Also - by having a separate transaction deal with the output, versus one directly tied in to the insert, you minimize data loss. You can reprint an invoice, as...

SELECT dbo.tblCoilData.Coil_ID, count(*) as shortoutages

FROM dbo.tblDowntime INNER JOIN

dbo.tblCoilData ON dbo.tblDowntime.Coil_ID = dbo.tblCoilData.Coil_ID

WHERE (dbo.tblDowntime.Duration < '900')

group by dbo.tblCoilData.Coil_ID

Also - no way should duration be char value - that will cause...

Sorry - some of my first post got whacked - check the response above now...

CASE doesn't work that way. CASE is used for inlining simple functions, but cannot encapsulate whole SQL statements (a function call itself, but not an EXEC statement).

Try this instead:

CREATE...

My eyes see one thing, and my fingies type another. Thanks Adam.

You're not doing a subtract at all (I understand that's the goal, but the syntax isn't doing that).

You're getting no results because the NOT EXISTS syntax is wrong. Never...

This is one of those confusing. In order to set ANSI NULLs or ANSI WARNINGS for a stored proc, you need to set them BEFORE the create procedure syntax....

Well - it's tough to know - since you've got records from 3 tables. One of the table's values will likely look like they're duplicating - but that's the...

Keep in mind - you can use MAX and MIN functions on character fields, and they will return the char field. Might be easier than doing the link to...

also confused - are you saying you're having trouble because the SSIS isn't executing those steps, or the SSIS step needs to call another SSIS package?

Of course - you CAN partition based on a computed column, so you could backdoor your way into your partitioning scheme using the right computed column (like, say,

CASE when...