Viewing 15 posts - 1 through 15 (of 114 total)
To expand on what george said, does your primary key for the table include a lot of columns? The entire key for the table will be included in the...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 28, 2014 at 12:04 pm
Also, your question doesn't match the title of your post. did you miss a part of the question?
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 28, 2014 at 11:54 am
If you're only building one report, then I'd suggest working backwards from the requirements; _first_ figure out what you need the report top do, and _then_ decide what platform allows...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 28, 2014 at 11:46 am
In SQL Developer, there are a couple of options in the tools menu.
Monitor Sessions shows the results of the following query:
with vs as (select rownum rnum,
...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 26, 2014 at 2:03 pm
In sql server, it's generally better to refactor your subselects to a join. I don't know how much that applies to oracle. Will you be running this across...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 26, 2014 at 1:50 pm
This is a shot in the dark, but try the following:
SELECT
DS.LocationID
,M.InventoryItemID
,SUM(DS.OrderPrice * isnull((select count(w.startDate)
from dbo.Period m
where W.PeriodType=1
AND w.startDate...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
May 23, 2014 at 4:47 pm
In the end I could not fuigure out how to escape the reserved words (this has to be a bug in the driver??) but putting a view on the remote...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 4, 2013 at 2:30 pm
What Luis is hinting at is that unless you write code to create the sql statement you want to run each time, the number of columns in your output will...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 4, 2013 at 9:31 am
I corrected your syntax. Don't forget to place semicolons at the end of your statements or you'll get another error with the with statement.
WITH data AS(
SELECT *, ROW_NUMBER() OVER(...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 3, 2013 at 1:10 pm
I really have no idea what you are asking, since your procedure doesn't reference the tables you mention at all.
Do you mean you want to set the amount variable? ...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 3, 2013 at 12:46 pm
See the String Functions documentation here.
For splitting text into columns, you can use the following if the character width of the first two values is always the same:
select left(denormalizedColumn, 3)...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 3, 2013 at 12:38 pm
yes... Unfortunately I don't own the database in question.
Hopefully someone knows how to properly escape the names, or some other workaround.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
October 31, 2013 at 9:54 pm
I assume you've seen the openquery documentation here (which indicates the same restriction back to 2000)
So you know can still do the following?
EXEC [linked_server].[db].[schema].[xProc]
You can also create a local synonym...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
October 31, 2013 at 3:21 pm
Your example is what is called an inline table-valued function, and it works very similar to a view.
There is also a multi-statement table valued function that allows you to do...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
October 31, 2013 at 3:03 pm
Hi!
I don't really know the aswer to your problem, but thought I'd pop in anyway.
How does the next step in the process handle the dynamic nature of the output? ...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
October 30, 2013 at 2:58 pm
Viewing 15 posts - 1 through 15 (of 114 total)