Is there a chance that some other process has the file open when the job runs? Are you editing it yourself? 🙂

Try this

select t.Person

,UpdatedDate = max(isnull(t.UpdatedDate, getdate()))

from #Table1 t

group by t.Person;

select *

from dbo.T1 t1

cross apply (select Code = min(Code)

...

I did say 'over', as...

Unless you've paid over US$10,000 for a licence, you cannot use it as Enterprise on a production server.

ankithimmatlalshah (4/29/2015)

---

Hello everyone,

I was assigned a work item wherein, I've a dataflow task on For Each Loop container at control flow of SSIS package. This For Each Loop container reads...

Is the value of the variable itself an expression?

Risking sounding repetitive, but...

What does this mean?

Please answer Sean's question. 'To deal' is not a well defined verb in the T-SQL world.

This needs to be refined....

If you create a constraint that void < ticket, does that help? (Assuming ticket is an identity column.)

svanduffelen 83303 (4/27/2015)

---

This is a single table problem with two columns and 5 data integrity rules.

1.) The First Column is the primary key, Ticket, of type Integer

2.) The Second is...

As an aside, storing dates as nvarchar(50) is generally considered a really bad idea.

You could try something like this (untested because you did not post DDL, sample data etc):

with OrderedSet

as (

...

This won't help you right now, but maybe in future. You should put some sort of unique constraint on your table which would result in an error if such a...