Hello Ninja's_RGR'us

i tried your calander but it is not executed in my sql.

Hello Sys..

i tried your code and i want to know if @year is leap year then

Thanks For replying me .

If year =2012 then @Last day is 29 ...then

what i need to chagne in this stored procedure.

Thanks

🙂

Thanks You so Much.....

Thanks Lowell,

But I have some condition with this fuction so i want to create this fuction instead of using another.

Thanks

Bhavesh

Thanks For reply but Can you provide me exact Solution...

I do not want to create calender table.

Thanks

Bhavesh

bhaveshp.dba (11/8/2011)

---

Hello All,

Please any can help me how to use dynamic sql. I don't know how to use dynamic sql .

Here I only used 3 conditon to insert record.but

I want...

THANKS FOR ALL REPLY 🙂

Thanks for reply ..but i did not understand.

you can create identity column column

create table "table name"

(seqi_id int identity(1,1),

phone number bigint

)

Thanks

Bhavesh

Hey,

Can you create stored procedure for that?

Create procedure usp_insert_update_move

as

begin

insert table a

select * from "Different source"

update table a

set "columnname"= ....

where =...

select * into #aa from table a

insert table B

select...

🙂

Thanks

IT's Work

Thanks

Did you execute(debug) your package manually in 2008?

Please check again all connection manager ...(not only OLE-DB Connection manager) and use 2008 connection manager.... and try...

Thanks