Viewing 15 posts - 1 through 15 (of 25 total)
Well, it's been 5 years and unfortunately I don't recall the specifics around the issue or how I went about fixing it, but short of your issue being a permissions...
December 6, 2015 at 12:25 pm
Yes, the registry change was on the server. I have access to do that, but not to the tnsnames. Go figure.
May 20, 2015 at 8:39 am
Here is what ended up working:
SELECT *
FROM OPENROWSET('OraOLEDB.Oracle'
,'server_ip_address:port_number/database'
...
May 20, 2015 at 8:16 am
Sure thing, see below (sorry about the weird formatting with the copy/paste):
SELECT DISTINCT TOP (100) PERCENT i.TABLE_CATALOG AS [database_name]
, i.TABLE_SCHEMA AS [schema_name]
, a.name AS [table_name]
, b.name AS [column_name]
, (CASE
WHEN...
May 19, 2014 at 12:39 pm
Yes, I want to completely disable their access except for certain days of the month. This will prevent them from accessing the db and running large queries against it while...
December 9, 2011 at 11:49 am
Wasn't trying to fool anyone, sorry about that! 😀
I'm not smart enough with SQL to understand the differences between the execution plans, but there ARE differences, that's for sure! Amazing...
August 11, 2011 at 1:25 pm
Good question on the results size...
The >=1 is actually 4x the volume of the <1 or =0.
August 11, 2011 at 12:47 pm
Let me add that it is a subquery, one of 2 subqueries in a query.
And running just the subquery it will run fine, but running the parent query, is when...
August 11, 2011 at 12:44 pm
Cool, thank you both, this looks like it's working!
July 27, 2011 at 9:22 am
Okay, now I tried using RANK with GSquared's query and removed my YYYYMM limitation of just 201106. It looked good, but I got 131 rows back...10 for every month except...
July 27, 2011 at 8:18 am
Here's what I mean on things getting ungrouped/summed:
YYYYMMP_TYPEP_DESCP_USERSP_CONTACTSP_CONTACTS_USER
201106Bagapples26383684272.59
201106Indoranges42661228330.54
201106Indpears27083145890.54
201106Bagapples14271007552710.53
201106Indlemons3211581617610.5
201106Baggrapes26162115970.44
201106Bagapples14413055874630.41
201106Indoranges42082166600.4
201106Bagapples6465532514450.39
201106Bagapples38655146360.38
That is a sample of the results I'm getting back. See how the apples and oranges are getting split out into multiple rows?...
July 27, 2011 at 7:46 am
That's where my problem is. I have the ROW_NUMBER function setup to look at the qty being >=25K, and I have it listing in descending order by the P_CONTACTS_USER, so...
July 27, 2011 at 6:34 am
GSquared...
That code unfortunately pulls back more than the top 10. I had to change it to the row number <=10 (perhaps I put that wrong in my initial code sample,...
July 26, 2011 at 1:05 pm
I guess I should have clarified again that if there are records that fall before/after the 4-day window that 3 or more calls occurred in, they would not be included...
April 12, 2011 at 1:03 pm
I tested your updated suggestion with a single phone number as a sample.
With the new structure I mentioned, the source table now has the following records for this particular test...
April 12, 2011 at 12:49 pm
Viewing 15 posts - 1 through 15 (of 25 total)