how to get the sum of the fields ...Very URGENT

hi .. iam having a table with six fields which is holding some values.
there are two branches for a company. now they want to see the two branches values at once . that is sum of the stockin,
sum of the stock out etc...

my table is here...
stockin
stockout
stockinhand
openingstock
unitrate
value.

Now i want to get the sum of these two brancheshi,

in ur table there is no feilds to specify the branch like branch id like that.
if there is baranch id then the query is like this.....

select sum(stockin) as stockinn,sum(stockout) as stockoutt from stack where branchid=1

othere wise can u send me how u identify two differnt branches.

How to Get RS Tools for Visual Studio 2003?

The overall question: How do I get the Reporting Services tools for Visual
Studio 2003 if my web hosting company owns the SQL Server?
I am a lone developer with a laptop and a web hosting company. I have Visual
Studio 2003 installed on my laptop (Windows XP Pro). My web host provides me
with .NET, SQL Server 2000, and now Reporting Services. I want to begin to
learn and use Reporting Services.
In searching Microsoft's web site, it seems that I can only obtain the tools
that go into Visual Studio to develop RS reports if I have my own SQL Server
2000. I own a copy of SQL Server 2000 Professional, but I cannot install it
on XP Pro. It requires a server version of Windows. I do have MSDE
installed, but Reporting Services (RSEval.exe) refuses to install on this
version. I don't have access to high priced things like an MSDN universal or
enterprise subscription. I don't qualify for academic versions.
There must be a way for developers like me to get the tools necessary to
create these reports. Any ideas?You do not need to install the server to use the tools (setup will warn you
but you can ignore it). The evaluation version should work fine for you.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <rrgrimm@.hotmail.com> wrote in message
news:OjYVHZ2pEHA.2696@.TK2MSFTNGP15.phx.gbl...
> The overall question: How do I get the Reporting Services tools for Visual
> Studio 2003 if my web hosting company owns the SQL Server?
> I am a lone developer with a laptop and a web hosting company. I have
> Visual Studio 2003 installed on my laptop (Windows XP Pro). My web host
> provides me with .NET, SQL Server 2000, and now Reporting Services. I want
> to begin to learn and use Reporting Services.
> In searching Microsoft's web site, it seems that I can only obtain the
> tools that go into Visual Studio to develop RS reports if I have my own
> SQL Server 2000. I own a copy of SQL Server 2000 Professional, but I
> cannot install it on XP Pro. It requires a server version of Windows. I do
> have MSDE installed, but Reporting Services (RSEval.exe) refuses to
> install on this version. I don't have access to high priced things like an
> MSDN universal or enterprise subscription. I don't qualify for academic
> versions.
> There must be a way for developers like me to get the tools necessary to
> create these reports. Any ideas?
>

How to get hold of data from web provider using SQL Server?

I am new to SQL server so apologies if this is a stupid question.
I have a website built and hosted by another company, with SQL server back end data. They don't want to analyse the data but I do. I am familiar with SQL and have SQL server express running on my laptop.
So I was thinking I could get them to send me the data from the server (it will be less than 1GB I imagine), and I could analyse it myself.
So my questions are:
will this work?
and what do I ask them to send me? Is it just a couple of files they have to copy and send me? Or is it more complicated than that?
Many thanks for any advice you can offer.
James

Have them back up the database and send the backup file to you. Restore it on your system and you're ready to go. This will work as long as the version of SQL Server they have (200 or 2005) is equal to or less than the one you have.

Buck Woody

How to get hold of data from web provider using SQL Server?

I am new to SQL server so apologies if this is a stupid question.

I have a website built and hosted by another company, with SQL server

back end data. They don't want to analyse the data but I do. I am

familiar with SQL and have SQL server express running on my laptop.

So I was thinking I could get them to send me the data from the server

(it will be less than 1GB I imagine), and I could analyse it myself.

So my questions are:

will this work?

and what do I ask them to send me? Is it just a couple of files they

have to copy and send me? Or is it more complicated than that?

Many thanks for any advice you can offer.

James

Have them back up the database and send the backup file to you. Restore it on your system and you're ready to go. This will work as long as the version of SQL Server they have (200 or 2005) is equal to or less than the one you have.

Buck Woody