|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Question about database size and performance... Posted by Roger at 8/26/2004 4:46:15 PM 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
2000 is what I ...more >>
Newbie Question Posted by Ted Dixon at 8/24/2004 3:16:54 PM 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 approx. 100000
r...more >>
How to add Calendar Posted by Sasha at 8/20/2004 9:20:21 AM 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.
Thank you,
Sasha...more >>
CrossTabulate names Posted by fredy at 8/20/2004 5:42:33 AM How can I convert to horizontal records the following data:
party_id name_type name
-------- --------- ---------------------
1 lnme Smith
1 nme Jhon
1 alias Jhonny
2 lnme Hernandez
2 nme Fredy
2...more >>
Trying to get just the first record for each grouping Posted by Atley at 8/19/2004 1:09:45 PM 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 server?
I have lo...more >>
Datamining financial data Posted by Michael Vardinghus at 8/16/2004 7:28:17 PM Does anybody have examples of mining agaist
finance ledger / budget ?
The examples I have seen have been against
customers.
If not a specific example then a hint to what mining
could be used for related to this area.
--Michael V.
...more >>
Problem with tables Posted by Nikolay Petrov at 8/16/2004 3:40:56 PM Hi everyone!
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),
and I have two tables:
UserDetails table with columns:
ID...more >>
Data Length exceesing 8000 chars Posted by Kevin Humphreys at 8/12/2004 10:27:09 AM Hi,
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 tried to use the text field but this is not valid for local va...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Query retreiving dfferent results on same data Posted by Ashish Nanda at 8/9/2004 5:19:50 PM 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
gives me same numer of rows. Does it have to do SQL Server
...more >>
Hourly format Posted by Preet Kanwaljit Singh Shergill at 8/7/2004 5:32:44 AM 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) =
month(getdate())
and fld_date_time between '2004-08-07 12:00:00' and '200...more >>
Substracting two adjacent rows Posted by Yakimo at 8/6/2004 4:53:20 PM 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.
My SQL looks like:
SELECT TOP...more >>
sqlserver 2000 - dts import jobs, analysis manager cubes, dimensions Posted by Hubert Mayr at 8/6/2004 11:58:54 AM Hi!
where are these things stored on a sqlserver 2000?
how could i backup them?
how could I transfer them to a new server?
Thanks!
...more >>
new hardware - sqlserver 2000 transfer Posted by Hubert Mayr at 8/6/2004 11:57:05 AM Hi!
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.
I have a lot of dts jobs, user, roles, rights, cubes, dimensions how could I
get that all to my new server?
my main...more >>
Best way to Import data from EXCEL using a TSQL Posted by Ian at 8/4/2004 4:58:57 PM Hi All
I have a excel spread sheet that i need data from. This is the Data.
MyID
TextField
DateField
IntField
FloatField
1
Ian One
01/04/04
10
10.0304455900
2
Ian Two
02/04/0...more >>
need help on select Posted by SqlJunkies User at 8/4/2004 6:18:57 AM 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 rows results
...more >>
Selecting most recent record Posted by Micromanaged at 8/2/2004 3:42:45 PM
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
2004-02-01 ABC Corp 1234.0000
2004-02-01 XYZ Co...more >>
How to get the day of week in SQL function Posted by Vincent at 8/1/2004 9:08:47 PM There is a function called WEEKDAY... any similar one in
SQL ? Thanks....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |