I have a project where I will be loading ~ 242 Million Rows of data to a
table and then adding to this on a monthly basis.  Maybe 3 million a month
added.  This will be used mainly for reporting purposes.
Is there a limit as to how many rows a table in SQL can have?  SQL Server

I am new to the world of dataming and I have what I think is a fairly simple
question.  I have 2 tables - tablea and tableb.  tablea contains 2 pertinent
fields, category_num and category_name.  tableb contains contains 2
pertinent fields, product_id and category_num.  There are ...

I have a schedule table and I need to add to the existing
date column all dates for the year of 2005. The normal
format 1/1/2005. To do it manually will take me forever,
so what type of query can I use to do it.

How can I convert to horizontal records the following data:
party_id    name_type   name
--------    ---------   ---------------------
1            lnme       Smith

I have a query that produces several copies of the same line based on a
grouping by different days, product ids and product styles and I just want
the first in each style group... in Access I can do this using the FIRST
commmand in the query, how do I something similar in SQL ...

Does anybody have examples of mining agaist
finance ledger / budget ?
The examples I have seen have been against
customers.

where are these things stored on a sqlserver 2000?
how could i backup them?
how could I transfer them to a new server?
Thanks!

I am kind of new to SQL, databases and programing and I have a question,
that looks very easy to me, but I kaind figure it out.
Please help me.
I am designing VB .NET application and underlying SQL database (using MSDE),

I am having diffuclty in preparing dynamic select statemet where length
exceed 8000 characters because too many columns in tables.
How can i overcome this situation..Is there anyway to retain if exceeds 8000
characters..

I am passing the following query for a single hour
select convert(int, avg(fld_logged_in_agents)) from
tbl_groups_state_details where fld_group_no = 824
and day(fld_date_time) = day(getdate()) and month(fld_date_time) =

Hi i am running a query where i am creating intermediate
tables andthen doing a distinct select from these tables.
For some reason the result obtained from this is different
i run it the first few times and then finaly it stops and

I have a table with some departures at stations.
I want to calculate the time difference between two departures. basically I
want to subtract Timevalue of every two records for the one and the same
IdStationDirection. I use the table joined to itself to get that.

I have a sqlserver 2000 (windows 2000 server) running and my machine is now
too slow.
So I want to buy a new one (dualprocessor) and transfer my database to that
server.

hello
i have 3 tables Issues, distribution, returns
i would like to get out for each issue the sum of quantity in distribution table and the sum of quantity in returns table
i perform this select but does not work well because the table distribution and returns have different ...

Trying to get the most recent record for each company that is returned
in the following SQL statement.  For example, the SQL statement returns:
DatePulled     Company Name     Revenue
2004-01-01     ABC Corp         1000.0000