| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 SQL script to update a table Posted by ravinder at 12/28/2003 2:36:00 AM I have to write a SQL script to update a table named
PA with a column heading of testone update the qty from
10 to 20? ...more >>
max record to join with other tables Posted by kda at 12/26/2003 11:21:18 AM I am currently working with 3 tables.
Table1 has records that have an effective time stamp according to a store number, or ALL stores.
Table1(RetailID, effectiveDate, storeNum, price)
Table2(RetailID, SKUID, vendorID)
Table3(SKUID, Size, desc)
I am currently working on a way to get the SK...more >>
UPDATETEXT Not Working Posted by WiliamG at 12/23/2003 3:55:21 PM I am using MSDE-SP3a on a Win2K-Pro PC.
I am trying to concatenate a field (type TEXT) with
another field (type TEXT) from another table. I have
followed the example in the BOL but it appers as though my
resulting field is not being updated.
I don't know what I am doing wrong, any sugestion...more >>
Rename SQL database datafile name Posted by Goodman at 12/23/2003 5:34:05 AM Hi,
I attached my DB with a new name and the datafile name
remains the old name - how can i alter this name ?
Thanks in advance
...more >>
Emailing Reports using xp_sendmail Posted by Chris Preslar at 12/23/2003 5:12:23 AM I am trying to email three reports in a single email. I
have written a TSQL stored procedure the mixes print
statements and select statements to display a report. The
stored procedure works fine in query analyzer. However,
when I specify this stored procedure as the sql in
xp_sendmail, ...more >>
Sorting Question Posted by Dan at 12/22/2003 7:55:12 AM I need a query that will do two things:
1) return the information in a table based on time
2) limit the returned information based on a criteria. (I
do not want to see duplicate records and would like the
query to return one record based on the max part number)
I have figured out the first ...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |