karen.blake (10/21/2010)

---

Hi All,

Thank you so much for your help, it's appreciated.

A good night's sleep and looking at this has made things much clearer. I will work on it today and...

Pass all of the required tests at an approved testing center.

No excuse... here's a free copy for you to install and...

@paul-2 - interesting colours on your new avatar.

Stefan Krzywicki (10/20/2010)

---

While there's always the chance documentation made sense while you were writing it and now doesn't, just like the code, it certainly has a better chance of helping...

You might want to look at utilizing the OpenRowset function to write the data to the file instead.

I assume that you've tried each of these? What did you find out when you tested them?

BTW, what college do you go to? What is your professor's name?

Looks like it's time for a quirky update solution:

IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp;

-- This primary key is crucial. If your table doesn't have a clustered index

-- on...

sqwasi (10/20/2010)

---

Lutz, thank you! I will read through that link. Today I was able to modify my code and I got it to work. I ran it...

chris.s.powell (10/20/2010)

---

Unfortunately you cannot do a direct upgrade from SQL 7 to SQL 2008, please review the following article for acceptable upgrade versions.

http://msdn.microsoft.com/en-us/library/ms143393.aspx

One option would be to do a side...

bitbucket-25253 (10/20/2010)

---

Blake

You will want to create a parameterized stored procedure along the lines of:

CREATE PROC [dbo].[Blake]

@Start DATETIME

AS

DECLARE @Syr VARCHAR(4)

DECLARE @Smon VARCHAR(2)

SET @Syr = DATEPART(yyyy,@Start)

SET @Smon = DATEPART(mm,@Start)

SET...

Edit: Didn't read the entire post by OP.

natalie,

First, thanks for posting the CREATE TABLE and INSERT statements - believe it or not, it really does help us.

Second, the most likely reason that people haven't been helping you...

ColdCoffee (10/20/2010)

---

Wayne is...

First, you need to know if you want the data stored into separate columns in a permanent table, or just returned through a select statement.

This code handles both ways. See...