|
|
|
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 Trigger - Calculate date based on two other dates Posted by FinnGirl at 9/15/2007 8:20:02 PM I need a trigger to calculate and insert into an Action table, five action
due dates (each date is a separate record with a corresponding action item)
based on two Milestone dates that are inserted into a Milestone table. These
Milestone dates, A and B, are inserted as separate rows in the Mi...more >>
filter search type Posted by Rudy at 9/15/2007 8:18:00 PM Hello All!
I have a search query I would like to perform. For example, I have a table
with Last, First and DOB columns. I would write this as a SP so I can call it
in my ASP.net application.
What I would like to do if a user want to search by first name only, it will
return the results. Va...more >>
Exporting SQL Server 2005 Tables to SQL Server2005 Express? Posted by Peter Olcott at 9/15/2007 1:11:02 PM I was able to convert an MS Access database into SQL Server
2005 Developer edition. Now I want to export this same data
to SQL Server 2005, Express Edition. Does anyone here know
how to do this?
...more >>
how to make fast forwad only cursor updatable in SQL Server 2000 Posted by Baihao Yuan at 9/15/2007 7:36:01 AM In the msdn SQL server
document(http://msdn2.microsoft.com/en-us/library/aa172573(SQL.80).aspx), it
states:
Transact-SQL cursors can specify the FAST_FORWARD clause on DECLARE CURSOR.
This opens an optimized forward-only, read-only cursor.
But in the following section 'Implicit Conversio...more >>
Need to parse ntext field in TSQL as INT Posted by CSharpie at 9/15/2007 5:04:00 AM Hi, I have an nvarchar field with a list of productIDs (ints) whos prices I
would like to summarize with one columnar function: sum. SqlServer is giving
me an error message saying that it cannot convert the varchar field to int
(on its own). Is there a straight forward way to doing this, oth...more >>
Require Solution for this SQL problem Posted by Nick at 9/15/2007 3:52:42 AM Hi,
I have two tables TableA and TableB. I have a stored procedure which
runs every morning and based on some logic dumps rows from TableA to
TableB. In Table B there are two additional colums ID and RunID. ID is
a normal sequence applied for all rows. But the RunId should be
constant for a r...more >>
Select Problem Help Posted by Mick Walker at 9/15/2007 12:00:00 AM Hi All,
I have a select problem.
Here is my Table
CREATE TABLE [dbo].[RelationShips](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[MemberID] [int] NOT NULL,
[DateAdded] [datetime] NOT NULL,
CONSTRAINT [PK_HotList] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX ...more >>
How can I combine these two queries into one query? Posted by OK at 9/15/2007 12:00:00 AM Can I combine 2 WHERE clauses into one query in order to improve the
database performance?
This is the case :
query1)
SELECT SUM(amount) AS SUM_DEBIT FROM ... WHERE .....AND DEBIT = 0
query2)
SELECT SUM(amount) AS SUM_CREDIT FROM ... WHERE .....AND DEBIT< > 0
So, the only difference ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |