No EM/Query Builder to access SQL Server on SQL Server 2005?

Hello
Since there is no Enterprise Manager to access Query Builder how do you
access Query Builder on Sql Server 2005In SSMS: Query-->Design Query in Editor
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"winlin" <winlin@.verizon.com> wrote in message
news:05C6CE07-E60F-47BA-AED6-7EC02534C716@.microsoft.com...
> Hello
> Since there is no Enterprise Manager to access Query Builder how do you
> access Query Builder on Sql Server 2005

No BI Dev Studio after install of Dev edition

I recently installed the Developerâ's edition of SQL Server 2005 so I could
check out the report builder.
After installing on a XP Pro workstation, I looked and it doesnâ't appear to
have installed the Business Intelligence Developer Studio.
Is this not included in the Dev Edition?
Thanks in advance.Are you sure that you selected the option to install workstation components,
books online and development tools. If you did not, BIDS will not be
installed.
Ed.
"rstevens" <rstevens@.discussions.microsoft.com> wrote in message
news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
>I recently installed the Developer's edition of SQL Server 2005 so I could
> check out the report builder.
> After installing on a XP Pro workstation, I looked and it doesn't appear
> to
> have installed the Business Intelligence Developer Studio.
> Is this not included in the Dev Edition?
> Thanks in advance.
>|||I could have sworn that I told it to install the dev tools, but apparently
hadn't.
Thanks, that was it.
"Ed Allison" wrote:
> Are you sure that you selected the option to install workstation components,
> books online and development tools. If you did not, BIDS will not be
> installed.
> Ed.
> "rstevens" <rstevens@.discussions.microsoft.com> wrote in message
> news:DDE881F0-1682-4B8C-B349-C99EAC4B7D02@.microsoft.com...
> >I recently installed the Developer's edition of SQL Server 2005 so I could
> > check out the report builder.
> >
> > After installing on a XP Pro workstation, I looked and it doesn't appear
> > to
> > have installed the Business Intelligence Developer Studio.
> >
> > Is this not included in the Dev Edition?
> >
> > Thanks in advance.
> >
>
>

No available values in Report Builder parameter

In a Report builder report I have runtime prompt filter on a field.
But I am not able to see the available values in the dropdown for this field.
My filter is on a "New Field" with the formula :
IF(LENGTH(FieldName)>0,FieldName,("Blank"))

However if my filter is on the FieldName directly and not on the New Field with the above formula I do get the available values.
Is there any way I can get the available values in a dropdown for the New Field?

In Model Designer, add the "New Field" formula as a new attribute to the entity. Then set ValueSelection of the attribute to be dropdown.|||

True any field which is present in the Model can be shown in the dropdown.

I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response.

sql

No available values in Report Builder parameter

In a Report builder report I have runtime prompt filter on a field.
But I am not able to see the available values in the dropdown for this field.
My filter is on a "New Field" with the formula :
IF(LENGTH(FieldName)>0,FieldName,("Blank"))

However if my filter is on the FieldName directly and not on the New Field with the above formula I do get the available values.
Is there any way I can get the available values in a dropdown for the New Field?

In Model Designer, add the "New Field" formula as a new attribute to the entity. Then set ValueSelection of the attribute to be dropdown.|||

True any field which is present in the Model can be shown in the dropdown.

I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response.

No "Left" function in Expression Builder?

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

DannoCoy wrote:

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

No. Annoying isn't it?

Instead you can use REVERSE(RIGHT())

-Jamie

|||I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.|||

DarrenSQLIS wrote:

I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.

Oh you're so picky :)