I have actually implemented this and it is pretty slick. The only thing that I had trouble with is when it failed to send an email to an internal...

I think your problem is here:

[paramater mapping tab]

variable name - Package::CampaignName

Direction - input

Data type - nvarchar

Parameter Name - 0

Parameter Size - 50

you are converting from a string into nvarchar and...

I think I know exactly what "Column aliases in ORDER BY clause cannot be prefixed by table alias"?

The advisor isn't smart enough to say that there IS a problem just...

HEre is where your problem is:

SET @noorden = (SELECT NOORDEN FROM inserted)

SET @cliente = (SELECT NOMBRECLIENTE FROM inserted)

SET @facturado = (SELECT FACTURADO FROM inserted)

You have a choice, you can...

Intellisense only works against a SQL 2008 server with 2008 tools. Sorry, I wish it weren't so..

CEWII

Gianluca Sartori (10/8/2009)

---

You should get rid of the NOLOCK hint, both from the view and the query.

NOLOCK could return inconsitent results (eg. when a page spilt is involved).

You can use...

Can we ask what this script does because while what you are asking is generally possible it would help to know the problem being solved.

CEWII

Then that leasds me to question what it is about that table, in the query that pulls the data are you doing an order by or is it just SELECT...

Unfortunately this is not a very straightforward question. A lot depends on how you have your MS software licensed, or whether you bought in "retail". One thing though,...

Build an SSIS package to do it. It will almost certain run faster. Insert/Select is a slow operation, you want to get it to do a Bulk/Fast insert.

The...

You can create indexes on temp tables. But not on the output from a TVF. You might consider outputing the TVF into a temp table or table variable...

My first thought was to question what server level rights you have? What fixed server roles are you is? Sysadmin? DBCreator? None? If you don't...

I agree *generally* with Steve, you really shouldn't create tables that exceed the 8060 number. There are *very few* reasons to do so. You should shrink your varchar...

So its time for school work again..

CEWII

Memory dump != Virtual memory..

They are not equivalent..

CEWII