Rewrite your stored procedure so that it always gives the same amount of columns. If the selection dictates you don't need certain columns, fill them with NULL values.

In the report,...

Great question, thanks!

L' Eomot Inversé (2/13/2013)

---

GilaMonster (2/13/2013)

---

Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people...

This question could've been better if the question asker realized there are more than one countries in the world.

Interesting question, thanks.

GilaMonster (2/13/2013)

---

Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't...

DT_DBDATE doesn't store the time. Try using DT_DBTIMESTAMP instead.

When you use SSIS, your source should be stabilized before you start writing ETL.

Once it does stabilize, I would also go with CDC, as opc.three mentioned.

Hugo Kornelis (2/11/2013)

---

I'm surprised you didn't know this. Integer is actually the official name; int is an accepted abbreviation.

*cough* I have to retract the above. That's what I always thought,...

Very interesting question, thanks Steve.

For me the question was more about the fact you can use Integer instead of int. Didn't know that 😀

The question cleverly had no color coding on the word Integer,...

You can use dtutil to deploy your updated package to the server.

Wrong forum I guess, this site is about SQL Server, not really about Cognos.

Anyway, looking at the error it seems you have a permission issue. Maybe you should specify a...

ashishjain (2/6/2013)

---

Hi angjoni,

You can use below code to perform this operation:

create table test99 (column1 int, column2 int, result int)

insert into test99

values

(50,1500,0),

(100,0,0),

(40,0,0),

(30,0,0)

declare @col2 int = 1500

select * from test99

update test99

set @col2...

Nice question Steve, thanks.