Thanks for your support

i found the solution

find below query

select MAX(FLOW_LINEUP_NAME) from iPROMIS_BI_FLOW_LINEUP where FLOW_LINEUP_NAME like '%2CUF%'

sorry it my mistake not mention column desciption,

FLOW_LINEUP_CR_DT -> while insert datetime

FLOW_LINEUP_MD_DT --> Modified insert datetime

Thanks for you reply...

Thanks

Ranganathan palanisamy

thanks for your anwser

please find the table structre

Column

FLOW_LINEUP_ID

FLOW_LINEUP_NAME

FLOW_LINEUP_DESC

METER_ID

FLOW_LINEUP_ACT_CALCNAME_ID

FLOW_LINEUP_ACTUAL_CALCTYPE

SIMTO_TAG_ID

FLOW_LINEUP_SIMTO_CALCNAME_ID

FLOW_LINEUP_PLAN_CALCTYPE

FLOW_LINEUP_FLAG

FLOW_LINEUP_CR_DT

FLOW_LINEUP_MD_DT

FLOW_ID

datatype :

int

varchar

varchar

int

int

char

int

int

char

varchar

datetime

datetime

int

No , i am not english only.

Thanks for your effort i got result.

Thanks for your suggestion,

find the insert command 3 tables

1.INSERT INTO LINEUPBACKUP

([FLOW_ID]

...

Thanks for your reply,

Actually i am passing the product id only so if 2 sub product we are getting 2 set of results, i need to avoid those type of...

Thanks for Reply SQLRNNR,

Table Data:

Startdate ...

Thanks

I got solution because single quots problem ,

'SELECT E.EventID, isnull(E.EventName,'''') as EventName,

E.EventDate, E.venue,

E.VenueCity, E.VenueState, E.VenueCountry, E.EventStartTime, E.OnSaleDate,

E.SalesGross, E.TicketUnits, E.EventCapacity, E.Milage, E.BrandID,

ISNULL(B.BrandName, '''')...

Thanks for reply.,

we got solution from excel file...

Thanks for Reply.,

i need one more suggestion as well

My design

Excel source1 Excel source2

...

Hi guys i got solution please below query

WITH Managers AS

(

--initialization

SELECT EmpID,supervisor_ID

FROM...

Hi

Thanks for reply., i am using sql server client only., Database connection remote path only.,

In Developer Machine every thing is running fine.while BIDS it's working fine.,...

Hi.,

Thanks for reply.,Actually i am doing the testing for developer machine only.,

Sql Version Detail:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb ...

Hi.,

thanks for reply, i thing you are expecting this answer only

Version:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07...

Hi Elliott Whitlow.,

Thanks for your reply.,

SQL server Details...