|
|
|
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 Possible Bug in SQL2005 query? Posted by chencongwei NO[at]SPAM gmail.com at 10/21/2006 11:26:21 PM Hi! This is what happened to me and my colleagues.
We are using SQL 2005. When we were building a view from a table, the
field we selected was not what came out in the output.
Let's say you have 2 specific fields in the table, the second one of
them begins with the letter "L". While your mou...more >>
Ann: A web based tool for sql to cgi conversion Posted by Semiconductor Recruiter at 10/21/2006 10:03:21 PM Hi,
I have been working on a code generator to convert a .SQL script to
1. html forms for data entry and editing
2. Perl scripts for saving the data to a given database.
3. Scripts to preview and edit A given row of data.
As I was unable to find such a tool online
The current version of the t...more >>
Need your help to remove spaces in the column entries using SQL Posted by feucos NO[at]SPAM gmail.com at 10/21/2006 9:05:10 AM Hi all,
I am new to these so plz never mind if this is funny.
here is my problem :
Table : moody
Column : Title
New column : Nospace
I have data in "Title" column of many rows which are normal sentence.
My requirment is to remove the "white space", +, | , ., / , ! @, $, %
etc s...more >>
making JOINS Posted by MORALBAROMETER at 10/20/2006 8:19:46 AM Hi alll
I have these tables below with 3 fields each. I want to get the record
in table 1 whose field number value is same in table 2 but field number
2 on both tables are different. I mean i want the record
1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules
delivered. I wan...more >>
need help on store and compare time? Posted by eddiekwang NO[at]SPAM hotmail.com at 10/19/2006 12:30:26 PM Hello,
I need to store the start and end time of each weekly class into a
database. so that people can easily search for classes based on time.
for example, someone might want to search all classes that are offered
between 9am and 2pm.
How can i implement this time field? i don't have a date ...more >>
How do you conditionally fire a trigger (mimic replication) Posted by steven NO[at]SPAM bluemania.co.uk at 10/19/2006 10:02:06 AM Does anyone know how to do the following. I'm trying to mimic
replication with triggers.
I have 2 databases, each have these 2 tables.
1.
USERS
ID int
NAME varchar(20)
2.
CHANGES
TABLE varchar(20)
TYPE varchar(10)
col1 varchar(20)
col2 varchar(20)
On the USERS table I have a for...more >>
No Local instance with SQLServer2005 Dev. Ed. Posted by RLN at 10/19/2006 8:01:28 AM (New to SQL Server Installs)
I installed SQL Server 2005 Developer Edition on a WinXP-SP2
workstation and can see some enterprise databases on the network just
fine.
My problem is I cannot register a local database on the local drive for
testing/education purposes.
(I accepted all of the d...more >>
Query Problem in Access Posted by hardik at 10/19/2006 12:57:20 AM hi friends i need help in this sql query
i have table like,
id fid
__ _____
autonumber text
and i am storing values like
id fid
___________________________________
1 1,2,3,4,5
2 ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
unable to run mysql server 5 on windows Posted by Nospam at 10/19/2006 12:00:00 AM on trying to change the
password it says this:
C:\PROGRA~1\MYSQL\MYSQLS~1.0\BIN\MYSQLA~1.EXE: connect to server at
'localhost'
failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doin...more >>
Migration from SQL 2000 to 2005 Posted by rc NO[at]SPAM !die!.spammer.bhfshops.org.uk at 10/18/2006 3:00:58 PM Hi
We are going to upgrade from SQL 2002 to 2005. We have approx. 100m
rows of data on the main table and hand of stored procs and views.
What we had in mind was that we would dts the data out, script the
stored procs and view out and import the it back into SQL 2005.
Is there smarter w...more >>
[ANN] VTD-XML 1.7 Posted by Jimmy Zhang at 10/18/2006 2:11:13 PM VTD-XML project team released Version 1.7 of VTD-XML, the next =
generation
XML parser that goes beyond DOM and SAX, under GPL. VTD-XML is getting
faster, leaner, more stable and complete with this release.=20
Please visit http://vtd-xml.sf.net for the latest release.
For further reading, p...more >>
How to combine 3 SQL statements into 1? Posted by MackTheKnife at 10/18/2006 2:01:47 PM I have the following 3 SQL statements that need to be combined, if
possible. The output of one feeds the input of the next. I need to view
all of the defined output fields (the output needs to be used in a
Crystal Report).
The SQL Follows:
/* Input is ISBN (vendor_part_number) */
QUERY_1 - r...more >>
Learning about Indexes the Hard Way Posted by jim.clifford NO[at]SPAM gm.com at 10/18/2006 3:09:01 AM Hello, I am experimenting with indexes and hope people can shed light
on some of my problems.
I am using SLQ 2000 on Win 2000 Server. Using the following query for
discussion;
--------------------------------
SELECT TOP 1000000
E.EUN_Numeric, -- Primary Key
E.EUN_CODE, ...more >>
SQL Server 2005 - SELECT query Posted by Lionel Pinkhard at 10/18/2006 12:00:00 AM Hi
I currently have a select query with "Description = 'input from user
here'" which basically returns the associated row containing the
Description field exactly as typed by the user, however, would it be
possible to, if not found, return the closest match? I am using
Microsoft Visual St...more >>
SQL statement to compare and return one aggregated value Posted by Pradeep at 10/17/2006 6:44:55 PM Hello,
In my table, I have two columns - ForecastSales and ActualSales. I need
to write a query that returns me just one aggregate value (one row and
one column). If sum(ActualSales - ForecastSales) is negative, I need to
return "red." Otherwise, I need to return green.
I looked at CASE sta...more >>
sql statement to select customers contributing top 60% of sales Posted by kansaskannan NO[at]SPAM gmail.com at 10/17/2006 6:08:06 PM I have an Access 2000 database which lists customers by name, and how
much (in dollars) they have purchased of various products. How do I
write a SQL statement to select customers who make up the top 60% of
total sales dollars? I need to have a list of customers returned.
The list of custome...more >>
What is the best way to store a shopping list or order? Posted by JRoughgarden at 10/17/2006 10:36:41 AM After a customer decides to buy a shopping list, there is generally a
need to store/insert one master record and a variable number of child
detail records, preferably all wrapped in a transaction. There are lots
of ways to do this and I am wondering if anyone knows which is most
efficient.
On...more >>
SQL Query return unused values Posted by Chicagoboy27 at 10/17/2006 8:30:01 AM I have a table. In the table I have different types of mailing
addresses. The addresses are linked by and ID. ex,
addresses per ID 1
ID address
1 add2
1 add3
1 add4
distinct Addresses in table
ID address
1 add2
1 add3
1 add4
What I am trying to f...more >>
Execute an schedule job from MSDE with LINKED servers in SQL Server Posted by rkershberg NO[at]SPAM gmail.com at 10/16/2006 3:57:08 PM I have a schedule job that I would like to run on a MSDE database. The
stored proc executes just fine if I run it manually. But trying to
schedule it through the Enterprise Manager (or Management Studio)
generates an error saying the the "Remote Access not allowed for
Windows NT user activated...more >>
MSDTC? Posted by Jimbo at 10/16/2006 2:09:32 PM I keep getting this error on my application server...what does it mean?
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following infor...more >>
Recursive Stored Procedure? Posted by Henrik Juul at 10/16/2006 1:15:43 PM How do I call my Stored Procedure recursively:
CREATE PROCEDURE dbo.GetParentIONode
(
@IONodeID int,
@FullNodeAddress char(100) OUTPUT
)
AS
BEGIN
DECLARE @ParentIONodeID int
IF EXISTS (SELECT ParentIONodeID FROM IONodes WHERE IONodeID = @IONodeID)
BEGIN
SET @FullNodeAddress = C...more >>
automated role creation Posted by cybertoast NO[at]SPAM gmail.com at 10/16/2006 7:58:42 AM i seem to have some misunderstanding about how roles work in sql server
2005. i see that i can add a role to a database
(dbname->[right-click]->properties->permissions->[add ...]. THis allows
me to add either users or roles. Users can be added programmatically
using sp_grantdbaccess @username, b...more >>
Related Tables: Help Needed With JOIN Query Posted by Rommel the iCeMAn at 10/16/2006 4:43:06 AM Hi Group,
My apologies for the lengthy post, but here goes...
I have the following tables:
TABLE Vehicles
(
[ID] nvarchar(5),
[Make] nvarchar(20),
[Model] nvarchar(20),
)
TABLE [Vehicle Status]
(
[ID] int, /* this is an auto-incrementing field*/
[Vehicle ID] nvarchar(5), /* forie...more >>
SQL Batch - Slow Response - Remote DB query Posted by jim.clifford NO[at]SPAM gm.com at 10/16/2006 3:12:40 AM Hello.
I have a slow response with a system that I am setting up. The OS is
Win 2000 Server with SQL Server 2000. My first execution of the SQL
procedure is slow (about 40 seconds), while the second execution is
faster (approx. 3 seconds and what I expect).
Using query analyser I can leave th...more >>
can anyone solve this sql query? Posted by hardik at 10/16/2006 12:47:31 AM hi friends i need help in this sql query
i have table like,
id fid
__ _____
autonumber text
and i am storing values like
id fid
___________________________________
1 1,2,3,4,5
2 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |