It creates a CROSS JOIN.

These should be equivalent:

SELECT *

FROM table_1 a

JOIN table_2 b ON a.id = b.id,

...

I would recommend you leave the sp_OA procs disabled on your instance and start using the SQLCLR for tasks like this...

If you're being boxed into using the OLE Automation procs...

I think he has a list of hostnames and he needs to discover the SQL Server instances in the first place...RamSteve, can you clarify?

As usual...it depends. I just found this little nugget and it reminded me of this thread. The article is also from the sqlskills.com tandem. It starts off by supporting the...

I started looking into this but have to go so figured I would post what I found so far...

After setting up a little test environment:

CREATE TABLE dbo.a (NAME VARCHAR(100))

INSERT INTO...

To clarify...I am implying that you would enhance your PowerShell script to update the configuration table in the database with the "last reboot time".

I would setup a SQL Agent job that was scheduled to "Start automatically when SQL Agent starts" to call your PowerShell script, retrieve the "last reboot time" from the OS...

Not that you won't receive help here...but you may be better off posting this in one of the Reporting Services forums: http://www.sqlservercentral.com/Forums/Group416.aspx

This is presenting itself as a "running total" problem...i.e. you need to compare a value in the previous row to a value in the current row to make a decision...

Martin Stephenson (3/15/2011)

---

HP EVA 4400, which gives us virtualised storage, my take on this is that it makes my life easier.

I am tempted to create an OS drive and a...

There is another Sybase migration discussion going on that may assist...this post in particular may be useful to you:

http://www.sqlservercentral.com/Forums/FindPost1078311.aspx

Attached are the SSMA for Sybase to 2005 from Roger's first link and the two white papers from Roger's second link.

The expression builder SSIS offers are just abstractions of .NET code. SSIS expressions were not meant to handle everything...but they do handle most inline data manipulation needs. The Script Task...

My Flat File Connection is setup with a double-quote as a text qualifier and I did not have any issues importing a file containing the data shown...

I see this issue...

I am not having the same issue. Do you have a Text Qualifier set on your Flat File Connection?

Please post the line of the file having the issue, the properties...