suryam (6/27/2013)

---

Actually client is going to spool this report on the basis of between transaction dates how many processed and pending according to branch and region wise. like bangalore for...

suryam (6/27/2013)

---

Thanks Phill, for your great suggession.

now here below are my table details

/*************/

create table #Mis

(

region varchar(50),

branch varchar(60),

trdate datetime,

reportcnt int,

pendingcnt int

)

insert into #Mis values ('Bangalore','BG40-BELGAUM','2013-05-06 00:00:00.000',0,1)

insert into #Mis...

You're not new here & should know the drill by now.

Please see the link in my signature - we need consumable DDL and INSERT statements to make it easier for...

This sounds fairly straightforward, but it's impossible to provide working code without some additional help from you.

Specifically, we need consumable DDL and sample data (in the form of INSERT statements),...

El_Mou (6/26/2013)

---

its not the best practice to create a calculated field by calling this stored procedure

so this is my context : i have a rapport who work perfectly...

Does that mean that you wish to read only those rows which have been inserted or updated in 'the last fifteen minutes' every time the job runs?

john_agger (6/26/2013)

---

This works!

create table #test( testtext varchar(30)

, MyRand varchar(5) DEFAULT(REPLACE( STR(...

dob111283 (6/25/2013)

---

Me being unable to fully explain what I'm doing with a foreign programming language somehow indicates that English isn't my native language? Where did you get your powers of...

sql2k8 (6/25/2013)

---

I will change the code like what you had said but when it was having issues with the Test_Code Column in the Table_Test1 . It should throw an error...

You're not new here,...

foxxo (6/25/2013)

---

You can enter a dynamic destination using an expression https://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/

Leave your existing settings as they are, the destination will be changed by the expression on execution.

You'll need a variable...

tiffanyb (6/24/2013)

---

Hi

I currently have text files sent monthly that need to be imported into SQL server. I'm new to SSIS and have fumbled my way through importing each one using...

dob111283 (6/19/2013)

---

Hey Sean, I went back and redid the whole thing. I changed the ExchangeRate function and and added an "exchangerate" column in the clearedtransacions table to calculate the exchange...

Can you just put the PKs of the main table to be deleted in the temp table, then index it, then join on that.

Also, you need to surround your deletes...

If you search your input file for the text 2314K, it should point you in the right direction.

It looks like whichever column that data is in is mapped to an...