Hi John,

I've unpivoted NULLs quite successfully before. It just takes a value column that is NULLable to do it.

And I'm a little concerned about your use of varchar(255) rather than...

When I did software engineering at university (2001-2005), we learnt C for networking, SQL for database theory, and Java for concurrency. We also learnt Eiffel and design-by-contract, which was a...

I think you can Copy and Paste the connections XML between packages to speed up the process.

Otherwise, you'll just have to put up with the extra connections.

I was trying to find an article by name and date - and the articles were roughly in date order. Unfortunately, searching by date didn't work.

I imagine that the AES-126 bit answer is a typo.

Can we get it fixed to AES-128 bit?

I guess I should...

CASE WHEN (id+3)%4=0 THEN 1

WHEN (id+2)%4=0 THEN 2

WHEN (id+1)%4=0 THEN 3

...

Someguy (9/23/2009)

---

Yes, there is an ongoing discussion about how to define a DBA. My suggestion is that this is Microsoft's job. Those definitions should make their way into the certification...

Perhaps you should look at the TransactionOption and IsolationLevel properties in SSIS (2005).

They seem to be what you're after to:

* Use SSIS

* Prevent Users from reading incomplete data

pedro.ribeiro (4/16/2009)

---

Hi Masters,

Thank you very much for all the advices.

I made it, other way....

I have created the table (bulk_contribuintesest), taht the view needs to be constructed.

Then, i crate...

pedro.ribeiro (4/13/2009)

---

Hi masters,

I have the t-sql below.

This t-sql is generating an error, because i don't have the tables:

bulk_contribuintesest

bulk_contribuintee

bulk_contribuinteinst

If i have the create of a view inside...

xgcmcbain (4/7/2009)

---

my main point is i cant belive the import explort wizord doenst allow this, what i could code up in 5 minutes, after how many years SQL Server has...

You'll have to wrap it in a CTE or Join Subquery to use it in the...

xgcmcbain (4/6/2009)

---

Tim Wilson-Brown (4/6/2009)

---

Because you have duplicates in your import files 🙂

(See post http://www.sqlservercentral.com/Forums/Topic690671-338-1.aspx)

Every time you load a...

sayfrend (4/6/2009)

---

Actually SET IDENTITY_INSERT ON would let you insert values into...