|
|
|
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 Deleting old backup files Posted by Steve Gr at 1/26/2007 9:49:46 AM Hi,
I want to make a maintenance plan to remove old .bak and .trn files. (SQL
2005 on W2K3 R2 std edition)
I have lots of databases which are all backing up into separate folders. The
Maintenance Cleanup Task is not very versatile! It seems I have to set up a
separate task for each folder ...more >>
Updating one table with data from another - problem Posted by Ernie at 1/26/2007 6:26:35 AM I've searched the posts and found some useful code on updating one
table with data from another however, when I created the following SQL
statement, I get an error 'ADO error: The column prefix
'TAinvxSUBstatusNEW' does not match with a table name or alias name
used in the query'
Both tables...more >>
Sample Databases and Code Posted by Tony Ramirez at 1/25/2007 2:28:01 PM How can I install the Sample Database if I have already run the installation.
New user, tried doing this today just re-installing, but no luck. I did make
a new instance -- hopefully I didnt screw it all up. Any help is appreciated.
Thanks!...more >>
Training Posted by Tony Ramirez at 1/24/2007 2:21:01 PM I am having a heck of a time figuring out a good direction. I would consider
myself a decent Database professional. Used Access and another MRP system for
the past years and have done lots of development. I want to replace them both
with SQL. I dont know where to really begin with training. We...more >>
SQL & XML files Posted by Steve Gr at 1/23/2007 9:15:41 AM Hi,
I have thousands of xml files that an application is producing on a daily
basis.
Is there a way I can use SQL 2005 to access the contents of these files for
reporting or data searching?
Thanks
S
...more >>
Case Range Posted by Vayse at 1/22/2007 12:54:04 PM I want to run a Case statement. If the Exec Code is 1840, 1850 or 1880 then
use that Exec Code.
Otherwise, if the the Exec_Code is between 900 and 2000, use 1900 as the
value.
If none or the above, use 1800.
How do I use < or > in the Case/When statement?
Thanks
Vayse
SELECT LedgerKe...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |