Showing posts with label group. Show all posts
Showing posts with label group. Show all posts

Monday, March 26, 2012

IS it possible to insert a blank line in my report

Hello,

I my dataset is like following

sql:

select quarter, sum(amount) as amount from table1 group by quarter

then I get the dataset

field: quarter,amount

date: quarter1,100

quarter2,500

Is it possible to get my report from the dataset above.

my report:

quarter,amount

quarter1,100

quarter2,500

quarter3,0

quarter4,0

thanks!

This is possible if you have a time (or quarter) table in your database:

SELECT

q.quarter,

ISNULL(t1.amount,0) as amount

FROM quarters q

LEFT JOIN table1 t1

ON q.quarter = t1.quarter

|||

thank you for reply

I can't get the tabe quarters ...

|||

Use this SQL:

SELECT

q.quarter,

ISNULL(t1.amount,0) as amount

FROM quarters q LEFT JOIN

(SELECT 'quarter1' AS quarter UNION SELECT 'quarter2' AS quarter UNION SELECT 'quarter3' AS quarter UNION SELECT 'quarter4' AS quarter) AS qrt

ON quarters.quarter = qrt.quarter

This will work.

Please mark the post as answer.

Shyam

|||


In order to more easily manage date groupings (weeks, months, quarters, years, etc.) it is a VERY good idea to have a Calendar table in your database. Having a Calendar table makes tasks such as this one very simple.


Here is additional information about creating and using a Calendar table.

Datetime -Calendar Table
http://www.aspfaq.com/show.asp?id=2519

Is it possible to hide a field or fields based on User Groups?

RS 2000

I have a report that has a few sensitive fields and would only like to show them to a certain AD group.

Is this possible?
Hi,

sure this is possible through custom .NET code. Implement your own Active Driectory checking class and use that within reporting Services. Based on this class you can make the textbox Visible or Hidden.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

is it possible to group calculated measures?

There are a lot of calculated measures on my cube. Is it possible to group calculated measure in

folders like you can group attibutes of dimensions?

Yes it is possible. You will find it if you mark the small calculation properties button in the calculation tab in the cube editor.

HTH

Thomas Ivarsson

Wednesday, March 21, 2012

Is it possible to connect a SQL server database to any NNTP se

Hi
How to write a NNTP server in VC2005 is mainly a VC2005 issue so you may
want to post to a more appropriate group. There are many examples of using
VC++ and data access include in the SQL server examples and VC++ examples.
John
"J.S." wrote:

> Hi John,
>
> Yes, I think so. However, I am not sure which books I need to read or whi
ch
> sections of MSDN I need to refer to for learning how to create such server
> applications.
>
> I have been using Lyris ListManager for many years which already has this
> functionality. However, I am just learning VS 2005 so I thought a good wa
y
> to learn would be to try to create such an application on my own.
> Thanks,
> J.S.
>
>Thanks, John.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B013D771-360D-4548-B2CD-D09A70651F94@.microsoft.com...
> Hi
> How to write a NNTP server in VC2005 is mainly a VC2005 issue so you may
> want to post to a more appropriate group. There are many examples of using
> VC++ and data access include in the SQL server examples and VC++ examples.
> John

Monday, March 12, 2012

Is it possible ?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnmq$32b$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
Don't multi-post. See response in .server.
David|||If you are using user rights with an application and not an application
role, then there is no way for the server to differentiate between a
user using product x or product y; it simply sees a request for data
from a user.
However, if your application can be re-tooled to use an application
role instead, then that changes things drastically. Of course, that
limits your applications ability to inherit from Active Directory, so
it may not be a viable solution.
Stu

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m.
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David
|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.
|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegr oups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>
|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in th
e
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables
from which you check
the application name (APP_NAME()) and if not expected, you rollback inside t
he trigger. This will
not prevent a bad seed from writing an app, setting the expected application
name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> > Hi
> >
> > I have users in domain group who use application which uses sqlserve, they
> > have rights to insert, update, delete. I want some of the members of this
> > domain group to connect directly to the database using query analyzer but
> > with right only to read and they still of course can use application and
> > have full rights.
> >
> > I can't change application, i don't want to crate another users with
> > different rights.
> >
> > I want the same user to have different rights using application and query
> > analyzer.
> > Is it possible ? Maybe something similar...
> >
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
>> "marta" <marta20wawa@.go2.pl> wrote in message
>> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
>> > Hi
>> >
>> > I have users in domain group who use application which uses sqlserve, they
>> > have rights to insert, update, delete. I want some of the members of this
>> > domain group to connect directly to the database using query analyzer but
>> > with right only to read and they still of course can use application and
>> > have full rights.
>> >
>> > I can't change application, i don't want to crate another users with
>> > different rights.
>> >
>> > I want the same user to have different rights using application and query
>> > analyzer.
>> > Is it possible ? Maybe something similar...
>> >
>> In this situation users should be granted Read permissions only, and in the
>> application, they can acquire different permissions by running
>> sp_setapprole.
>> David
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Friday, March 9, 2012

