sry john,

i didn't see ur post, coz that time i was editing my post. otherwise no need to do the same work for twice.

😎

@prakash : hope u understand ashuthinks requirement

as per ashuthinks requirement i generate some sample data and generate the result. as he didn't provide any DDL and...

this is the o/p of the query

nameregionareapopulationgdp

indiaaisa2000012000008

chinaaisa2000012000008

iranaisa2000012000008

pakistanaisa2000012000008

do post what is your desired result.

hope u got ur answer from cad, although i found this post may be useful for you.

http://beyondrelational.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

>>want to select

List the name and region of countries in the regions containing 'India', 'Iran'.<<

as per ur requirement you can try this one

create table #bbc(name nvarchar(20), region nvarchar(20), area nvarchar(20),...

i am completely agree with jeff. and manipulating the query as per him

UPDATE p

SET Part_Cost = I.Vendor_Cost

FROM PART p inner join Part_Supplier PS on p.partid=ps.partid

INNER JOIN Inventory I on I.Part_Id...

u can simply put inner join and get the desired results. hope this is what u want

select cmpusr.usrid,cmpusr.cmproleid,cmpusr.loginname,cmpusr.systemflag,cmpcomprl.roletype,cmpcomprl.cmpperid,cmcomppers.*

from cmpusr inner join cmpcomprl on cmpusr.cmproleid=cmpcomprl.cmproleid

inner join cmcomppers on cmcomppers.cmpperid=cmpcomprl.cmpperid

where cmcoppers.compname like...

hey i got the solution.

it was posted by lowell earlier, tnx buddy.

i m posting it again for duplication. :)))

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT ''LoadSequence'',''Entity'',''EntityType'',''IsNewEntity'',''InsertEntity'',''EntityLogic'',''CheckDuplicate''" queryout C:\Users\ghanshyamk\Desktop\aa.txt -c -T'

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT...

Thanks thomas,

But i wanted to it through BCP is there any way to do it?

If you have same old Backup u can restore that. other wise some 3rd party tools are there, through u can do that.

ALTER PROCEDURE cj_Customers_Search

@SearchText varchar(250),-- its a date '2011-02-02'

--@SearchDate DateTime,

...

i think u can do it,

get all the index names from sys.indexes and put into a temp tables from database1 and database2 and then put a query to just...

I think your date format is wrong

@searchstring should be in 'yyyy-mm-dd' format or you can convert it to datetime

convert(@searchstring as datetime)

u want to send search string as datetime then just change it to this

WHERE ' +' [' +@FieldName +'] '+ ' = ' +'''' +@SearchDate+''''

welcome 😛