I think we've come to the point where we need some sample data. Please provide table DDL in the form of CREATE TABLE statements, data in the form of...

Whichever way you do it, this line:

and b.event_type = 'open'

needs to come out of the WHERE block and go into the join predicate. Otherwise, your left outer join...

Yes. First use ROW_NUMBER in a common table expression to get a row number for each of the top four rows in your table ordered by ColumnA. Then...

So just add a WHERE clause on the end of tertiusdp's code so that only the results for the user you want are returned.

John

You've posted in an Integration Services forum. Please will you confirm whether you are referring to DTS packages or SSIS packages?

Thanks

John

As I said before, try it.

You don't use the variables in or after your final CREATE TABLE statement, so it doesn't matter if you kill them.

John

There's only one way to find out! You may need to put an extra GO in before the CREATE USER statement, since I think the latter may have to...

Variables only live as long as the batch in which they are created. GO is a batch separator, and so it has the effect of killing all variables. ...

Please can we see what you've tried so far? Also, DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements would also...

I'm afraid I don't understand what the problem is. Please will you post your code to help me?

Thanks

John

Chances are that only your default instance is listening on the default ports (1433 and 1434). Your named instance will be listening on another port, which is dynamically assigned...

Of course, the results you get will depend on the date on which you execute the INSERT statement. I think you need to lose the [font="Courier New"]OR 1=1[/font], since...

With that level of detail, I can't be more specific than to suggest you use the REPLACE function.

Also, have you considered using SSIS instead of bcp? You may find...

Yes, that's exactly what I had in mind. Try that, and post back if you have any difficulties.

John

LF

The simplest way is to create a table with one column for each variable. SP1 can then write to that table, and the job can pick up the variables...