|
|
|
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 31 Inputs in an SP Posted by NathanG at 10/22/2006 11:06:01 PM Hi,
I am in the process upsizing an access db to sequel with an ASP front end.
The customer users 2000 but we have been using 2005 and have set up our
system to be compatible with 2000 ( or so my colleague tells me! lol) To run
an SP 3 inputs need entering. In 2005 an input box appeared but...more >>
Query - Not Able To Get It Done ! Posted by lovely_angel_for_you NO[at]SPAM yahoo.com at 10/22/2006 10:05:10 PM Hi,
I have to tables in my database. First one contains, the order number.
Second one contains the details of customer. I want when i display the
list of order from a picked date, I should be able to show the details
from second table as well.
rdset.Open "SELECT SalesData.* FROM SalesData W...more >>
Using Insert Into Posted by Brent at 10/22/2006 8:47:24 PM Need help determinig why this syntax gives an error. Seems to not like that
I'm trying to combine a select & client values in my 'insert into'
statement. Any ideas?
DROP TABLE RECIPE
DROP TABLE DETAIL
CREATE TABLE [dbo].[RECIPE] (
[RID] [uniqueidentifier] NOT NULL ,
[BRANCH] [nchar] (...more >>
Help with a query?? Posted by spovolny NO[at]SPAM gmail.com at 10/22/2006 5:56:05 PM Hi to anyone who has a technical brain and can figure this one out for
me!
I need to compare each row of one table to the corresponding row of the
next table.
So, for instance, let's say we have these three tables. Creature,
Aspirations, Achievements
A simple left outer join returns all...more >>
Help with a query?? Posted by spovolny NO[at]SPAM gmail.com at 10/22/2006 5:55:55 PM Hi to anyone who has a technical brain and can figure this one out for
me!
I need to compare each row of one table to the corresponding row of the
next table.
So, for instance, let's say we have these three tables. Creature,
Aspirations, Achievements
A simple left outer join returns all...more >>
different servers Posted by soc at 10/22/2006 3:21:19 PM Hello,
Can I insert by selecting from a similar database on a different server?
I'm getting error : Login failed for user 'sa'.
...when I try the following..
CREATE PROCEDURE theuser.usp_updatepages
AS
INSERT INTO server2.db.theuser.pages
SELECT * FROM server1.db.theuser.pages
...more >>
CASE WHEN NULL Posted by RON at 10/22/2006 8:05:55 AM A SQL Server 2005 DB table named 'Address' has the following records
under the columns 'OrderID', 'UserID' & 'Addr':
---------------------------------
OrderID UserID Addr
---------------------------------
1 12 35 Park Road
2 12 NULL
3 12 ...more >>
What's wrong with this SP Posted by RON at 10/22/2006 5:46:28 AM In a shopping cart app, when a user finalizes his order, records from a
temporary table named 'TempCart' get inserted into another table name
'Orders' after which the records from 'TempCart' are deleted.
'TempCart' has the following columns:
UserID int (no NULLs)
Carpet int (NULLs allowed)
C...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Importing csv Posted by Arjen at 10/22/2006 12:45:30 AM Hi,
I use sql server express and want to import data from a csv file but cannot
find any import button.
Can some one help?
Thanks!
Arjen
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |