Viewing 15 posts - 1,291 through 1,305 (of 2,452 total)
does this work for you?
DECLARE @SAMPLE TABLE
(
id_Contract INT NOT NULL
,nm_ContractType VARCHAR(25)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2014 at 8:24 am
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.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 27, 2014 at 12:22 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2014 at 4:19 am
pwalter83 (8/18/2014)
sgmunson (8/18/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2014 at 10:23 am
SteveEClarke (8/15/2014)
I have data in one table...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2014 at 2:04 am
carlos cachulo-318532 (8/13/2014)
REF DESIGN ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2014 at 12:48 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2014 at 12:30 pm
pwalter83 (8/12/2014)
John Mitchell-245523 (8/12/2014)
Use ROW_NUMBER() over that first column, and just select the one where the row number is 1.John
Thanks John,
The problem is how do I differentiate between NATBX7686 and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2014 at 9:30 am
what datatype is "em.EmployStatus "?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2014 at 10:47 am
rollercoaster43 (8/8/2014)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2014 at 10:14 am
what have you checked already?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2014 at 7:33 am
maybe something along these lines??
SELECT
TableA.city
, TableA.somefigure + (TableB.somefigure * 2.45)
FROM TableA INNER JOIN
TableB ON TableA.city = TableB.city;
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2014 at 1:07 pm
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)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2014 at 11:09 am
ronan.healy (8/5/2014)
anyone any ideas on this. need to try get this sorted this week if possible
it will be a whole lot easier for us if you were to post some...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2014 at 2:01 am
...also...please provide expected results based on your sample data...thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2014 at 2:03 pm
Viewing 15 posts - 1,291 through 1,305 (of 2,452 total)