you could do a correlated sub query.

select

d1.auID,

d1.Emp_ID,

d1.dt_Start,

(

select top 1

d2.dt_End

from auData d2

where d2.auID > d1.auID

and d2.Emp_ID = d2.Emp_ID

order by d2.auID

) as dt_end

Emp_Cat

)

from auData d1

where d1.dt_Start is not null

This will select...

It appears that this can be acomplshed with the use of two user defined database functions. The data is composed of two parts seperated by a "*". Each...

Best not to stir up the hornets. I really does not matter anyway. This methodology would propably fail regardless of the actual application.

That is the thing the http://FTP.exe client is working fine. If it is connecting on port 21 then the default ought to work on the built in...

I tried both active and passive mode. Neither worked. What port number would you suggest? What is the default for http://FTP.exe? I know it...

I agree. The 20 year old bcp program is far easier to use for this type of simple process than the new fangled SSIS. It would have helped...

You could do the following:

1. Create a "NewAccounts_Work" table.

2. Add the fourth stream into the New Accounts work.

3. Create a "NewAccount_Template" table. This would have all...

I have done the following and it works fine.

1. Create an Excel file that has only the output column names in it. Call it something like "OutFile_Template.xls".

2. ...

Thank you to erveryone that participated in this poll. Especially to those who left comments (some of them funny :P). I am glad to know that everything...

To Tomm Carr,

While I am not going into details of the design. I would just say that the other tables I am talking about are used to help query...

The idea is of this design would have one row for each data item. If you are looking up an item that is related to a particular entity (one...

Not sure on this, but it looks to me like you put the file path into the variable name rather than the variable value. It appears to be looking...