Viewing 15 posts - 61 through 75 (of 114 total)
Unfortunately, there is no way to completely do what you're asking. You have three options:
You can define the list of available values in the second parameter to include only...
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.'
August 5, 2010 at 8:43 am
One simple way to do this is to simply set your datasource so that it returns all possible columns and set up your report to display based on this default...
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.'
July 26, 2010 at 12:56 pm
Not quite sure I understand exactly what you want. Do you want to build a report that shows a table of user selected columns from a list of available columns?...
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.'
July 23, 2010 at 12:08 pm
gary.strange-1058508 (7/22/2010)
I would agree that the article may leave...
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.'
July 22, 2010 at 5:35 pm
Grant Fritchey (7/22/2010)
magasvs (7/22/2010)
I new I will get incorrect answer 🙂I based my answer on sys.indexes "type" column:
Type of index:
0 = Heap
1 = Clustered
2 = Nonclustered
3 = XML
4 = Spatial
I...
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.'
July 22, 2010 at 11:51 am
Dan Guzman - Not the MVP (7/22/2010)
Many of you prove your point by quoting MS documentation, but others of you claim MS Documentation isn't good enough.
Which...
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.'
July 22, 2010 at 10:39 am
Edit whoops, I missed all the discussion on page two... I guess that's already covered...
I want to point out more forcefully than Tim did that these two queries are...
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.'
July 22, 2010 at 10:11 am
Unfortunately, there's no way to get a variable number of rows to columns. The best you can do from within TSQL is to choose a reasonable maximum number of...
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.'
July 22, 2010 at 9:51 am
For a different take on essentially the same question, see the discussion from May 21st
http://www.sqlservercentral.com/Forums/FindPost925652.aspx
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.'
July 22, 2010 at 9:25 am
When you say top 5, is five constant? or do you mean top X, like you said in your title?
If you're ok with having a fixed number of columns,...
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.'
July 16, 2010 at 9:57 am
In answer to your last question, how to pass the table-valued parameter when executing the procedure, you can create a table variable of the same type, put the data in...
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.'
July 16, 2010 at 9:15 am
I'm afraid I don't quite follow exactly what you're getting stuck on. Is it how to get the keys back from the rows you just entered? There have...
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.'
July 12, 2010 at 10:22 am
Assuming that you have access to the names from a separate table, and that the times are static, e.g. if there's a time in the morning, it will always be...
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.'
July 12, 2010 at 10:18 am
Sometimes the presentation layer is lacking. In ssrs2005, you'd have to jump through a lot of hoops to get this.
I'm assuming that there is no relationship between a particular...
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.'
July 7, 2010 at 9:57 am
Correct on all counts as usual Gail. A quick google tells me I wanted "internal fragmentation."
edit: here's a link: http://www.sqlservercentral.com/articles/Administration/fragmentation101/1346/
Here's a quick script that demonstrates what I was talking...
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.'
June 29, 2010 at 1:09 pm
Viewing 15 posts - 61 through 75 (of 114 total)