well, you could use something like this:

SELECT 'ALTER TABLE ' +

t.Table_Name +

' drop column ' +

c.Column_Name +

';'

FROM Information_Schema.tables t

INNER JOIN Information_Schema.columns...

Hi,

You cannot directly do that. Here's what you can do, either change your query so its a subquery:

SELECT *

FROM (SELECT *

FROM CRM_OrganizationalUnits

INNER JOIN...

If your requirement is to have the result in only 1 query, you could use this kind of query, to get to your requirements.

CREATE TABLE tblEmp (

name ...

If your table is going to be any big, you have a real performance killer there with this function.

Let's say you have 1000 employees:

The function will be called 1000 times...

I don't think you well get any significant improvements, but what you will get is a higher level of maintanability.

When you change the Country code, for example, you will need...

Finally found the problem.

When in a transaction with Distributed transaction coordinator, if you want to insert rows in a Header/Detail table, you need to insert in the header, but the...

Nice, I found the Problem, well, the Lock!

By looking at the Activity Monitor, I can see there is a Table Lock waiting for this process. The table is the Header...

Hi All, I might have another piece of the puzzle. When executing the package, after a few minutes, executing sp_who2 gives me the SPID of the importation, saying it's stuck...

Hey Jeff,

Thanks for your input, sadly, it does not help me 😉 I've been stuck on this for 2 days now, and I can't get to deploy my package.

I've tried...

I have more information, I added package Logging in the SSIS menu, and tried to sort things out.

The last information I see in the logging is a "OnProgress" during the...

Opening a transaction, deleting all the data in 3 tables, and insert from flat files, with some validation as per total Customer/Invoice counts/InvoiceTotals.

It only imports plain data to the DB,...

Both machines are 32 Bit. My dev environment and the QA Server.

2)...

I guess...

I have to say I am truly impressed Lutz, good job, I need to be able to do that.

crainlee2 (9/17/2009)

---

Jeff,

Before I use your suggestion to produce a 1M times 1M cartesian product that will consume all of memory, my CPU, and a hard drive, I'd appreciate an explanation...