That does not work. It takes it as 123 at the source while reading

Hi,

I am new to Teradata but have been working on SSIS. We have a POC requirement to pull data from Teradata into SSIS package and write the data back...

It can be a value assigned to a variable or an expression

The service does not work for local instance .i gave IP address\sqlexpress in server name and used window authentication.Is there something else I need to use?

thanks all for your replies

Can you point me to some documents where I can know about execution plan and how query is actually executed.

This works..Subtract 1 second from first date of next month

declare @cob_dt as datetime

select @cob_dt='2012-2-12'

select DATEADD("s",-1,DATEADD("dd",-(DAY(DATEADD("mm",1,@cob_dt))-1),DATEADD("mm",1,@cob_dt)))

Thanks all

I also tried select ([IsLogistics]=="Y")&&(dateadd(m, datediff(m, 0, TradePeriodStart), 0))<(dateadd(m, datediff(m, 0, getdate()), 0))?TradePeriodStart:TradePeriodStart but did not work

I need a solution wherein I can use my temp table outside the session also

Thanks all for the replies:)

I just modified the above query a bit so that it gives me the row with largest efct_end_dt for a group of strategy_id's

SELECT efct_start_dt,efct_end_dt,*

FROM (

...

actually there are a number of strategy_id in the table which are getting created and expired.My below code worked:-

(Select Strategy_id,efct_start_dt,efct_end_dt From publish.dim_strategy

Where strategy_key in

(

...

Your query is giving the same results as mine..just efct_end_dt is null should have been outside the brackets..(i commented the text in your query)

Anyways,your idea has solved my problem.Many thanks:)

Select...

your query is giving me strategy_id 1 also.I dont want this because it has already expired and not coming for the first time.

My below query gives me the result but...

yes it is like this..i want efct_start_dt,strategy_id of 2 and 3..i dont want strategy_id 1 as it has 2 rows in the table

the strategy_id has multiple entries .One of these entry may have efct_end_dt as null if the strategy_id has expired.The unique key in table is strategy_key which is a surrogate key