Is it best practice to put both the SQL & MSDTC groups on the same node?

In Rodney R. Fournier's blog it states:
"If MSDTC is used with SQL, you should ensure it is in it's own group,
on it's own disk resource. Lastly, Microsoft recommends to run the
MSDTC & SQL group on the same node, and that the MSDTC is brought
online first when the groups are moved."
("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
I have a couple of questions about this but let first list my
assumptions.
Best:
For high performance, installing an MSDTC Resource to it in its own
group. This group should have its own disk and IP resources.
Good:
The next best method is to put the MSDTC resource in the cluster or
quorum group.
Worse:
Put the MSDTC resource in SQL Group.
What are the reasons for running the MSDTC & SQL group on the same
node, beyond these potential Win2003 cluster issues listed in:
http://support.microsoft.com/default...b;en-us;889706
http://support.microsoft.com/kb/821751/
?
If DTC is in the quorum group is it still best to put SQL and quorum
group on the same node?
Our system admin is religious about putting the SQL group on a
different node from the Quorum & DTC groups. Is there a best practice
here or a KB I can point to?
Are there any implications not having SQL dependent of MSDTC starting
first (MSDTC is brought online first when the groups are moved)
beyond the possibility of not being able to start a distributed
transaction?
Replies below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126723915.556530.64310@.g44g2000cwa.googlegro ups.com...
> In Rodney R. Fournier's blog it states:
> "If MSDTC is used with SQL, you should ensure it is in it's own group,
> on it's own disk resource. Lastly, Microsoft recommends to run the
> MSDTC & SQL group on the same node, and that the MSDTC is brought
> online first when the groups are moved."
> ("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
> I have a couple of questions about this but let first list my
> assumptions.
> Best:
> For high performance, installing an MSDTC Resource to it in its own
> group. This group should have its own disk and IP resources.
>
Correct.

> Good:
> The next best method is to put the MSDTC resource in the cluster or
> quorum group.
>
Correct.

> Worse:
> Put the MSDTC resource in SQL Group.
>
Yuck! Correct.

> What are the reasons for running the MSDTC & SQL group on the same
> node, beyond these potential Win2003 cluster issues listed in:
> http://support.microsoft.com/default...b;en-us;889706
> http://support.microsoft.com/kb/821751/
> ?
>
Correct, pre SP1 for Windows Server 2003 MSDTC has issues! Lots of issues.
The Q is correct.

> If DTC is in the quorum group is it still best to put SQL and quorum
> group on the same node?
>
If you can, yes!

> Our system admin is religious about putting the SQL group on a
> different node from the Quorum & DTC groups. Is there a best practice
> here or a KB I can point to?
>
http://support.microsoft.com/default...b;en-us;889706
Remember, SQL does not require MSDTC. You only need it if you application
will use it.

> Are there any implications not having SQL dependent of MSDTC starting
> first (MSDTC is brought online first when the groups are moved)
> beyond the possibility of not being able to start a distributed
> transaction?
>
Isn't that enough?
|||What are the arguments against these types of statements?
Having Quorum & DTC groups on a different node than the SQL group
a) has a load balancing effect, i.e. the SQL group will have the full
physical resources of the node.
b) enables the failover of SQL group happen be quicker cause Quorum &
DTC groups are already on the failover node.
|||http://support.microsoft.com/default...b;en-us;889706 pretty much
covers it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
> What are the arguments against these types of statements?
> Having Quorum & DTC groups on a different node than the SQL group
> a) has a load balancing effect, i.e. the SQL group will have the full
> physical resources of the node.
> b) enables the failover of SQL group happen be quicker cause Quorum &
> DTC groups are already on the failover node.
>
|||I had this problem, MSTDC not available so I put MSDTC in the same group as
SQLServer AND made SQLServer dependant on MSDTC Works fine now.
Nik Marshall-Blank MCSD/MCDBA
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23sx340fuFHA.3188@.TK2MSFTNGP14.phx.gbl...
> http://support.microsoft.com/default...b;en-us;889706 pretty much
> covers it.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Sean" <spowell71@.hotmail.com> wrote in message
> news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
>

Friday, February 24, 2012

is first item in the group

Hi all,
I have the report layout like this:
Group1
Item1
Item2
...
Group2
Item1
Item2
...
...
I would like to alternate the background color on Items and Item1 always
starts with the same color and alternate from there for the rest of the
items in that group. How can I do it? I use IIF(RowNumber(Nothing), color1,
color2) but it does not work with item1 being the same color for every
group. Please advice. Thanks.I got it. Thanks.
"testing" <@.hotmail.com> wrote in message
news:%23MVQfSzIFHA.732@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I have the report layout like this:
> Group1
> Item1
> Item2
> ...
> Group2
> Item1
> Item2
> ...
> ...
> I would like to alternate the background color on Items and Item1 always
> starts with the same color and alternate from there for the rest of the
> items in that group. How can I do it? I use IIF(RowNumber(Nothing),
color1,
> color2) but it does not work with item1 being the same color for every
> group. Please advice. Thanks.
>