Viewing 15 posts - 8,416 through 8,430 (of 13,876 total)
Then your top 1 query has a flaw too, it has no where clause.
No ORDER BY clause, I think you may have meant.
May 12, 2015 at 8:02 am
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"...
May 12, 2015 at 5:27 am
vipin_jha123 (5/12/2015)
Hi ,It was a problem with the length of column.
i increased the length of column and now running fine.
regards,
Vipin jha
I'm amazed you worked that out, based on the error...
May 12, 2015 at 2:58 am
Can you confirm that you have resultset set to none and include a screen shot of your parameter mapping screen?
May 12, 2015 at 1:30 am
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]
May 11, 2015 at 5:10 am
Is there anything special about
dbo.MostOrderedGenerics
?
May 11, 2015 at 2:20 am
Eric M Russell (5/8/2015)
Bradley Deem (5/7/2015)
Phil Parkin (5/7/2015)
'Flashback'. What is that?
Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the...
May 8, 2015 at 7:25 am
am_mal80 (5/8/2015)
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...
May 8, 2015 at 6:46 am
It was also the first question in the first response!
May 7, 2015 at 1:30 pm
SKY986 (5/7/2015)
ahh... I was connected to a SQL 2008R2 server. When I connected to a 2014 Server it works just fine!Different syntax for 2008?
Thanks
IIF() is from 2012 only...
May 7, 2015 at 1:11 pm
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 =...
May 7, 2015 at 12:58 pm
SKY986 (5/7/2015)
Thanks! I got an error saying the function requires 3 arguments?
Post your SQL please.
May 7, 2015 at 12:17 pm
select CO_Owner = iif(Ordinal = 0,NULL,CO_Owner)
May 7, 2015 at 11:09 am
yusufm 48726 (5/7/2015)
May 7, 2015 at 9:25 am
Viewing 15 posts - 8,416 through 8,430 (of 13,876 total)