Hi,

You would have a much greater chance of getting a response if you post ddls and sample data in a readily consummable format, along with the query you have already...

Sorry if I have caused you confusion here, my suggestion was that you find an OLE driver for the database format you are working with. Really just trying to...

Hi there,

I have no experience of Dbase file types you refer to, though I have worked a lot with Foxpro to MS SQL imports. I have have had problems...

Here are a couple of uses I can think off, although many will probably argue — and probably with due cause, I'm not looking to fight here 😉

1) Some administrative...

Rick Kurtz (7/29/2009)

---

Excellent questions from everyone, and I should've addressed them in the original post.

Suffix is not always 1 character, but can be multiple values from 1 to 3 characters...

Why are you shrinking your databases? What problem are you trying to solve?

What is the recovery model you are using? If 'full' you'll need to backup...

Hello!

If you can provide some tables, sample data, queries you have already written, and the output as you want it to look, someone will be able to help. Sorry,...

Are you sure? http://msdn.microsoft.com/en-us/library/ms188776(SQL.90).aspx... reason I asked was I don't have a 2005 instance to test, but according to BOL it gives number of rows.

///edit...

You have to include object name...

You'll need something like: group by dateadd(dd, 0, datediff(dd, 0, Obstime))

If this runs slowly you could look at adding a persisted calculated column with the value dateadd(dd, 0, datediff(dd, 0,...

Does sp_spaceused work for 2005?

How many records are we talking about here?

Are the indexes appropriate to the query(s) your are have problem(s) with? I am unclear on your problem and therefore how to help without further information.

The following...

Have you got any indexes on table in question? Adding appropriate indexes would probably be the best solution, you would get better performance without having to change code in...

Few questions:

1) Is suffix always 1 character? If not, any chance of more representive sample data?

2) Is it possible to add a calculated column to table APDOC?

3) And while...

The following code works for the examples you posted:

DECLARE @Input TABLE ([Date] VARCHAR(14))

INSERT INTO @Input

SELECT '20Jul 15:46:1' UNION ALL

SELECT '22Jul 06:21:8'

SELECT CONVERT(DATETIME, SUBSTRING([Date],1,2) + ' ' + SUBSTRING([Date],3, LEN([Date]) -...