I'm tasked with creating SSIS packages that import and export data to an ERP system as sales orders and invoices.

While I'm very familiar with using flat files in...

We have a bunch of old views that are used for cross-database queries and they were originally written using hard-coded database pointers. Of course after moving/renaming the databases a...

I like this solution because it handles the "dangling decimal point" issue,...

The only problem with using LEFT() is if the value to the left of the decimal is...

+1

I realize that it uses an undocumented Microsoft function, but rather than creating a stored procedure, couldn't you just use:

sp_msforeachdb 'select "?" AS db, * from [?].sys.tables where name like...

You could also use:

sp_MSforeachtable 'select ''?'' Tablename, count(*) ''Rows'' from ?';

though this uses an undocumented Microsoft function, and may go away at any time/be modified.

I originally got this code from...

RLilj33 (2/26/2014)

---

Equivalent to:

SELECT X AS 'Intersecting'

FROM A

JOIN b ON b.y = a.x;

Except the ordering. INTERSECT returns the values in...

+1:-)

I'm unsure how useful this script is for an 'active' database.

Running against our development server, with few if any active connections at the time, produced some interesting information,...