Hi GilaMonster,

You are terrific. It works like a charm!!

Thanks you so much

Hi Orlando,

your query works like a magic. Thanks a lot. What I have done is that I have taken the records into a new table and then match the records...

Hi Thanks for your reply...

It is absolutely the same I am looking for. Thanks a lot. I will update the table from cte. Is there any chance to delete the...

My Sample data is looking like below. Sorry image is not working in my system.

contactidFirstNamelastnameofficeridemailcellphoneHomephoneworkphoneHomeAddress1HomeAddress2HomecityHomeStateHomeZipworkaddress1workaddress2workcityworkcityworkstateworkzip

1NiladriBiswasjfortwniladrri@gmail.comNULL257-098-3456NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

2NiladriBiswasjfortwniladrri@gmail.com232-567-879257-098-3456NULL114 Pacifica Ste 120NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

3NiladriBiswasjfortwniladrri@gmail.com232-567-879257-098-3456NULL114 Pacifica Ste 120NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

4NiladriBiswasjfortwniladrri@gmail.com232-567-879257-098-3456NULL114 Pacifica Ste 120IrvineNULLNULLNULLNULLNULLNULLNULLNULLNULL

5NiladriBiswasjfortwniladrri@gmail.com232-567-879257-098-3456NULL114...

if there is address is Available in last row (in this case row 6) we don't need to update. But if the row no 6 has not the address and...

OK..Thanks got it. Here is the query which will help

/****** Object: Table [dbo].[contacts2] Script Date: 3/4/2016 3:26:55 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...

Hi,

Thanks fro you reply. Next time I will be careful. Here are all the columns the table I have

contactid,FirstName,lastname,officerid,

email,Homephone,workphone,Fax,HomeAddress1,HomeAddress2,Homecity,HomeState,

HomeZip,Title,workaddress1,workaddress2,workcity,workcity,workstate,workzip

Hope it will help you. Please guide me.

Also let me know if...

Thanks for your reply.

I have seen it.But my requirement is to run the remote .exe file from my local machine from ssis package. I have also tried with process...

Hi Jeff,

Thanks for your quick reply.

The below link has helped me to solve my problems

Thanks once again.

Select the sheet from the checkbox and then import

Recently I have faced this kind of situation in my organization. Temp table and with cte is the best option in my opinion when there is no relation between the...

Hi Jeff,

Thanks for your reply...the issue is now solved. Here is the code

declare @CollectionDate date='10-30-2014'

select @CollectionDate

;WITH CTemp AS (

SELECT TransactionDate=CAST(@CollectionDate AS DATE) ,RemainingTransaction=1

UNION all

SELECT TransactionDate=DATEADD(MONTH,RemainingTransaction,@CollectionDate),

RemainingTransaction+1

FROM CTemp

WHERE RemainingTransaction < 9

)

select *...

Thanks Milos...........thanks a lot...you saved my day...

Hi Jeff,

I have forgot to mention it....Sorry for that.

if the remainingCollectonCount =8 and the frequency =12 then in the futurecashflow table the next 12 months will be added by 1...

I need to run it every fortnight. Today I am doing the same and almost one day it takes....