Isnt that what you wanted ?

Are you not making this more complicated that it needs to be ?

Select * from table where col = '2'

Will do what you need.

If a user were running a report and you set the database connection to impersonate then Yes that would happen , ive not used analysis server but am assuming it...

If you create a data-driven subscription on the report, the that will execute a stored procedure to use as the report parameters. Will that do you ?

I still dont see how you are getting

ResID S1 S2 S3 S4 S5 S6

1 0 1 1 1 0 1

2 1 0 1 1 0 0

3 1 1 0...

That plan looks pretty much ok , index seeks all the way through , Actual row counts near estimated.

Can you post the actual plan for the full query now ?

http://www.sqlservercentral.com/Forums/Topic775229-338-1.aspx

I think you mean Jibber Jabber :angry:

No please , no thank you , just "Sort my problem"

andersonrj18 (8/21/2009)

There's a problem, If I have more tha one value in each table...modifying the last example, like that!!

Table1 - Z=1, Z=2

Table2 - Z=1,Z=3,Z=3

Table3 - Z=1,Z=2

My question is, in your...

Something like this ?

Create View UnionView

as

Select Z from tablea

union all

Select Z from tableb

union all

select z from tablec

go

Select Z,count(*)

from UnionView

having count(*) >=2

with recompile means that it will be recompiled on each and every execution of the procedure.

Its not an issue of wrong date , its simply NOT a date.

Consider

insert into dateformatting values('2011900')

insert into dateformatting values('19000102')

It would be asking a hell of a lot of SQLServer to...

The link i gave above gives full details of this. ...

Please see this link which will answer a lot of the issues you will have.

http://www.karaszi.com/SQLServer/info_datetime.asp

Feel free to post back after that with any other questions

Can you provide some further example of the data in both tables ?

For instance how is the BitString '1010' represented in Table1 ?

---- EDIT

Just for clarification , i may be...

SqlAgent is responsible for executing and scheduling tasks, so again SSIS is not needed.