I'm not entirely clear on what you're asking.

Is what you need a list of the possible start and end dates for all weeks in a year? If so, have...

Will something like this do what you need?

SELECT

Material.Name,

MfgDate,

MAX(StoredDate) AS StoredDate

FROM

Material

LEFT OUTER JOIN Store

...

You just gotta love posts like these:

http://www.sqlservercentral.com/Forums/Topic703170-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic703094-147-1.aspx

I asked both the same things on his other post, which appears to be pretty much the same junk.

How are you calling the proc? Is it part of a scheduled job? Part of an application? Something else?

First, if there's supposed to be XML in the post, you need to surround it with the correct tags, or convert the carrets to HTML codes.

Second, did you have a...

I was going to comment about how this isn't a valid test, but it's already been covered more than adequately. Good discussion.

YSLGuru (4/22/2009)

---

GSquared (4/22/2009)

---

One way you might be able to get around problems with adding columns to tables is to create a view with the computed column in it and index...

Florian Reischl (4/22/2009)

---

Hi Gus (hope I am allowed to call you Gus)

I just tried again and I think I figured out the problem. It depends on the C# code. As...

What's the language setting for the server? Not the database, the server. (Properties on the connection in Management Studio.)

One way you might be able to get around problems with adding columns to tables is to create a view with the computed column in it and index the view,...

Pakki (4/22/2009)

---

Hi ,

Just a wild guess, did not try reproducing it.

I think since we dont have that 'Set NoCount ON', after every select the message about the number of...

Just to be sure, I also tried the original script, and the final raiserror worked as expected.

BEGIN TRY

RAISERROR ('Test Error Raised', 16, 1)

END TRY

BEGIN CATCH

DECLARE @ErrorSeverity INT,

@ErrorNumber INT,

@ErrorMessage NVARCHAR(4000),

@ErrorState INT,

@ErrorProcedure...

Also tried this:

begin try

raiserror('Error', 16, 1)

end try

begin catch

select 'First'

print 'First'

select 'Second'

print 'Second'

raiserror('In Catch', 16, 1)

end catch

I get both selects, both prints, and the error message from the raiserror in the...

I just tried this:

begin try

raiserror('Error', 16, 1)

end try

begin catch

select 'First'

print 'First'

select 'Second'

print 'Second'

end catch

I got both selects and both print commands.

@@Version = Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)...