Child package has some dependency that is causing errors that you are not aware of. You should paste the full output of your error window. Check for package configuration differences,...

Convert to CSV and import. Importing from excel has too many inherent problems. Back in 2002 I wrote a custom parser that had to handle this exact problem because even...

Why don't you use your local SMTP server to send mail but change the reply to from your hotmail/yahoo/gmail account through your SMTP server [if it can support this server-side].

Disagree. Each product release is finite and static.

I don't say I'm a SQL Server expert, I say I'm an expert at SQL Server 2005. Unless you know everything you're not...

This is really a hack but, I'd suggest connecting to your database with microsoft access and then copying directly from BIDS to your table [through a linked table]. Then you...

For the last couple years I have been doing SQL Server only interviews. There are positions with only SQL Server no dot net. A couple obvious ones would be DBA/Developer...

I believe it's unavoidable because of the unions in the CTE

Additionally, you can insert 1 row and then

insert rowinformation from

select rowinformation i just inserted

This way you will have 2^x number of rows of test data.

I'm sorry if this is too...

NIce job, I should have mentioned the CTE alternative too. Do you by chance have a link to that article that was up here a couple weeks ago regarding this...

search on this site for celko , nested set, adjacency

there was an article recently.

I'll write the code for you, but that will cost you alot of money 🙂

IO Timing stats have always been the best in my experience.

Just follow your statements line by line and see how long they are taking against how long you expect them...

Could you be trying to fit a value into your output parameter that is too large?

Select the results in a temp table

Open a forward on read cursor and concatenate into a varchar(max) variable.

Respect my grasshopper authorita 😉

It's going to be a stored procedure, another table and a view.

I suggest reading the recent posting on this very site regarding nested set representations of adjacency lists.

Once you get...