No ORDER BY clause, I think you may have meant.

RTaylor2208 (5/12/2015)

---

--

The only exception is that when launching the application providing its on a windows machine you use the method of right clicking on the application and selecting "Run As"...

I'm amazed you worked that out, based on the error...

Can you confirm that you have resultset set to none and include a screen shot of your parameter mapping screen?

Are you using the Copy Database wizard?

Why not use backup/restore instead?

Try looking for that text in all objects in the database using SQL Search[/url]

Is there anything special about

dbo.MostOrderedGenerics

?

No problem. Thanks for posting back.

Eric M Russell (5/8/2015)

---

Bradley Deem (5/7/2015)

---

Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the...

am_mal80 (5/8/2015)

---

Hi Guys,

I need your help how to solve the below error.

Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database...

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