Matrix - Create two rows in a matrix

Hello.
I hope to explain myself well - I want to make a matrix with two rows.
Lats say my data is this:
I hava a list of months and in every month I have a number of pepole
and there age.
How can I show this in a matrix?
It need to be in a matrix since I need the columns to expand acording
to the month but I don't know how to create two diffrent rows in my
matrix.
The data should look like this:
10/06 11/06 12/06 01/07 02/07 03/7
04/07 ....
num 5 1 2 5 4
5 7 ....
age 16.1 25 18.5 14.8 25.5
20.5 18.5 ....
Thanks for any help.On Nov 26, 7:18 am, nicknack <roezo...@.gmail.com> wrote:
> Hello.
> I hope to explain myself well - I want to make a matrix with two rows.
> Lats say my data is this:
> I hava a list of months and in every month I have a number of pepole
> and there age.
> How can I show this in a matrix?
> It need to be in a matrix since I need the columns to expand acording
> to the month but I don't know how to create two diffrent rows in my
> matrix.
> The data should look like this:
> 10/06 11/06 12/06 01/07 02/07 03/7 04/07 ....
> num 5 1 2 5 4 5 7 ....
> age 16.1 25 18.5 14.8 25.5 20.5 18.5 ....
> Thanks for any help.
Right-click on the Details section of the matrix, and go to Add Row.
Drag your second DataSet field into this new area. It will
automatically create the "num" and "age" row titles as a new static
Group, and these can be renamed like any other field.
-- Scott|||Hi Scott,
Thanks for the help.
Thats exactly what I needed.
I was sure, for some reason that this option will add another group
and not another simple row.
Thanks again,
Roy.
On 26 =D7=A0=D7=95=D7=91=D7=9E=D7=91=D7=A8, 21:33, Orne <polysilly...@.yahoo.=com> wrote:
> On Nov 26, 7:18 am, nicknack <roezo...@.gmail.com> wrote:
>
> > Hello.
> > I hope to explain myself well - I want to make a matrix with two rows.
> > Lats say my data is this:
> > I hava a list of months and in every month I have a number of pepole
> > and there age.
> > How can I show this in a matrix?
> > It need to be in a matrix since I need the columns to expand acording
> > to the month but I don't know how to create two diffrent rows in my
> > matrix.
> > The data should look like this:
> > 10/06 11/06 12/06 01/07 02/07 03/7 04/07= ....
> > num 5 1 2 5 4 5 = 7 ....
> > age 16.1 25 18.5 14.8 25.5 20.5 =18.5 ....
> > Thanks for any help.
> Right-click on the Details section of the matrix, and go to Add Row.
> Drag your second DataSet field into this new area. It will
> automatically create the "num" and "age" row titles as a new static
> Group, and these can be renamed like any other field.
> -- Scott

Matching fileds between two tables

I hope I can explain this a little better. I have two tables that I need
information from. The first table has all but two fields that I need. I am
having two problems. First all I want to do is read the first table take the
part number and check the second table. If it is not there I want print the
information from the table and continue on reading the first table and if it
is there I want to take the invoice and print it with the information from
the first table. The second problem is the part number in the second table
is part of a large field(132 bytes). It is always at the same postion 10
bytes in the field
It sounds like you'll want an outer join. Example:
SELECT T1.col1, T1.col2, T1.part_num, T2.col1, T2.col2
FROM Table1 AS T1
LEFT OUTER JOIN Table2 AS T2
ON T1.part_num = SUBSTRING(T2.large_col, 10, 5) ;
David Portas
SQL Server MVP
"Daniell" <Daniell@.discussions.microsoft.com> wrote in message
news:E1187FC7-9EA8-4EEE-B142-ECFA9807991A@.microsoft.com...
>I hope I can explain this a little better. I have two tables that I need
> information from. The first table has all but two fields that I need. I
> am
> having two problems. First all I want to do is read the first table take
> the
> part number and check the second table. If it is not there I want print
> the
> information from the table and continue on reading the first table and if
> it
> is there I want to take the invoice and print it with the information from
> the first table. The second problem is the part number in the second
> table
> is part of a large field(132 bytes). It is always at the same postion 10
> bytes in the field
|||Thanks I will give that a try.
"David Portas" wrote:

> It sounds like you'll want an outer join. Example:
> SELECT T1.col1, T1.col2, T1.part_num, T2.col1, T2.col2
> FROM Table1 AS T1
> LEFT OUTER JOIN Table2 AS T2
> ON T1.part_num = SUBSTRING(T2.large_col, 10, 5) ;
> --
> David Portas
> SQL Server MVP
> --
> "Daniell" <Daniell@.discussions.microsoft.com> wrote in message
> news:E1187FC7-9EA8-4EEE-B142-ECFA9807991A@.microsoft.com...
>
>

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards
I don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/A...8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards
|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regardsI don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/.../8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx
.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regardsI don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/Article/ArticleID/8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:
>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards