Comments by Member 10833473

Member 10833473 1-Jul-22 10:04am View

I am trying to insert values from Table C, which joins from Temp table and It should insert into Table A. All this statements should run in 1 query. This is the requirement. Thanks.

Member 10833473 1-Jul-22 8:41am View

Ok, So If I want to insert values, What I should change in that code?
Can You frame it in above code and share. Thanks.

Member 10833473 23-Nov-21 7:29am View

Its adding half an hour more in the above time, So whatever time is in out Input, It gives 30 minutes plus. Thanks

Member 10833473 23-Nov-21 6:11am View

This format is not working Los.

Member 10833473 22-Nov-21 7:14am View

Thanks, But Its not working too.

Member 10833473 3-Mar-16 10:04am View

Hi,
Thanks for reply
I got the error in second select somewhere..

Member 10833473 1-Jun-15 2:12am View

Thanks for your reply,
But can we do it from configuration So we can specify date to SSIS configuration table? If yes , then how to achieve this?

Member 10833473 28-May-15 0:16am View

Hi All,
Can anyone help me to achieve this?

Thanks in advance...

Member 10833473 19-May-15 7:49am View

Thanks Mantu for your reply,
But i have 12 execute task like this, So I have to change everywhere. Instead of changing in query, can we achieve through parameters in SSIS. Suppose we want to load for may 9th. So how can we pass this date as a parameter?

Member 10833473 19-May-15 1:59am View

I was using datepart(mm, Transaction_Date) from STG_Shipped_Invoiced table, so it gives month_no, and this month_no we can join with month_no of Cal_date table and fetch start_date from Cal_date table, so that we can use start_date for formula (Transaction_Date-start_date+1). This logic i have to put in above query, but i am not able to do.

Comments by Member 10833473 (Top 10 by date)