does this work for you?

DECLARE @SAMPLE TABLE

(

id_Contract INT NOT NULL

,nm_ContractType VARCHAR(25)...

could you please confirm your expected results based on the sample data provided....

ps..thanks for the set up script...makes life so much easier.

whats the fiscal year start date......the excel sheet gives differing dates?

FISCAL_DATEFISCAL_MONTHFISCAL_QUARTERFiscal_Quarter_ShortFiscal_YearINTDATEObtained_FISCAL_WEEK

29/04/20062007M012007Q1Q1200720060429WK1

28/04/20072008M012008Q1Q1200820070428WK1

26/04/20082009M012009Q1Q1200920080426WK1

25/04/20092010M012010Q1Q1201020090425WK1

01/05/20102011M012011Q1Q1201120100501WK1

pwalter83 (8/18/2014)

---

sgmunson (8/18/2014)

---

Okay, so now the excuse for not explaining EVERYTHING is that some of the columns aren't in use??? Really? Sorry, but I'm done with...

SteveEClarke (8/15/2014)

---

I am trying to create a rolling data analysis of sales information for a given period, rolling 3 months, comparing to last years data.

I have data in one table...

carlos cachulo-318532 (8/13/2014)

---

ST

REF DESIGN ...

Please provide the following:

CREATE TABLE statements for your tables

INSERT INTO statements that populate your tables with relevant data...this data should fully represent the problem you are facing.

details of required results...

pwalter83 (8/12/2014)

---

Thanks John,

The problem is how do I differentiate between NATBX7686 and...

what datatype is "em.EmployStatus "?

rollercoaster43 (8/8/2014)

---

Hi All,

We have a very busy OLTP setup here.You can consider this as an Enterprise which has being doing Business across the globe for various clients.

Now, with respect...

what have you checked already?

maybe something along these lines??

SELECT

TableA.city

, TableA.somefigure + (TableB.somefigure * 2.45)

FROM TableA INNER JOIN

TableB ON TableA.city = TableB.city;

ronan.healy (8/5/2014)

---

CREATE TABLE [dbo].[BNYPortValInbound](

[PK_ID] [int] IDENTITY(1,1) NOT NULL,

[Country] [nvarchar](128) NULL,

[InvestmentType] [nvarchar](128) NULL,

[AssetType] [nvarchar](128) NULL,

[SecurityName] [nvarchar](128) NULL,

[CouponRate] [nvarchar](128) NULL,

[SecurityID] [nvarchar](128) NULL,

[MaturityDate] [datetime] NULL,

[HoldID] [nvarchar](128) NULL,

[CounterPartyRef] [nvarchar](128) NULL,

[Custodian] [nvarchar](128) NULL,

[MarketPrice] [decimal](15, 4)...

it will be a whole lot easier for us if you were to post some...

...also...please provide expected results based on your sample data...thanks