|
|
|
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 Getting latest date Posted by Nat Johnson at 6/7/2005 8:37:02 PM I have a query that is returning two rows of data. I need to only get the
one with the newest date in it. I gather I can use MAX to do this. Not sure
where or how tho.
here is my code for my letter(report) so far, I need to get the MAX of the
hsh.StatusEffectiveDateTime, any help would ...more >>
Creating a copy of a database Posted by msnews.microsoft.com at 6/7/2005 12:17:31 PM Hi,
Probably a silly question but, I have a database which is currently live. I
would like to create a copy of that database on the same server though under
a different name for testing purposes.
I'm really not sure as to how to go about this. I imagine that the best way
would be to recr...more >>
Help with Substring Query Posted by Mike Harbinger at 6/7/2005 9:18:04 AM I am a SQL novice having a problem building a SQL statement to extract the
following where the tables are:
Cust
-----
CustId (Key)
Orders
------
OrderId (Key)
CustId
Type
For a given Cust I am trying to select the most recent Order of a given
Type.
The OrderId is sequential but...more >>
service pack level of sql 2000 Posted by kb at 6/7/2005 7:07:40 AM Can anybody tell me how to find this?
Thanks,
Kenny
...more >>
Installing SQL 2005 in XP...probs Posted by Maheshkumar.R at 6/7/2005 12:00:00 AM Hi groups,
I like to install SQL 2005 CTP, but its asking me to install service pack 5.
Is there any way to install without service pack.........
Mahesh
...more >>
1 field or 2? Posted by toedipper at 6/6/2005 11:57:21 PM Hello,
Imagine I have a table called countries. Every country is the world has a
unique name so should my table just have one field called ie CountryName or
should I have 2 fields including eg Countryid?
I mean, if the countryname fields are unique anyway what is the point of
creating an i...more >>
list all views that have records Posted by Gary Rynearson at 6/6/2005 3:58:32 PM I am looking for an sql statement that will retrieve all views in a databae,
but only if the view contains data. Here are some queries I am working
with:
select [name] from sysobjects where xtype='V' ---- This brings back a list
of all views, even if they are empty.
OK, the below que...more >>
How do I connect to SQL Server 2005? Posted by CodeManiac at 6/6/2005 12:31:04 PM Wow...SQL 2005 has me completely lost.
With SQL 2000 (and 7.0), I could connect to a remote database by adding the
remote server IP address to the Client Network Utility, and registering the
server in Enterprise Manager.
I can't figure out how to do that with SQL 2005, and I can't find the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Importing Tables from Access Posted by DaveB at 6/6/2005 8:15:15 AM I am in the process of migrating our Sales database from Access to SQL Server
2000 with an adp front end. I installed SQL server on a test machine for this
purpose running Win2K.
I have come up against an infuriating problem... When I import the tables
from my mdb using DTS everything goes...more >>
Median value??? Posted by Jack at 6/6/2005 12:00:00 AM I meet a trouble.
I want get a median value from a sql query
for example: "Select values from tablename "so i get follow :
Values
1
2
3
4
5
6
7
how to write a sql query get the "4" ,only a median value ??
i use :"select median...more >>
Urgent:DTS Packages Export Posted by G Q at 6/3/2005 7:14:10 AM Hi:
we have a lot of DTS Packages in SQL Server 7.0. We are moving all databases
to a new server in 2000. What is the best way to Script and save these
packages with out us going to create form scratch. any Ideas will be greatly
appreciated.
Thank you all in advance,
G A...more >>
Syntax Question Posted by HartAch at 6/2/2005 9:23:17 AM Just converted by website from Access to SQL. The below code works fine in
Access, but I am getting an error in SQL
strSQL = "SELECT Count(Status) as 17LCD FROM Monitors Where left(mSize,2) =
'17' and Type='LCD'"
rs.Open strSQL, conn, 3, 3
Here is the error
Microsoft OLE DB Provider for...more >>
backup and restore Posted by tonyr at 6/2/2005 6:59:39 AM ok I screwed up the recovery settings on a database, originally it was set
to simple and created a backup that did a complete backup every night no
transaction logs being backed up (obviously). I then must have switched it
to full and kept the same backup job anyway when I do a restore and ...more >>
Backup to network drive Posted by Danny Sanders at 6/1/2005 4:25:31 PM Using SQL enterprise edition 8.0 on XP pro SP2, when trying to create a
backup job that stores the backup on a network drive, browsing to the
network drive does not show the network drives the computer is attached to.
We are trying to get it backed up to the "T" drive, which is on a server.
...more >>
Query database for column names Posted by Gary Rynearson at 6/1/2005 11:00:27 AM I am looking for the tablename that contains database metadata, so that I
can query it as follows:
Select * from [database metadata tablename] where [field in metadata table
that holds table field names] like 'base_%'
Thanks, Gary
...more >>
How do you delete a DTS schedule? Posted by Shakeela at 6/1/2005 6:12:02 AM I created a schedule for my DTS package and I would like to change it and/or
delete it. When I went in and made modifications to the day/time that I
wanted it to run it just created more jobs when I looked at my jobs under SQL
Server Agent my attempts to correct the initial schedule had just ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |