What makes you think the data is also in the primary file group?

I borrowed this code from somewhere and I use it to look at partitions. It should show you...

Hopefully there are no non-ansi outer joins in the app code, as setting the compatibility mode doesn't make discontinued features work again.

Do you know how the ssis packages are expected...

Either use the CASE statement or NVL. I think this is the right CASE syntax for oracle.

SELECT CASE OPS_FUNDING_DETAILS.REQUESTED_TOT_AMT
        ...

This looks like an Oracle query.

What data type is CONST_EST_AMT? If it is numeric the query may work if you remove the single quotes from '0.00' or cast it to...

I had not see that before. Very good, but I think the lines need to be in the cloud.

I know you have an answer, but this may be one of the few cases where EXCEPT will give you what you need. Normally there are additional columns needed which...

What is the event_type of those suspect pages? Could they have been fixed already?

Why do you need to run the query six times for nine months? Do you need a count by month, rather than a total ytd count? Does the ExecuteDate need...

All your date time values are the same, except for the second instance of p1 for 3333. How do you define which is the "first" row for a vid? Do...

This is a rudimentary solution, but you can create a function that returns a 1 if the values meet the rule, and add a check constraint that the result of...

Do you have any null or empty string IFSC values?

Fun with Steve's answer:

His comments on the correct answer has a somewhat minor error, but for the fun of all of us, I'm not going to state it here,...

If you filter the right side of a left outer join using WHERE, the filter is...

SELECT circuits.name AS circuit_name
 ,circuits.location
 ,circuits.country
 ,races.name AS race_name
 ,races.round
FROM circuits
LEFT OUTER JOIN races on circuits.circuit_id = races.circuit_id
AND races.race_year = 2009
WHERE circuits.circuit_id < 70

There are no races...

• This reply was modified 3 years ago by Ed B.

The query works fine with the sample data. Do you have another example you can provide in a consumable form? Are you sure you're not grouping by SKU? The image...