How to set user who cant modify any StoredProc and data in Tables but can read data in Tab

Please give me advise ????

Go into Management Studio, connect to your database and go to Security-->Users from the treeview. Right click and select New User. Create the use based on the relevant login and then go to the Securables option where you can add tables and stored procedures and select which rights the user will have.

How to set user who cant modify any StoredProc and data in Tables but can read data in Tab

Please give me advise ????

Go into Management Studio, connect to your database and go to Security-->Users from the treeview. Right click and select New User. Create the use based on the relevant login and then go to the Securables option where you can add tables and stored procedures and select which rights the user will have.

How to set two filters to be 'Or' relation?

I have two or more filters for a metrix, but I found the 'And/Or' column is
disable in filter tab of Matrix properties Dialog.
In addition, the filters element in RDL is defined here:
<Filters>
<Filter Name"...">...</Filter>
</Filters>
If there are two filters, the default relation is 'And', but how to set the
'Or' relation? Does Report Service itself only support 'And' relation for
report filter?
Thanks in advance.All filter expressions within filter are related by "And"
"Or" is used by UI to represent operator "In".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xie Zheng" <XieZheng@.discussions.microsoft.com> wrote in message
news:B76542ED-207A-4CCF-8D28-BB8665EF8F61@.microsoft.com...
>I have two or more filters for a metrix, but I found the 'And/Or' column is
> disable in filter tab of Matrix properties Dialog.
> In addition, the filters element in RDL is defined here:
> <Filters>
> <Filter Name"...">...</Filter>
> </Filters>
> If there are two filters, the default relation is 'And', but how to set
> the
> 'Or' relation? Does Report Service itself only support 'And' relation for
> report filter?
> Thanks in advance.|||Please check this related newsgroup thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=ba53b4b7-cffc-4851-af9f-5e6eb48b1b1c&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xie Zheng" <XieZheng@.discussions.microsoft.com> wrote in message
news:B76542ED-207A-4CCF-8D28-BB8665EF8F61@.microsoft.com...
> I have two or more filters for a metrix, but I found the 'And/Or' column
is
> disable in filter tab of Matrix properties Dialog.
> In addition, the filters element in RDL is defined here:
> <Filters>
> <Filter Name"...">...</Filter>
> </Filters>
> If there are two filters, the default relation is 'And', but how to set
the
> 'Or' relation? Does Report Service itself only support 'And' relation for
> report filter?
> Thanks in advance.

How to set Tab as column separator in SQL*Plus?

Any advice or workarounds, greatly appreciated.
Cheers,
PeiOriginally posted by peisiong
Any advice or workarounds, greatly appreciated.

Cheers,

Pei
You could do this:

SQL> column tab new_value tab
SQL> select chr(9) tab from dual;

T
-


SQL> set colsep "&tab"|||[QUOTE][SIZE=1]Originally posted by andrewst
Thanks Andrew!!!|||Hi

I have done what you have suggested and the spooled file looks ok when I open it in EXCEL.

But when I open it in a text editor, there seems to be spaces (lots of them) in place of tab.

Any idea why?

Cheers,

Pei Siong|||Originally posted by peisiong
Hi

I have done what you have suggested and the spooled file looks ok when I open it in EXCEL.

But when I open it in a text editor, there seems to be spaces (lots of them) in place of tab.

Any idea why?

Cheers,

Pei Siong
There are spaces, as well as the delimiting TABs, because of the way SQL Plus formats the data WITHIN the columns, e.g.:

____DEPTNO|DNAME_________|LOC_________
----|-----|----
________10|ACCOUNTING____|NEW_YORK____
________20|RESEARCH______|DALLAS______
________30|SALES_________|CHICAGO_____
________40|OPERATIONS____|BOSTON______

(I have changed spaces to '_' and tabs to '|' so you can see better).

I'm not aware of any way to change this behaviour. A common way to get tab-delimited output without spaces is to select it that way:

SELECT deptno||CHR(9)||dname||CHR(9)||loc AS record
FROM dept;

RECORD
---------------------
10|ACCOUNTING|NEW YORK
20|RESEARCH|DALLAS
30|SALES|CHICAGO
40|OPERATIONS|BOSTON

Use SET TRIMSPOOL ON to remove the trailing spaces on the last column.|||Hi andrew,

Thanks for your help. If I have 100+ columns in my select statement, will using concatenate affect the performance of the select?

Cheers,

Pete|||Originally posted by peisiong
Hi andrew,

Thanks for your help. If I have 100+ columns in my select statement, will using concatenate affect the performance of the select?

Cheers,

Pete
Not as far as I know.