yusufm 48726 (5/7/2015)

---

it does not return any data on...

current date = cast(getdate() as date)

Try bringing it in as a decimal ... that is how Excel stores datetimes.

'Flashback'. What is that?

Same functions in both editions, no need to worry.

Not just beginners....

Why should you have to code around this?

Speak to whoever created the file and explain that it violates...

1) Have you checked that the statement is running in the right database?

2) Why not truncate the table rather than drop/create?

xddevv (4/30/2015)

---

Hi Phil,

Once the file is deposited in the shared drive, there is no other process that uses that file.

I read other articles about permissions, but I think that’s...

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...