|
|
|
January 2003 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 |
Filter by week: 1 2 3 4 5 Selecting TOP X child records for a parent record Posted by Catch_22 at 10/28/2006 11:26:51 PM Hi,
I have a stored procedure that has to extract the child records for
particular parent records.
The issue is that in some cases I do not want to extract all the child
records only a certain number of them.
Firstly I identify all the parent records that have the requird number
of child...more >>
Help: Stored Procedure performance issue. Posted by Catch_22 at 10/28/2006 8:45:52 PM Hi,
I have a large SQL Server 2000 database with 3 core tables.
Table A : 10 million + records
Table B : 2 million + records
Table C : 6 million + records
One of the batch tasks that I have to perform firstly builds a list of
all keys for records from each of the three tables that I need...more >>
Filters on the data Posted by kucol at 10/27/2006 2:47:17 PM Hi guys,
I wanted to ask you for help as I am struggling with it second evening
already...
I have got tables DEVICES and PARTS.
One device can consist of multiple parts.
But...
I have also another table - FILTERS (id int, type int, is_not int,
phrase varchar(40))
where:id - just id,
t...more >>
2005 connecting 2000 ? Posted by klabu at 10/27/2006 11:09:26 AM if I install SServer Express Edition
Can I connect to SServer 2000 DB ?
thanks
...more >>
SQL2005 - don't see my database when I use VPN-connection Posted by lieven.becue NO[at]SPAM gmail.com at 10/27/2006 10:03:55 AM Situation: at work we have a windows 2003 server with MS sql server
2005 express. With my pc at work, I can see my own database I created.
At home. I can connect with VPN to the network. With extern desktop I
can see the database and do everything. Now I want to create a login
with visual web de...more >>
Sequential Number in an Update Posted by eric.nave NO[at]SPAM gmail.com at 10/27/2006 9:36:24 AM this is a slight change to a fequently asked question around here. I
have a table which contains a "sortorder" column where a user can
specify some arbitrary order for records to be displayed in. Users
have sometimes ordered records the way we used to number lines in a
BASIC program (10,20,30,...more >>
view works, but the sql from the view does not Posted by rcamarda at 10/27/2006 7:32:38 AM I was looking through our vendors views, searching for something I
needed for our Datawarehouse and I came across something I do not
understand: I found a view that lists data when I use it in t-sql,
however when I try to use the statement when I modified the view (via
MS SQL Server Management S...more >>
SQL 2005: Unable to edit linked table records Posted by news.sbcglobal.net at 10/26/2006 3:30:11 PM Hi!
I am able to add records to my SQL 2005 database using bound forms in my
Access application, but if I try to edit any records (not only the new
records I create) using the same bound forms, I receive a write conflict.
For the record, I am currently the only user of this application and ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
database analysis Posted by joeyp at 10/26/2006 12:58:04 PM hello!
i'm looking for resources on database analysis. my main questions are:
how does one determine the primary key of a table, and, how does one
determine the relationships between the tables?
if you know of any tips, books or websites, i'd love to know. my
current skills for such quest...more >>
TOP N Value per category Posted by amit.vasu NO[at]SPAM gmail.com at 10/26/2006 6:44:37 AM Hello
I am using sql server 2005.
I have two tables as described below.
Table1
UserID UserSales
---------------------
1 10
2 13
3 17
4 19
5 21
6 10
7 12
8 ...more >>
Help with a query Posted by foneguy2 at 10/25/2006 3:58:36 PM I have a table with 4 relevant fields (blank lines added for clarity).
State, City, Name, Primary_Contact
IL, Springfield, Bill, n
IL, Springfield, Frank, n
IL, Springfield, Larry, n
IL, Bloomington, Steve, n
IL, Bloomington, Chris, y
IL, Chicago, Betty, n
IL, Chicago, Linda, n
IL, Chic...more >>
How to find query plan for a stored procedure using temporary tables Posted by comp_databases_ms-sqlserver at 10/25/2006 3:41:52 PM This post is related to SQL server 2000 and SQL Server 2005 all
editions.
Many of my stored procedures create temporary tables in the code. I
want to find a way to find the query plan for these procs
Repro
--***********************************
use pubs
go
CREATE PROCEDURE Test @percentage ...more >>
Return subquery rows as one delimited column Posted by kingskippus NO[at]SPAM gmail.com at 10/25/2006 2:40:21 PM I don't know if this is possible, but I haven't been able to find any
information.
I have two tables, for example:
Table 1 (two columns, id and foo)
id foo
--- -----
1 foo_a
2 foo_b
3 foo_c
Table 2 (two columns, t1_id, and bar)
t1_id bar
------ ----
1 bar_a
1 bar...more >>
Question on scripting Posted by mike at 10/25/2006 11:30:11 AM I have a question on coding, just want to see if there is a better way
to do this.
Here is some sample data combinations that would come from 2 different
tables.
Item Method Price Cost Percentage
A-1 L 100 50 10
A-2 D 110 55 15
A-3...more >>
.NET 2.0 and .NET 1.1 co-existence? Posted by Larry Bertolini at 10/25/2006 10:42:57 AM I downloaded Quest Software's freeware version of
Comparison Suite. When I attempt to install, it tells
me that it requires .NET framework 1.1.4322. I already
have .NET 2.0 installed (as part of the MS-SQL native client install)
and I really don't want to mess that up.
Is it *safe* to have ...more >>
simple way to convert '1900-01-01 17:12:00.000' to 5:12pm? Posted by eddiekwang NO[at]SPAM hotmail.com at 10/25/2006 10:41:21 AM I have a table called class_time. and the column name is start_time.
datatype is datetime.
id start_time
2 1900-01-01 15:00:00.000
4 1900-01-01 17:12:00.000
i want to the convert the start_time column into a format that only
has the hour and minutes plus AM/PM ( for example, 3:00 pm,...more >>
What am I doing wrong here? Posted by James Foreman at 10/25/2006 3:37:52 AM (SQL Server 2000)
I want to aggregate some data from a table, and because I'm going to
feed the result set into a union, say, I want to put another column on
there to carry some information that I know will always be the same in
this particular result set.
Simple example: I have a table Dim...more >>
The best methodology to test load script Posted by tamatem at 10/25/2006 1:53:54 AM "I have build a long sql data load script. What is the best way to do
Testing of the script? I would like to automate the test!"
...more >>
Free Enterprise manager? Posted by Curt at 10/24/2006 8:45:13 PM I have a customer that purchased a program that uses the free version of
MS Sql Server. I think it's called MSDE. This runs some expensive robots
from data within the SQL Files. They are however in need of some
indexing or something else as they are beginning to run very slow. Is
there some ...more >>
Help with an update query Posted by CK at 10/24/2006 7:53:31 PM Hi All,
We have a budgeting table and a budgetAssistant table, I have 3 employee ID's,
I need to assign each of them as budget assistant. Do you know of a quick
update query I could write to accomplish this? The budget and
budgetAssistant tables both have a budgetID field. Any ideas?
I ...more >>
ExecuteScalar returns null Posted by js at 10/24/2006 4:15:21 PM I am using the following C# code and T-SQL to get result object from a
SQL Server database. When my application runs, the ExecuteScalar
returns "10/24/2006 2:00:00 PM" if inserting a duplicated record. It
returns null for all other conditions. Does anyone know why? Does
anyone know how to get...more >>
two versions of sql on one server? Posted by webmaster NO[at]SPAM aquinasandmore.com at 10/24/2006 3:00:41 PM Is it possible to run both SQL200 standard and SQL2005 Express on the
same server? I need to test a database created in 2005 on our
production server but don't want to upgrade our "live" databases yet.
...more >>
Query autocomplete in SQL Server Management studio? Posted by Mamba at 10/24/2006 2:39:34 PM Brand new to this tool, and I am constructing a few queries. I am used to
having a column list pop up when referencing table names in queries - the
lat couple of products I used provided this feature.
Is this available in the SQL Server Management studio tool - if so how?
Tnx
Gary
...more >>
SQL Server Sizing - Hardware requirements for SQL Server 2005 Posted by Parv at 10/23/2006 11:04:13 PM Hi all
I am having a SQL Server database of arround 110GB and 250 Users. What
is best suited hardware requirements for handling of such a database. I
am having following requirements from the server:
1. Feeding purpose : On which continously feeding is done by average
200 users.
2. Reporti...more >>
Generate SQL Script Posted by Chris Zopers at 10/23/2006 2:20:53 PM Hello,
I want to generate a SQL Script of a SQL Server database. To do this, I
right-click the database name and choose the option All Tasks/Generate
SQL Script.
Than I get a text file with a script that generates all objects, but the
order in which the objects are generated is wrong. There...more >>
Enterprise Manager takes 10+ min to open Posted by Johnny Ruin at 10/23/2006 7:14:06 AM Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?
...more >>
Order of GROUP BY - does it matter? Posted by rcamarda at 10/23/2006 5:23:26 AM Does the order of columns make a difference in the GROUP BY?
Woulde GROUP BY A, B, C
return different results than
GROUP BY C,A,B ?
...more >>
I have a basic question about SQL server Posted by kirke at 10/22/2006 10:54:23 PM Hi, I have no idea about SQL Server.
my first question is,
SQL server usually mean "MS" sql server. right?
Also, my second question is,
I made a webpage with PHP to connect My SQL.
However, if i want to change from My sql to MS sql server, then how can
i change the webpage? can I do it wit...more >>
Testing load scripts Posted by tamatem at 10/22/2006 3:01:11 PM I have build a long sql data load script. What is the best way to do
Testing of the script? I would like to automate the test!
...more >>
Monitoring Inserted data and comparing against selected data Posted by tamatem at 10/22/2006 2:22:16 PM I made ahuge load script in SQL Server 2000 as i load data from many
tables(select some of each one collumns) into one single table and i
want to test the loaded data against the selected data to make sure
that the loaded data is the same the selected data
is there a code or tool to make this te...more >>
Group By Query Casues TimeOut Error Posted by laurenquantrell at 10/22/2006 9:21:20 AM I have a table with 6 million rows.
I'm trying to perform a group by query that incudes a row count of the
PK column:
SELECT COUNT(DataID) AS Cnt, Column1Name
FROM dbo.TableName
WHERE (Column2Name = N'p')
GROUP BY Column1Name
I have the query timeout set to 0 in Enterprise Manger. However...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |