SELECTRight(Replicate('0',15) + AccountNumber,15) AS 'AccountNumber',

BankNumber,

--CASE SubProductCode WHEN '374' THEN 'P' ELSE 'D' END AS DDA_Prepaid_Indicator

CASE WHEN SubProductCode IN ('374','376')

THEN 'P'

...

Try this

DECLARE @CurrentDate DATETIME --= Fireball_Configuration.dbo.PreviousBusinessDay()

SELECT @CurrentDate = MAX(DATE)

FROM Fireball_Reporting..Reporting_LoanPrices

DECLARE @CompareDate DATETIME = Fireball_Configuration.dbo.PreviousBusinessDayByDate (@CurrentDate)

DECLARE @count INT = 5

DECLARE @EmailHeader VARCHAR(500) = Fireball_Configuration.dbo.GetConfigurationValue ('Fireball', 'EmailSettings - Header')

DECLARE @EmailFooter VARCHAR(500) =...

Ummm. . .

Cadavre (12/21/2011)

---

My random guess: -

DECLARE @CurrentDate DATETIME --= Fireball_Configuration.dbo.PreviousBusinessDay()

SELECT @CurrentDate = MAX(DATE)

FROM Fireball_Reporting..Reporting_LoanPrices

DECLARE @CompareDate DATETIME = Fireball_Configuration.dbo.PreviousBusinessDayByDate (@CurrentDate)

DECLARE @count INT = 5

DECLARE...

My random guess: -

DECLARE @CurrentDate DATETIME --= Fireball_Configuration.dbo.PreviousBusinessDay()

SELECT @CurrentDate = MAX(DATE)

FROM Fireball_Reporting..Reporting_LoanPrices

DECLARE @CompareDate DATETIME = Fireball_Configuration.dbo.PreviousBusinessDayByDate (@CurrentDate)

DECLARE @count INT = 5

DECLARE @EmailHeader VARCHAR(500) = Fireball_Configuration.dbo.GetConfigurationValue ('Fireball', 'EmailSettings - Header')

DECLARE @EmailFooter...

Does this help?

SELECT

--FROM SalesReportRMS

a.TransactionNumber, a.StoreID, a.Transaction_Date, a.CustomerID, a.StoreName,

a.LogicalStoreName, a.ItemLookupCode, a.Description, a.ClassID, a.Quantity, a.FullPrice,

a.Full_Cost, a.SalesRepID, a.NAME, a.Ship,

--FROM [10.1.1.18\RMS20].ICLHQ.dbo.Customer

b.EmailAddress, b.PhoneNumber, b.FirstName, b.LastName, b.HQID

FROM dbo.SalesReportRMS AS a

JOIN [10.1.1.18\RMS20].ICLHQ.dbo.Customer b...

CREATE SCHEMA has to be the only statement in a batch.

To get round the limitation, use dynamic SQL.

IF NOT EXISTS (SELECT *

...

Either a REPLACE...

aaloneftis (12/21/2011)

---

Thanks for the input. Also many thanks for the interesting links ... good reading coming up.

Obviously I need to work on this as I don't think it is...

BEGIN TRAN

CREATE TABLE yourTable (

[yourTable ID] INT IDENTITY NOT NULL,

[First Name] VARCHAR(20) NOT NULL,

[Last Name] VARCHAR(20) NOT NULL,

[Full Name] AS [First Name] + ' ' + [Last Name],

[Initial + Last...

Please read this article (http://www.sqlservercentral.com/articles/SQLServerCentral/66909/) on how best to post performance problem questions. Help us to help you!![/url] 😉

Koen Verbeeck (12/19/2011)

---

Ahem. You all are older than me.

I'm a child...

Can you read the article I linked to about how best to post sample data and DDL? Personally, I don't really have the time to turn your text data...

DDL? Sample data?[/url]

Yes, you only inserted a few but he inserted all and...

I don't think his complaint with your code was to...