Viewing 15 posts - 106 through 120 (of 600 total)
Now try this:
SELECT *
FROM [dbo].[Catalog] c
WHERE [Type] NOT IN (1,5) -- Not a folder or a data source!
AND NOT EXISTS (SELECT 1 FROM [dbo].[ExecutionLogStorage] e
WHERE c.[ItemID] = e.[ReportID])
There happens...
February 13, 2015 at 5:06 pm
What does this return?
select * from [dbo].[ExecutionLogStorage] where [ReportID] IS NULL
a null report id could mess up the "not in" logic
February 13, 2015 at 3:09 pm
suraj.app (2/13/2015)
I have my table as below
instanceid rownum QuestionText Answer Result
1 ...
February 13, 2015 at 2:04 pm
How many different end tables are there, and do they need to be created dynamically, or are you just switching dynamically between existing ones?
February 13, 2015 at 2:01 pm
Sangeeth878787 (2/13/2015)
I wrote a function, which gives the next working day with by looking into holiday table for one country. But I am not able to succeed to back the...
February 13, 2015 at 9:38 am
Michael L John (2/13/2015)
Sangeeth878787 (2/13/2015)
What kind of requirement you had to do, do you have script for that, As a newbie I will try to learn and analyse which will...
February 13, 2015 at 9:35 am
Phil Parkin (2/13/2015)
Nevyn (2/11/2015)
Also, the alleged work around is to sort the packages in the dtproj file, so I'm surprised that...
February 13, 2015 at 7:19 am
Yeah, this whole scenario seems weird to me.
You can't suggest a consultant or admit you aren't good at optimizing or you'll be fired?
That very much makes it sound like you...
February 12, 2015 at 8:30 am
Basically if two intervals would be active he considers the one with the highest order id active. 2 never shows because it perfectly overlaps with 4, which is higher.
February 11, 2015 at 9:15 pm
Its a known bug they apparently decided not to fix
Also, the alleged work around is to sort the packages in the dtproj file, so I'm surprised that didn't work for...
February 11, 2015 at 9:13 pm
A language correction that may help you understand why you aren't getting an error.
When you execute the CREATE, you are NOT compiling it. It compiles the first time you...
February 11, 2015 at 3:02 pm
Well, this was a fun one to do.
I decided to try it without reading Dwain's article from earlier so this may not be the best way.
Basically I am joining to...
February 11, 2015 at 9:12 am
As Scott says, you should not need the isnull.
They were needed with the NOT IN because if a null value had been in the list, it would have messed up...
February 10, 2015 at 4:18 pm
Did you see the trick? Your brain forms clusters of letters and words called a bouma. They make reading faster than doing things letter-by-letter or word-by-word in a vertical column....
February 10, 2015 at 2:38 pm
First thing I'd check is whether it is using the same runtime (32 vs 64 bit).
A second question would be whether the oracle login being used is authorized only...
February 10, 2015 at 2:19 pm
Viewing 15 posts - 106 through 120 (of 600 total)