AM PM format

How can I show time portion of a date in "hh:mm:ss" AM?PM format?
ThanksIn the format property for a textbox use the following:
hh:mm:ss tt
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>
>|||What Language setting have you used on the Report?
Click on the Report Property and look for Language. Set it to English
(United States)
Then click on a textbox with a time datatype in, and set T as format. Now
you have am/pm.
If you don't want to change the language of the whole report, you'll have to
use some formating function on the expression. Or change the format in your
query, to make it return the time in the correct format from your data
source.
Kaisa M. Lndahl Lervik
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:utU3$sP3GHA.3428@.TK2MSFTNGP05.phx.gbl...
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>

Am I being role happy?

I'm working on the security portion of this vb app. In the application the
user is presented with a list of commands that can be executed on a piece of
data.

My client wants to be able to block certain users from seeing certain
commands on their screen.

The commands are loaded into a listview from a table.

I've created a role for each combination of command/province(A user may be
able to execute a command on an Ontario piece of data but not a Quebec
piece).

I just modified the query that loads the list box so that it includes an
IS_Member with the command/province combination.

The roles were easy to create(sql query to create the sp_addrole commands).
And the query modifications were easy as well. Is_Member barely affects
query times(very fast).

I've also created roles that contain these roles so a user only has to be
added to one role to get access to large groups of commands.

I may have one problem though. I've created hundreds of roles on the
server. Is that a problem? Can anyone tell me if there's a better way of
doing this?

Thanks in advance.
J
P.S. The application has just under 500 users and is going to hit 1000 in a
couple of years.Me (me@.here.com) writes:
> I've created a role for each combination of command/province(A user may be
> able to execute a command on an Ontario piece of data but not a Quebec
> piece).
> I just modified the query that loads the list box so that it includes an
> IS_Member with the command/province combination.
> The roles were easy to create(sql query to create the sp_addrole
> commands).
> And the query modifications were easy as well. Is_Member barely affects
> query times(very fast).
> I've also created roles that contain these roles so a user only has to be
> added to one role to get access to large groups of commands.
> I may have one problem though. I've created hundreds of roles on the
> server. Is that a problem? Can anyone tell me if there's a better way of
> doing this?

The one thing that I don't really like this design is that you use
SQL Server's own mechanisms to control data access within the
application. I would prefer to have my own authorization tables.
This design can confuse a DBA who thinks roles are for control access
to tables and T-SQL commands.

Then again, if it ain't broke...

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Alternative to SQL Server Management Studio?

Not sure that all of these are working in 2005, or even that they all still
exist. But a good portion should.
http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<pshroads@.gmail.com> wrote in message
news:1180474299.187491.174550@.j4g2000prf.googlegro ups.com...
> Does anyone have any suggestions for 3rd party tools to replace SQL
> Server Management Studio. SMS is such bloatware and lacks so many nice
> features of Enterprise Manager that there must be some decent tools
> out there to use instead. I know there's Microsoft SQL Server
> Management Studio Express but it doesn't manage SQL Server Agent.
> Thanks!
>
I am partial to ApexSQL Edit for development (AMAZING range of features,
with incredible developer support/involvment). I use DBArtisan for admin,
but have been disappointed with their quality the last few years. WAY too
many bugs and 'special features', IMHO. However, if you are a
multi-platform shop Embarcadero is probably THE way to go.
TheSQLGuru
President
Indicium Resources, Inc.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OYigWukoHHA.716@.TK2MSFTNGP05.phx.gbl...
> Not sure that all of these are working in 2005, or even that they all
> still exist. But a good portion should.
> http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> <pshroads@.gmail.com> wrote in message
> news:1180474299.187491.174550@.j4g2000prf.googlegro ups.com...
>