It was also the first question in the first response!

IIF() is from 2012 only...

Here's a code snippet proving that the iif() method should be fine.

declare @Ordinal int = 0;

declare @First varchar(30) = 'Jimbo';

select CO_OWNER = iif(@Ordinal = 0, null, @First);

set @Ordinal =...

Post your SQL please.

select CO_Owner = iif(Ordinal = 0,NULL,CO_Owner)

yusufm 48726 (5/7/2015)

---

where do you think I should post it? I posted in the newbie and they told me not to post it there. I check SQL Server 2012-T SQL...

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