Generating Record number for a result set?

Hi gurus;
any body would like to tell how to generate row numbers with a qurery?
thanks in advance
AnsariHi,
see the below link:-
http://www.sqlteam.com/item.asp?ItemID=1491
Thanks
Hari
MCDBA
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:#zj5Kp5cEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi gurus;
> any body would like to tell how to generate row numbers with a qurery?
> thanks in advance
> Ansari
>|||... and along the same lines:
http://www.databasejournal.com/features/mssql/article.php/10894_3373861_1
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Hari Prasad wrote:
> Hi,
> see the below link:-
> http://www.sqlteam.com/item.asp?ItemID=1491
>
> Thanks
> Hari
> MCDBA
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:#zj5Kp5cEHA.1000@.TK2MSFTNGP12.phx.gbl...
>>Hi gurus;
>>any body would like to tell how to generate row numbers with a qurery?
>>thanks in advance
>>Ansari
>>
>
>

Generate Script including Data

Hello Group:
Is there any way of generate a script which include data and database
structure in SQL SERVER 2000?
Thanks in advance.
Armandohttp://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Armando Ruiz" <armando-ruiz@.telefonica.net> wrote in message
news:OfzTF$7AFHA.1992@.TK2MSFTNGP10.phx.gbl...
> Hello Group:
> Is there any way of generate a script which include data and database
> structure in SQL SERVER 2000?
> Thanks in advance.
> Armando
>|||Hi Armando,
Would you be able to tell us the exact purpose? There are other better ways
to do it.
--
Thanks
Yogish|||Hello and thanks for your quick answers.
I've to update a remote MSDE database, creating 4 new tables and inserting
data.
I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
that database only by 1 step.
Thanks again
Armando
"Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> Hi Armando,
> Would you be able to tell us the exact purpose? There are other better
ways
> to do it.
> --
> Thanks
> Yogish|||check out DB Ghost - http://www.dbghost.com for scripting, building,
comparing and synchronizing both schema and data optionally using Source
control.
"Armando Ruiz" wrote:
> Hello and thanks for your quick answers.
> I've to update a remote MSDE database, creating 4 new tables and inserting
> data.
> I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
> that database only by 1 step.
> Thanks again
> Armando
>
> "Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
> news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> > Hi Armando,
> >
> > Would you be able to tell us the exact purpose? There are other better
> ways
> > to do it.
> >
> > --
> > Thanks
> > Yogish
>
>|||Thanks for the reply .
"mark baekdal" <markbaekdal@.discussions.microsoft.com> escribió en el
mensaje news:8F801F86-AD4A-4D1C-90CA-4CC4619D86FB@.microsoft.com...
> check out DB Ghost - http://www.dbghost.com for scripting, building,
> comparing and synchronizing both schema and data optionally using Source
> control.
> "Armando Ruiz" wrote:
> > Hello and thanks for your quick answers.
> >
> > I've to update a remote MSDE database, creating 4 new tables and
inserting
> > data.
> >
> > I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
> > that database only by 1 step.
> >
> > Thanks again
> >
> > Armando
> >
> >
> >
> > "Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
> > news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> > > Hi Armando,
> > >
> > > Would you be able to tell us the exact purpose? There are other better
> > ways
> > > to do it.
> > >
> > > --
> > > Thanks
> > > Yogish
> >
> >
> >

Generate report using XML as data source

Hi
How can I generate report using XML file as Datasource?
And I need to pass XML Filename dynamically at run-time..
--
Thanks in advance
BhaveshToday you have to write a data extension. In the future (Yukon) there will
be controls that can be used and it should be significantly easier to do
this sort of thing (load a dataset with the xml data and pass that to the
control).
Bruce L-C
"Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> Hi
> How can I generate report using XML file as Datasource?
> And I need to pass XML Filename dynamically at run-time..
> --
> Thanks in advance
> Bhavesh|||Pass to which Control?
I am reading XML data in dataset, in my asp page and passing it to Crystal
report control..and everything is working fine..
But I want to do this using SQL Server reporting service..
How can I do this?
Thanks
Bhavesh
"Bruce Loehle-Conger" wrote:
> Today you have to write a data extension. In the future (Yukon) there will
> be controls that can be used and it should be significantly easier to do
> this sort of thing (load a dataset with the xml data and pass that to the
> control).
> Bruce L-C
> "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > Hi
> > How can I generate report using XML file as Datasource?
> >
> > And I need to pass XML Filename dynamically at run-time..
> >
> > --
> > Thanks in advance
> > Bhavesh
>
>|||What I am saying is that with the shipping product you have to create a data
extension. Read up in bol. Version 2 of RS (ships with Yukon, the next
version of SQL Server) will have controls (web and winform) so you can do it
the way you are thinking about.
Another alternative to a data extension is to rethinking where the work is
done. Have the data extraction occur within RS and then integrate in using
either URL integration or Web services.
Bruce L-C
"Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
news:D7E6E9F7-ECFC-493C-9FA5-9F63FDBC241D@.microsoft.com...
> Pass to which Control?
> I am reading XML data in dataset, in my asp page and passing it to Crystal
> report control..and everything is working fine..
> But I want to do this using SQL Server reporting service..
> How can I do this?
> Thanks
> Bhavesh
> "Bruce Loehle-Conger" wrote:
> > Today you have to write a data extension. In the future (Yukon) there
will
> > be controls that can be used and it should be significantly easier to do
> > this sort of thing (load a dataset with the xml data and pass that to
the
> > control).
> >
> > Bruce L-C
> >
> > "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> > news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > > Hi
> > > How can I generate report using XML file as Datasource?
> > >
> > > And I need to pass XML Filename dynamically at run-time..
> > >
> > > --
> > > Thanks in advance
> > > Bhavesh
> >
> >
> >|||Thanks Bruce..
"Bruce Loehle-Conger" wrote:
> What I am saying is that with the shipping product you have to create a data
> extension. Read up in bol. Version 2 of RS (ships with Yukon, the next
> version of SQL Server) will have controls (web and winform) so you can do it
> the way you are thinking about.
> Another alternative to a data extension is to rethinking where the work is
> done. Have the data extraction occur within RS and then integrate in using
> either URL integration or Web services.
> Bruce L-C
> "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> news:D7E6E9F7-ECFC-493C-9FA5-9F63FDBC241D@.microsoft.com...
> > Pass to which Control?
> > I am reading XML data in dataset, in my asp page and passing it to Crystal
> > report control..and everything is working fine..
> >
> > But I want to do this using SQL Server reporting service..
> > How can I do this?
> >
> > Thanks
> > Bhavesh
> >
> > "Bruce Loehle-Conger" wrote:
> >
> > > Today you have to write a data extension. In the future (Yukon) there
> will
> > > be controls that can be used and it should be significantly easier to do
> > > this sort of thing (load a dataset with the xml data and pass that to
> the
> > > control).
> > >
> > > Bruce L-C
> > >
> > > "Bhavesh" <Bhavesh@.discussions.microsoft.com> wrote in message
> > > news:1ED00147-3CAB-4515-A722-1D943AE2C574@.microsoft.com...
> > > > Hi
> > > > How can I generate report using XML file as Datasource?
> > > >
> > > > And I need to pass XML Filename dynamically at run-time..
> > > >
> > > > --
> > > > Thanks in advance
> > > > Bhavesh
> > >
> > >
> > >
>
>