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)

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)

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

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

One option would be to do a side...

bitbucket-25253 (10/20/2010)

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...

This should do it for you. Remarks are in the code.

DECLARE @date datetime,

@month tinyint;

SET @date = '20101230';

-- get the month of the...

Check out the last three columns in the new table......