Database

You can use the same data/query structure but instead of filtering on where personalityid = 2 you can use where personalitysubtype in (14,1,78). Have a look in WHERE IN in BOL. Never underestimate the power of human stupidity RAH

Thank you for your replies.

1. You are actually asking a BusinessObjects question, not a database question. 2. You will probably get better results if you ask on the appropriate site. Try http://www.forumtopics.com/busobj/about.php[^] Tim

ya there is way to decrypt stored procedure just go to below link you will get code for that http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5[^]

welcome

Deploy multiple copies of the client application! SQL Server is a server based database and as such is multi user by default. You need to build a client application (in c#) that connects to the database to manipulate the data, the client is single user with multiple deployments! Never underestimate the power of human stupidity RAH

Thank you both for your suggestions. I'll try it out in afew days and if I find a solution, I'll post it here. Thanks, Dirso

For SQL2000 using SQL Server Enterprise Manager: Right-click on the job, choose for all tasks/Generate SQL Script... Wout Louwers

never mind. update mytable set tbl.col_1 = tbl_col2 where col_1 is null

Hi, 1. wrong forum, this is not a DB question. 2. the .NET versions can live together, no worries at all. 3. the corresponding Visual Studio versions can live together too; the one you install last will dictate the file associations. 4. never versions of Visual Studio will convert your project files when opening them, making them no longer readable by older versions. 5. Why would anyone still use .NET 1.0 or 1.1? 2.0 has fixed a lot and added very useful stuff; 3.0 and 3.5 have added a lot more, not always very useful, functionality. And 4.0 will emerge pretty soon. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. [The QA section does it automatically now, I hope we soon get it on regular forums as well]

FINAL SOLUTION select case WHEN (DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 ) = 300 THEN (cast(DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 as varchar(10))+ ' Y ') WHEN (DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 ) > 300 THEN (cast(DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 as varchar(10))+ ' Y ' + cast (((DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate())) - ((DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12))*12 ) as varchar(10)) + 'M') WHEN (DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 ) < 300 THEN (cast(DATEDIFF ( month , '1999-10-26 12:30:02.960' , getdate()) /12 as varchar(10))+ ' M ') END

Thanks for the info!

Thank you guys, I've considered the WHERE clause, but each filter criteria already looks very complex (with 3 to 4 nested Select, subquery statements, a lot of nested WHERE statements too); so I thought using WHERE would make it too complicated for SQL to handle.

Thank you for the update.

:) Many Thanks all. Done successfully

ok，thank you for your help. I think I need to search other solutions, otherwise it will cost me too much time.

:laugh: :laugh: :laugh: I well understand! I started out as a test engineer, developing automated test systems for missiles. When I started, they were requiring us to model the Known Universe at each interface, then simulate every possible thing that could happen there. I argued that we could far more cheaply test the components in-circuit, on the theory that if the designer knew what he was doing, his circuit would work if all the components were within tolerance. If not, the circuit should be changed, along with the designer. In time I succeeded in convincing the US Navy of the merits of in-circuit tests. So they added in-circuit testing to their requirements, but kept the requirement to functionally test everything using the Known Universe model. Go figure...:~ "A Journey of a Thousand Rest Stops Begins with a Single Movement"

Thanks. it works. regards :)

Thanks for your reply. Unfortunately, I made the change with the same result. I have to say that this one really has me stumped. I'm using the sp_executesql way, but I would love to know why the command way isn't working.