Database

Ebube wrote: set union constraint Union contraint ? Education is not a way to escape poverty — it is a way of fighting it.

See ankur, there are no stroed procedure in postgresql... I have search all the topics on postgresql and i found nothig about stroed porcedure in postgresql... But you can make your own functions and triggers... Ok, Bye...... Hope you are satisfied with this answer.

thankyou all

Which Version of SQL Server are you using. In SQL Server 2008, you can pass Table Value Parameter to your stored procedure and in such a case no need to pass delimited string of ID's. If not, you need to create a Table Variable and store the IDs in the Table Variable first using the Split UDF and then use the same in the statement. Also you can iterate through your table of IDs and then update the purchases table.

For database connections or any other configurable objects, in your SSIS Package use Configuration File as the value might be changing with environments. In the target envieonment, you just need to update the configuration file and it would work fine.

Well, it is easy enough to find the newest entry for a given owner in your setup: SELECT TOP 1 * FROM TBL_SWBOM_CHECKLIST_TEMPLATES WHERE LASTCHANGEBY = 'Joe Smith' ORDER BY LASTCHANGE DESC Wrap something like that in your INSERT and you should be good to go, at least for the first of your three records. MishaInTheCloud.blogspot.com

What database are you using - SQL 2005 onwards provided the WITH; command whicah can be used for recursive tree patterns like this.

If i add the presision also the same result..:-(

SQL Express requires the DB Engine also. I don't speak Idiot - please talk slowly and clearly I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury Driven to the arms of Heineken by the wife

If you have access to the Management Studio of SQL Server, try and check the property for the column of your table in design mode, check the Identity Specification property...

You can get a clue from a simple SQL query like Select distinct ID, ParentID, Name from dbo.tblTest where ID In (Select ParentID from dbo.tblTest) The output would be like ID ParentID Name ----------- ----------- ------------- 501 10001 Test1 502 10001 Test2 10001 NULL Region1 10002 NULL Region2 10003 NULL Region3

Generally speaking your queries are executed (processed) in the following order: 1. FROM 2. ON 3. OUTER 4. WHERE 5. GROUP BY 6. CUBE | ROLLUP 7. HAVING 8. SELECT 9. DISTINCT 10 ORDER BY 11. TOP "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Right ... haven't looked in to the 2008 solution but in 2005 it's as simple as: ID SecurityName ParentID Then you can use hierarchal queries (recursive CTE or common table expressions) to unroll the tree. Example: http://www.eggheadcafe.com/articles/sql_server_recursion_with_clause.asp[^] Jeremy Likness Latest Article: Hierarchal Data Templates in Silverlight Blog: C#er : IMage

I would use and else to trap the 2, -2 values Never underestimate the power of human stupidity RAH

This may help Pivot article[^] Never underestimate the power of human stupidity RAH

Try connectionstrings.com Never underestimate the power of human stupidity RAH

actually i can write sql statement to do that. in fact i written it as another view call qcr100f because i will use it to update anorher table. but i want to improve on this   giving that the gl_temp_cons has schema idkey   db_bal cr_bal   dcode   i want to be able to get the result i post above in with one view definition thanks for your concern

I don't know about SSRS, but a webarchive is in fact just a webpage. It's kinda difficult to put a page-break in a webpage, but this[^] site might help. Good luck :)

This sounds like the kind of thing you may want to do with a cube and Analysis Services. And here's a link to a blog post describing how to then integrate the .mdx query in Reporting Services. http://joeblog.homnick.com/Lists/Posts/Post.aspx?List=db4a6966%2D2b11%2D448d%2Da4ba%2D1550e74c89ba&ID=33[^] MishaInTheCloud.blogspot.com