SELECT [employee].employee_id AS a, [employee].employee_id +1 AS Expr1

FROM [dbo.employee];

or you could

select a, a+1 as Expr1

from (

SELECT [employee].employee_id AS a

FROM [dbo.employee];

) t

or maybe

;with cte

as

(SELECT [employee].employee_id AS a

FROM [dbo.employee]

)

select a, a+1 as...

What does the SP look like? Are you passing in the IDs as a parameter or doing a jion to the resultset?

If the former then access will be calling the...

depends on where your date is, what format, ...

Do you want to check for duplicates just on that date or check whether the computer name received on that date exists...

Maybe an instead of trigger on the target table?

Could also maybe use an ignore_constraints hint then clear the table up afterwards but that would probably mean keeping it locked.

How big are the files.

If they are smallish the easiest way to deal with this would be to bulk insert into a staging table with a single column.

Parse the data...

No.

The message is self explanatory. The partitioning columns must be included in unique indexes.

see

http://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

A netstat command?

By needing to use xp_cmdshell you are asking to run an o/s command to get the info. Not really anything to do with sql server.

Conditional split?

If you can detect it by the data in the row.

if not (and I haven't tried this)

Add an aggregate to hold up the data flow until the rowcount can...

What datatype are your two columns.

Can you post the create fulltext index command.

something like this

selectitemcode = min(itemcode) ,

qty = sum(case when treetype = 'S' then 0 esle qty end) ,

treetype = max(case when treetype = 'I' then '' else treetype end)

from

(select itemcode,...

one obvious issue

s.ticket <> null

should be

s.ticket is not null

Which table does status come from?

Do you really want to cross join the other tables?

If you make it a run time error (i.e. stop it being parsed) then it is trapped.

I tend to do most openrowsets like this so haven't noticed it before.

BEGIN TRY

declare...

It's because it tries to get the resultset format when compiling.

The error is a compile error not a run time error so is not trapped.

it appears not.

login, statement errors aren't trapped.

Thanks - yes we expected monitoring of servers to be in place.

This is more about viewing sql queries though.

Yes 3rd party tools would be good and I'm sure we will...