you can do it with a subselect of something featuring row_number(), or simply with a GROUP BY:

With MySampleData ([Record#],ManagerID)

AS

(

SELECT 370868,1427894 UNION ALL

SELECT 274658,1428292 UNION ALL

SELECT 274658,1428293 UNION ALL

SELECT 349883,1430095 UNION...

i'm very weak on the reason why i had to do that trustowrthy thing;

can you turn off trustowrthy, change the proc to WITH EXECUTE AS SELF, and...

Tom the way i've done it is like this: you'd just have...

it's right at the end: remove the last AND to see ALL dependancies, ro make it...

not an easy way...

every Login would need a user in each databaser, and each user would need to be added to a role that gives them read access and...

glad I could help!

Thansk for the feedback!

here you go...look at the WHERE statement at the end..specific column name, and must be a view...you can change that to fit your needs if needed:

/*

obj_nmcol_nmdep_obj_nmdep_obj_typedep_col_nm

GMAACCPACTTBLKEYVW_GMBENEFViewNULL

GMAACCPACTTBLKEYVW_CDBGACCOMPViewNULL

*/

DECLARE @ColumnName VARCHAR(100)

SET @ColumnName =...

asm1212 (5/26/2011)

---

Im not worried about the schema...The schema's are pretty much the same on both servers...there is just dummy data in test and he wants the real data from...

sounds like the...

Gopal Singh (5/26/2011)

---

Hello,

When I create table as per code data is inserted in first successfully as ENG_REF value Engg0000000000 but when i insert in second row it showing an error...

Gopal Singh (5/26/2011)

---

but i need this value can gone upto 4-5 million times, so can take datatype varchar(50) to varchar(max), then might it will allow me to enter increased the...

based on what David showed, i'd just make the column calculated based on the identity instead of using a trigger:

I don't know if you want preceedig zeros, or if Engg4592...

kr.nithin (5/26/2011)

---

Hi,

I have an issue . The issue is that I need to retrieve data such that Travel Date should be greater than the current date. But my problem is...

blocked at my job too....

uhh..no.

intellisense as well as syntax highlighting are contained in a DLL called from the client app of...