"Roy Goldhammer" <roygoldh@012.net.il> wrote in message
news:uUPtVAbaDHA.2256@TK2MSFTNGP10.phx.gbl...
> Hello there
>
> I have a query that i need to enter to table
>
> The query is crossib (Pivot)
>
> and the data should enter for two tables: tbl1(ID - primary key, other)
> tbl2(ID- Foreign Key from from tbl1, ColName - the columns on the crossib
> query) both of them are Primary key and data
>
> How can i enter this type of data witn Transact Sql?
>
> Any help would be useful
>
>
>

"Roy Goldhammer" <roygoldh@012.net.il> wrote in message
news:OqdnS6baDHA.388@TK2MSFTNGP10.phx.gbl...
> Well John
>
> I don't know if i explain my self clear before
>
> I have a case that i need to present the data in crossib mode and then
store
> it in table
>
> There fore i can't use one table so i need two tables like the example i
> gave you
>
> The question is how can i store the data on the two tables in this case?
>
> From my knowladge i can only do this with cursors which is as i learn
> somthing that don't suggested at all
>
> can you help me on it? i
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3f47cb17$0$10770$afc38c87@news.easynet.co.uk...
> > Hi
> >
> > If your data is in a SQL Server database, you would enter the data into
> each
> > table separately. To produce a crosstab query check out the following
> > article and links. You may also want to check out google.
> >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23GZCh7fTBHA.224%40
> tkmsftngp07
> >
> > John
> >
> > "Roy Goldhammer" <roygoldh@012.net.il> wrote in message
> > news:uUPtVAbaDHA.2256@TK2MSFTNGP10.phx.gbl...
> > > Hello there
> > >
> > > I have a query that i need to enter to table
> > >
> > > The query is crossib (Pivot)
> > >
> > > and the data should enter for two tables: tbl1(ID - primary key,
other)
> > > tbl2(ID- Foreign Key from from tbl1, ColName - the columns on the
> crossib
> > > query) both of them are Primary key and data
> > >
> > > How can i enter this type of data witn Transact Sql?
> > >
> > > Any help would be useful
> > >
> > >
> > >
> >
> >
>
>

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3f47cb17$0$10770$afc38c87@news.easynet.co.uk...
> Hi
>
> If your data is in a SQL Server database, you would enter the data into
each
> table separately. To produce a crosstab query check out the following
> article and links. You may also want to check out google.
>
>

>
> John
>
> "Roy Goldhammer" <roygoldh@012.net.il> wrote in message
> news:uUPtVAbaDHA.2256@TK2MSFTNGP10.phx.gbl...
> > Hello there
> >
> > I have a query that i need to enter to table
> >
> > The query is crossib (Pivot)
> >
> > and the data should enter for two tables: tbl1(ID - primary key, other)
> > tbl2(ID- Foreign Key from from tbl1, ColName - the columns on the
crossib
> > query) both of them are Primary key and data
> >
> > How can i enter this type of data witn Transact Sql?
> >
> > Any help would be useful
> >
> >
> >
>
>