Viewing 15 posts - 2,671 through 2,685 (of 3,221 total)
May I suggest that you look up the SUBSTRING function in Books On Line and use that. It is simple enough and I believe that you can compose...
January 18, 2009 at 3:45 pm
Many eons ago I worked at the development laboratories of a fortune 500 corporation. As such over a 13 year period of time I flew 1,300,000 (one million 300...
January 16, 2009 at 3:06 pm
Check Books On Line (BOL) for INSERT INTO.
Assuming the table you are inserting into exists then you could use
INSERT INTO MyTable (PriKey, Description)
...
January 16, 2009 at 1:59 pm
rferguson
I'm trying to construct a more complex variable where I'll pass two date variables
.
May I inquire as to why you want to use a a complex variable to pass...
January 15, 2009 at 7:43 pm
Search Codeplex starting here:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
January 15, 2009 at 6:54 pm
In addition to Michael Valentine Jones' answer be sure to review the Public Role, remember:
New Information - SQL Server 2000 SP3.
1. public role is a special database role to...
January 15, 2009 at 5:09 pm
You might want to read this and the do the download as well as follow CozyRoc's link.
From the above url:
This download will install a set of components that can...
January 15, 2009 at 11:14 am
Bob Hovious
That said, let me compliment all of you on your fantastic expertise and your phenomenal patience. The combination encourages people to keep coming back. I've certainly...
January 14, 2009 at 1:21 pm
Sounds like your problem is within Excel and not SQL - an extract from the Excel help file: "About formatting work sheets and data" in Excel help.
You can use number...
January 13, 2009 at 2:06 pm
Although this pertains specifically to SSIS might it also be a part of your problem?
Office 2007 files have a new format and therefore are not supported by the Jet 4.0...
January 13, 2009 at 8:47 am
Suggest you start by looking at the various Dynamic Management Views
DMVs in Books On Line - here is a good starting point:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/cf893ecb-0bf6-4cbf-ac00-8a1099e405b1.htm
Oh you have posted this question in a 2000...
January 9, 2009 at 9:03 am
Go to Codeplex http://www.codeplex.com/MSFTDBProdSamples
and down load the sample databases for SQL 2005 as an addition to what you create.
January 8, 2009 at 9:33 pm
Here in northern Ohio, high for the week 27, evening temps in the high teens, snow admittedly flurries each of the last 3 days. Week ahead forecast day time...
January 8, 2009 at 9:28 pm
You can use SUSER_SNAME
(ref:ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/11ec7d86-d429-4004-a436-da25df9f8761.htm)
to retrieve the FK from the users table and then using the FK in a join to retrieve the full name from your...
January 7, 2009 at 6:18 pm
A question for Lynn Pettis
I like the open space here in Colorado, even though Colorado Springs does seem to keep growing.
A long long time ago (no not the opening to...
January 7, 2009 at 4:22 pm
Viewing 15 posts - 2,671 through 2,685 (of 3,221 total)