|
|
|
January 2003 March 2003 April 2003 May 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 UPDATE using self-referencing JOIN ? Posted by Axel Dahmen at 4/2/2005 7:13:25 PM Hi,
I'd like to update a self-referencing table like
CREATE TABLE test (ID INT PRIMARY KEY,Price SMALLMONEY,Parent INT REFERENCES
test (ID))
....
UPDATE test SET Price = NULL
FROM test AS t1 INNER JOIN test AS t2
ON t1.Parent = t2.ID
OK, this is not the actual statement, of...more >>
very simple database design question Posted by Lisa Pearlson at 4/2/2005 5:43:13 PM Let's imagine we have companies and people working for companies and we
which to keep track of who works where:
table companies {
id INT PRIMARY KEY,
name VARCHAR(100)
}
table people {
id INT PRIMARY KEY,
name VARCHAR(100)
}
Now, in the past, I have added a field to people "comp...more >>
SQL SERVER LINK PROBLEM Posted by Savas Ates at 4/2/2005 4:56:19 PM my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked......more >>
date comparison and filtering Posted by Opa at 4/2/2005 2:31:03 PM Im creating a stored proc where i need to filter an Orders table
results based on a date field as following:
The column i'm filtering is called DeliveryDate
How to I filter DeliveryDate for This Week, This Month.
This Week:
Do I have to calculate the start of week and end of week and then...more >>
Trigger using UPDATE(FieldName) Posted by Optimize Machine at 4/2/2005 2:13:01 PM I want to optimize a huge update trigger...
Instead of using cursor in my trigger, I want to do a batch process.
Question: in a multiple rows, is the UPDATE(FieldName) will be detect for
each record?
Objecttive: Integrate the IF UPDATE(FieldX) in the UPDATE Statement
I don't want to use COLU...more >>
help with santax Posted by Bryan Martin at 4/2/2005 1:58:29 PM Given the following table setup
Table
column1
column2
forumCategory
ID
name
forum
ID
name
forumCategoryID
ForumTopics
ID
forumID
ForumTopicMsg
ID
topicID
dateEntered
I am attempting to create a query that gives a complete ...more >>
Programmatically adding new column at desired place...not at the end Posted by Justin at 4/2/2005 11:52:40 AM
I understand that adding new column programmatically (using ALTER TABLE...),
adds it at the end of the table. Is it possible to specify that this column
should be placed at the 3rd place (not at the end).
Thanks in advance
J Justin
...more >>
Finding records that differ between tables Posted by sugnaboris NO[at]SPAM gmail.com at 4/2/2005 11:50:09 AM Hope someone can help me with a SQL problem that I'm currently trying
to work out.
1) I have a pair *large* tables (actually 2 sets of tables that I want
to take pairwise, and operate on each pair - but I only need to
consider a single pair for now).
2) Each table may have records that are ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What is the most efficient way to select a specific date? Posted by Bob Bartel at 4/2/2005 11:02:37 AM I need to run a query where I'm selecting on a datetime field, but all I
want to do is determine if the Date portion is a specific date.
SELECT my_datetime FROM my_table WHERE my_datetime = '04/01/2005'
only works if the my_datetime column has no time. How can I get this to
work efficentl...more >>
Max pool size error.....how can i resolve this. Posted by ~Maheshkumar.R at 4/2/2005 10:02:28 AM Hi groups, i tried to compile one report page, where i have fired few sql
queries. but sometimes page is working fine, but many times it is giving
error like this
//////////////////////////
Server Error in '/report' Application
Timout expired. The timeout period elapsed prior to obtaining the...more >>
with IGNORE_DUP_KEY - how bypass server msg 3604? Posted by bill_morgan at 4/2/2005 8:25:03 AM The following statement does a great job of eliminating dupliate
[transfernums] from the data inserted into #xfers temp table.
Problem is: my stored procedure stops at the Server Msg "Dupliate key was
ignored", and does not return the final result set, which is simply SELECT *
FROM #xfers. ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |