I saw a demo of a report using interactive sorting about a week ago. I can
not figure out though how to get this feature in my report. I believe the
video was of Brian Welcker' Does anyone have any advice on how todo this?
I am running a W2K3 Server and RS with all the latest SP's.
Thanks for any helpYou will need SQL Server 2005 CTP June for using the built-in interactive
sort. It is not available on RS 2000.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Jones" <ajones@.rheemac.com> wrote in message
news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>I saw a demo of a report using interactive sorting about a week ago. I can
>not figure out though how to get this feature in my report. I believe the
>video was of Brian Welcker' Does anyone have any advice on how todo this?
>I am running a W2K3 Server and RS with all the latest SP's.
> Thanks for any help
>|||Thank You for the help. So now I have a dumb question. What does CTP stand
for?
Thanks again!
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:ey92kc4eFHA.3040@.TK2MSFTNGP14.phx.gbl...
> You will need SQL Server 2005 CTP June for using the built-in interactive
> sort. It is not available on RS 2000.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Andy Jones" <ajones@.rheemac.com> wrote in message
> news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>>I saw a demo of a report using interactive sorting about a week ago. I can
>>not figure out though how to get this feature in my report. I believe the
>>video was of Brian Welcker' Does anyone have any advice on how todo
>>this? I am running a W2K3 Server and RS with all the latest SP's.
>> Thanks for any help
>|||CTP = Community Technology Preview.
See also: http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Jones" <ajones@.rheemac.com> wrote in message
news:OzcfckFfFHA.3912@.tk2msftngp13.phx.gbl...
> Thank You for the help. So now I have a dumb question. What does CTP
> stand for?
> Thanks again!
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:ey92kc4eFHA.3040@.TK2MSFTNGP14.phx.gbl...
>> You will need SQL Server 2005 CTP June for using the built-in interactive
>> sort. It is not available on RS 2000.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Andy Jones" <ajones@.rheemac.com> wrote in message
>> news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>>I saw a demo of a report using interactive sorting about a week ago. I
>>can not figure out though how to get this feature in my report. I believe
>>the video was of Brian Welcker' Does anyone have any advice on how todo
>>this? I am running a W2K3 Server and RS with all the latest SP's.
>> Thanks for any help
>>
>
Showing posts with label feature. Show all posts
Showing posts with label feature. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Interactive sort for a grouped table
I'm trying out the interactive sort feature (and have searched high and low for this answer), but can not make the sorting work if I have the data in the table grouped. If I remove the group, the sorting works fine but the output is not acceptable due to the duplicated records in the list.
Can someone steer me in the right direction?
I'm not really sure whether this is what you are looking for, but figured it is worth a try:
http://msdn2.microsoft.com/en-us/library/aa337431.aspx
See To add an interactive sort button on a group
Friday, March 9, 2012
Intellisense..when?
This is one of the top requested feature for next version (or SP) of SQL Server. (http://connect.microsoft.com/SQLServer/feedback ) There si some third parity tools but light years away from Visual Studio intellisense. I have only one simple question based on this answer
This is a very popular feature request. We will be working with teams across Microsoft to determine how best to do this. The intellisense offered by 3rd party ISVs is not perfect from what I've seen. This is something we're considering for a future release.
Thanks for the feedback!
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
When we can expect this feauture? (next version of SQL Server 
Thank you
In the mean time I'm using SQL Prompt which works pretty well.
http://geertverhoeven.blogspot.com/2007/01/intellisense-in-sql-server-management_18.html
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||It looks like we're going to earn a "
There are 3rd party tools available. I heard there were many issues in Red Gate's SQL Prompt 2 that were addressed with SQL Prompt 3. I have not used it myself.
Due to the inherent nature of the T-SQL language, it is far more difficult to make intellisense work as well as it does with C# or Visual Basic. There are two teams at Microsoft looking to address the problem. One is in the SQL Server team, the other is in the Visual Studio team. We do not have any official commitments to what is going to be in the next release of SQL Server ("Katmai"). Once we firmly establish what is in the next release and what isn't, we'll make sure to inform the SQL Server community.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
intellisense for QA?
VB.NET (actually VS.NET) has a feature called Intellisense that will display
methods/properties for an object once you type a dot. For example:
Object1.
At that point, you may see a list similar to:
- Compare
- GetType
- Parse
- ToString
which you can choose. No memorization required. Is there a plug-in or
something for QA that will do the above? For example, I might join two
tables:
select us.column1, mm.column1
from dbo.summary us JOIN
dbo.message mm
ON us.
When I type us., I'd like to see all the fields in that table. Any
suggestions?
Thanks,
Brett> Is there a plug-in or
> something for QA that will do the above?
No. And the feature was dropped from the next version because T-SQL isn't
written and organized in a way that suits intellisense, the way a more
structured programming language is. If you type SELECT you might expect a
drop-down to appear with all of the built-in aggregate functions,
user-defined functions and every single column in all views and tables in
the entire database. The kind of metadata retrieval required for this just
didn't make sense...
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
Check out some of the other tools written for writing/modifying T-SQL,
though I've never heard of one that accomplishes this. The tools that ship
with SQL Server won't have this feature for a while (if ever)...|||There is no plug in for QA. This feature has also been dropped, currently,
from SQL 2005. I would look for a third party tool for running queries to
solve this problem.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Brett" wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will displ
ay
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
>
>|||Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display methods/properties for an object once you type a dot. For
> example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in
> or something for QA that will do the above? For example, I might
> join two tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
Take a look at SQL IDE from Imceda. We offer autocomplete on objects.
14-day trial from web site.
David Gugick
Imceda Software
www.imceda.com|||Have a look at ApexSQL Edit (http://www.apexsql.com/). I bought this
some time ago and it's a pretty good product. Their support is very good
and you get free upgrades for ever, major and minor versions.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au
*** Sent via Developersdex http://www.examnotes.net ***|||We've added T-SQL Intellisense-like word-completion support for Visual
Studio 2003/2005 and the SQL Server 2005 Management Studio to our PromptSQL
product. So you can now have auto-completion for TSQL in those environments
and of course Query Analyzer.
SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting with
Em
SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all tables
related to the employees table (via primary/foreign keys)
SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
with possible joins based on primary/foreign keys on the tables in the FROM.
Press "." after a table name to get the columns in the table. It has proper
support for SQL Server 2005, which of course means prefixing table names
with schema names as appropriate.
Online demos and registration-free download: http://www.promptsql.com/
PromptSQL is written in C# and uses hooks to monitor Query Analyzer and the
other supported environments. You carry on using these standard tools.
Regards,
PromptSQL Team.
Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett|||your product is way
- however this is not the correct forum for these
types of post. Please post this in microsoft.public.sqlserver.tools.
Truly a fabulous product though.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Damian Mehers" <feedback at promptsql.com> wrote in message
news:O9hBnr1mFHA.3608@.TK2MSFTNGP15.phx.gbl...
> We've added T-SQL Intellisense-like word-completion support for Visual
> Studio 2003/2005 and the SQL Server 2005 Management Studio to our
PromptSQL
> product. So you can now have auto-completion for TSQL in those
environments
> and of course Query Analyzer.
> SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting
with
> Em
> SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all
tables
> related to the employees table (via primary/foreign keys)
> SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
> with possible joins based on primary/foreign keys on the tables in the
FROM.
> Press "." after a table name to get the columns in the table. It has
proper
> support for SQL Server 2005, which of course means prefixing table names
> with schema names as appropriate.
> Online demos and registration-free download: http://www.promptsql.com/
> PromptSQL is written in C# and uses hooks to monitor Query Analyzer and
the
> other supported environments. You carry on using these standard tools.
> Regards,
> PromptSQL Team.
>
>
> Brett wrote:
>
methods/properties for an object once you type a dot. For example:
Object1.
At that point, you may see a list similar to:
- Compare
- GetType
- Parse
- ToString
which you can choose. No memorization required. Is there a plug-in or
something for QA that will do the above? For example, I might join two
tables:
select us.column1, mm.column1
from dbo.summary us JOIN
dbo.message mm
ON us.
When I type us., I'd like to see all the fields in that table. Any
suggestions?
Thanks,
Brett> Is there a plug-in or
> something for QA that will do the above?
No. And the feature was dropped from the next version because T-SQL isn't
written and organized in a way that suits intellisense, the way a more
structured programming language is. If you type SELECT you might expect a
drop-down to appear with all of the built-in aggregate functions,
user-defined functions and every single column in all views and tables in
the entire database. The kind of metadata retrieval required for this just
didn't make sense...
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
Check out some of the other tools written for writing/modifying T-SQL,
though I've never heard of one that accomplishes this. The tools that ship
with SQL Server won't have this feature for a while (if ever)...|||There is no plug in for QA. This feature has also been dropped, currently,
from SQL 2005. I would look for a third party tool for running queries to
solve this problem.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Brett" wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will displ
ay
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
>
>|||Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display methods/properties for an object once you type a dot. For
> example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in
> or something for QA that will do the above? For example, I might
> join two tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
Take a look at SQL IDE from Imceda. We offer autocomplete on objects.
14-day trial from web site.
David Gugick
Imceda Software
www.imceda.com|||Have a look at ApexSQL Edit (http://www.apexsql.com/). I bought this
some time ago and it's a pretty good product. Their support is very good
and you get free upgrades for ever, major and minor versions.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au
*** Sent via Developersdex http://www.examnotes.net ***|||We've added T-SQL Intellisense-like word-completion support for Visual
Studio 2003/2005 and the SQL Server 2005 Management Studio to our PromptSQL
product. So you can now have auto-completion for TSQL in those environments
and of course Query Analyzer.
SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting with
Em
SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all tables
related to the employees table (via primary/foreign keys)
SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
with possible joins based on primary/foreign keys on the tables in the FROM.
Press "." after a table name to get the columns in the table. It has proper
support for SQL Server 2005, which of course means prefixing table names
with schema names as appropriate.
Online demos and registration-free download: http://www.promptsql.com/
PromptSQL is written in C# and uses hooks to monitor Query Analyzer and the
other supported environments. You carry on using these standard tools.
Regards,
PromptSQL Team.
Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett|||your product is way
- however this is not the correct forum for thesetypes of post. Please post this in microsoft.public.sqlserver.tools.
Truly a fabulous product though.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Damian Mehers" <feedback at promptsql.com> wrote in message
news:O9hBnr1mFHA.3608@.TK2MSFTNGP15.phx.gbl...
> We've added T-SQL Intellisense-like word-completion support for Visual
> Studio 2003/2005 and the SQL Server 2005 Management Studio to our
PromptSQL
> product. So you can now have auto-completion for TSQL in those
environments
> and of course Query Analyzer.
> SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting
with
> Em
> SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all
tables
> related to the employees table (via primary/foreign keys)
> SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
> with possible joins based on primary/foreign keys on the tables in the
FROM.
> Press "." after a table name to get the columns in the table. It has
proper
> support for SQL Server 2005, which of course means prefixing table names
> with schema names as appropriate.
> Online demos and registration-free download: http://www.promptsql.com/
> PromptSQL is written in C# and uses hooks to monitor Query Analyzer and
the
> other supported environments. You carry on using these standard tools.
> Regards,
> PromptSQL Team.
>
>
> Brett wrote:
>
Subscribe to:
Posts (Atom)