Msg 145, Level 15, State 1, Line 1

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

I am getting above error When am trying with...

Please find attachedn abc.png..

still is not working with the query.

Please help me on this

This works Great.. Thanks a lot

Person_Id field created with uniqueidentifier

Hi,

Please find the following few tables for your reference

--Person

Enterpriseid

Person_Id

LastName

FirstName

--Person_Relationship

Person_Id

Relations_Code

CreatedDate

--Person_Employers

Person_Id

Employee_id

Occuapation

Person,Person_Relationship and Person_Employers are tables.

The common field is Person_Id, But there is no Foreign Key relationship. Like this i have 3000 tables...

Still this query doesn't work, it is not pulling the common field name from all tables and just pulling few field and tables.. Please need more help on this.

Could someone please help me on this.. this is high priority

how to pull the output with select queries with examples or any website i can go through.. could you pls help on this..

Thanks a lot , this works fine.!!

This doesn't work, I am getting an error

Msg 402, Level 16, State 1, Line 369

The data types varchar and varchar are incompatible in the modulo operator.

CREATE TABLE PUBLIC

(

TestId INT,

TestCode Nvarchar(100)

)

@test-2 is the table variable.

Public table contains two columns.(Testcode and testid)

Using dynamic query

select @testquery =

'select testcode,testid from public where testcode like '% + @test-2 +%'...

I have mentioned the table for the example..

Thanks,

tony