What do you mean by not functional?

I am not sure you need the temp tables. Does this help?

IF (@TC = 'BUY')

BEGIN

UPDATE....WHERE A.TransType = 'BUY'

END

IF (@TC = 'SELL')

BEGIN

UPDATE....WHERE A.TransType = 'SELL'

END

IF...

Thanks Lynn.

The archive db did recover. I then shrunk its log. I expanded the prod log to a reasonable size given it normal processing/backup schedule.

Pretty resilent system despite my somewhat misguided...

I managed to shrink my prod logs to create some space. The archive db is still recovering, I'll let it go.

CREATE TABLE #Test

(

EffectiveDate DATE,

ExpiredDate DATE

)

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-02-14 00:00:00.000','2013-02-20 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-01-01 00:00:00.000','2013-01-02 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2013-02-03 00:00:00.000','2014-02-20 00:00:00.000')

INSERT INTO #Test(EffectiveDate,ExpiredDate) VALUES ('2010-12-31 00:00:00.000','2013-02-20 00:00:00.000')

SELECT

EffectiveDate,

ExpiredDate,

CASE...

Can you provide sample data?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Do you understand what the crystal code is doing and can you state that in plain english or are you looking for someone to...

As a former member of the dbo only club who initially used schemas for organizational purposes there are two lessons learned for me.

There may be performance implications (probably negligible)...

ScottPletcher (2/13/2013)

---

Grant Fritchey (2/13/2013)

---

Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is...

I have never been a tbl-er but I have been a usp-er.

Lately I put everything in a schema. Is this a reasonable statement as far as a best practice? Always...

SELECT * FROM sys.table_types

http://www.sqlservercentral.com/blogs/dknight/2011/03/14/passing-values-into-an-ssis-package-at-runtime-from-outside-the-package/

Here is a nice overview.

You can use configuration files or dtexec and the set parameter.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66500/

http://msdn.microsoft.com/en-us/library/ms162810(v=SQL.105).aspx

Thanks for setting me in the right direction...

CREATE TABLE #Holidays (HolidayDate datetime, IsHoliday char(1))

INSERT INTO #Holidays (HolidayDate,IsHoliday) VALUES('2013-02-18 00:00:00.000', 'Y')

INSERT INTO #Holidays (HolidayDate,IsHoliday) VALUES('2013-03-29 00:00:00.000', 'Y');

DECLARE @StartDate DATETIME

SET @StartDate...

This almost works based on a post by The Dixie Flatline here:

http://www.sqlservercentral.com/Forums/Topic649517-1472-1.aspx

His table has weekends in it, mine doesn't. I'm not sure where I can put the weekend...

I don't have a calendar table, its a vendor provided database with a holidays table only.

So I almost need to generate my calendar table on the fly. Or generate enough...