See this:

http://msdn.microsoft.com/en-us/library/ms177563.aspx

Noooo problem!

-- Test data:

declare @a as table

(

row1 int,

row2 int,

row3 int,

row4 int

);

insert @a values (0,6,0,0);

insert @a values (0,0,30,0);

insert @a values (4,0,0,0);

insert @a values (0,0,0,18);

--select * from @a;

-- Example solution:

select

max(case when row1...

Klingon

eugene.pipko (10/3/2012)

---

Thanks for replies,

I don't use SSIS.

Not sure if it makes sense, but I was hoping to place the check for number of rows in table A (function call...

Visual Studio 2010 & SSDT Database Compare makes this very easy - if you're using it.

Iron curtain

Zeal-DBA (10/3/2012)

---

what i did actually i created a same table as mentioned in attached image and created index on each of the column then ran count(*) and saw execution plan...

Which rows as columns & columns as rows?

You could post your expected results & what you've done so far. This might get a better answer.

Do you mean like this?

--========== TEST DATA ==============

declare @a as table

(

id int,

name varchar(50),

description varchar(50),

created_timestamp datetime,

created_userid char(3),

modified_timestamp datetime,

modified_userid char(3),

display_order int,

driver_type int,

application_id int,

formula...

Generally, index seeks are...

Zeal-DBA (10/3/2012)

---

one last question,

suppose i am using select queries like this frequently

select * from T where id =6

select * from T where ch ='!'

select * from T where na ='sue'

so...

No they're not the same.

The first will allow seeking on all 3 columns, while the second will only allow seeking on id - although the optimiser may still...

How about making the second job step script check the table with COUNT(*) & return if the table is not empty.

If you need to wait between steps 1 & 2,...

That's up to the optimiser. If it decides there's no benefit in using an index, it won't use it.