Yea this is true!

I cannot see any results from Hari's T-SQL, everything is empty! 😛

Very easy: right click on the table and click View Dependencies and you will see all other objects related to that table!

You can see the results in attachment!

😎

Yea very nice info Steve I like it ...Congratz to all the people that spend the time offering help!

:hehe::hehe::hehe::hehe:

Dont' do double post!

Every reply should goes

http://www.sqlservercentral.com/Forums/FindPost640489.aspx

Dont' do double post!

Every reply should goes

http://www.sqlservercentral.com/Forums/FindPost640489.aspx

yea you have too many things here to know ... that's nice to help each-other!

You are welcome!

Yes it is true like few...

ABOSS is BOSS of A department

A1 is Team Leader of department A

A2 is employee

So

A Boss

A1 Team Leader

A2 Employee

The hierarchy is BOSS >>> BOSS-TeamLeader >>> BOSS-TeamLeader-Employee

There is the test:

--CREATING TABLE JUST FOR TEST

CREATE TABLE AAA

(

ID INT IDENTITY(1,1),

PLACE NVARCHAR(40),

DATE DATETIME

);

--JUST TO ADD SOME DATE VALUE IN FORMAT DD/MM/YYYY

SET DATEFORMAT DMY

--INSERTING VALUES IN TABLE

INSERT INTO AAA

SELECT...

cotzan

Let me know that results from the query above is ok!? :w00t:

WITH IDD

AS

(Select ROW_NUMBER() OVER (PARTITION BY StCompanyName ORDER BY StCompanyName) AS IDNR, StCompanyName,StAccountName,StProcDTime,BoIsActive,StNotes FROM vwPurchase)

SELECT * FROM IDD

WHERE IDNR =1

And be sure that you do not have any Foregin Key from other tables which is referenced to the PK ( Your Clustered Index)

ALTER TABLE YOUR_TABLE

DROP CONSTRAINT your_constraint_name

Abhijit More (1/16/2009)

---

its wrking used the same query olny retrived distinct records from tmpPoj..:)

SELECT tmp.PojID, tmp.Cat,

...

http://en.wikipedia.org/wiki/JOIN