Download necessary components (Not Office itself) from:

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access...

First returns just the date

declare @date Char(10)

set @date = convert(char(10),getdate(),101)

SELECT @DAte

This will return the date with a time of midnight

DECLARE @midnight DATETIME

SELECT @midnight = DATEADD(dd,0,DATEDIFF(dd,0,getdate()))

SELECT @midnight

Look at this and add...

Will this suffice?

DECLARE @StafNr VARCHAR(15)

SET @StafNr = 'Unknown_201'

SELECT CAST(SUBSTRING(@StafNr,CHARINDEX('_', @StafNr,1)+1,3)AS INT) + 1

Result is 202

Paul White - tried this in Query Analyzer - yup still have SQL 2000 on an older desktop - Ran the following 3 times .. same result each time

CREATE ...

halifaxdal

I would discourage your doing what you seem to imply you need to do.

What would happen if the user of your progam input into Textbox one text such as:

DROP TABLE...

Jeff - Allen White (MVP) is one of the leaders in setting up

SQL Sat#60 .. He is also the leader of the Ohio North Special Interest Group (SQL...

Hmm seems like we have a disagreement on moving the Resource DB.

Now which reference is Correct can it be moved or not? ? ?

http://technet.microsoft.com/en-us/library/ms345408(SQL.90).aspx

From the above reference (Bold emphasis...

Never been there but just slightly south of Colorado Springs is the Broadmoor resort complex ..... Always liked the "Golden Bee" that english bar transported...

Will this assist you?

CREATE TABLE #T(Something VARCHAR(20))

INSERT INTO #T

SELECT '12' UNION ALL

SELECT '.3' UNION ALL

SELECT '-' UNION ALL

SELECT ',1.0' UNION ALL

SELECT '>60' UNION ALL

SELECT '> 60' UNION ALL

SELECT '12,> 60,xyz'...

If you would post your table definitions some sample data (not anything that would divulge company confidential info), desired result from the sample data. To learn how to do...

Steve .. is your place north or south of Denver? I used to travel to and from the old Denver (Stalpeton) airport to Pubelo failry frequently, passing that old...

Your post appears to be somewhat confusing... if the date is only stored as a date say 09/04/2010 ... then how do we know if that entry was for the...

IN order to receive tested help please post the tables definition, some sample data and the required results.

Refer to the first link in my signature block for simple instructions on...

Did you also install SSMS for SQL 2008?

1. Open SSMS - right click on the database name.

2. In the drop down list that appears - Select "Properties"

3....

I tested this and it did work (SQL 2005)

DECLARE @Table NVARCHAR(1000)

SET @Table =

'CREATE TABLE [dbo].[filestats](

[statskey] [int] IDENTITY(1,1) NOT NULL,

[dbname] [varchar](128) NULL,

[fName] [varchar](2048) NULL,

[timeStart] [datetime] NULL,

[readsNum1] [bigint] NULL,

[readsBytes1] [bigint] NULL,

[readsIoStall1]...