it would look like

WHERE '+ ' [' + @FieldName + '] '+ ' = ' + Char(39) + @SearchText + Char(39)

above solution will work or u can just add '[' and closing brackets ']' just before and after your column name variable.

another way to do that is to use openrowset or openquery function.

for more details you can follow these links

http://sqlblog.com/blogs/buck_woody/archive/2010/03/16/using-linked-servers-openrowset-and-openquery.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140963

my problem is in 2005 server the same query is taking less time compare to 2008 server and the time difference is around 10 min. indexes are same in both,...

if you update all columns from table2 to table1 u can use merge,(for more u can check BOL) or if u want to update a set of columns then u...

I think u can do it though a rank funtion, rank it via as per your indid,

if u wanna to get help post your ddl and some sample data properly.

if...

you can do it through an outer join.

it might look like

update emp1 set emp1.col1=emp2.col1,emp1.col2=emp2.col2

from emp2 left join emp1 on emp2.id=emp1.id

thats grt, i will check it once for sure, as i use redgate sql prompt i found it very net and clean product for sql formatter, but the only pain...

Is there any way to do it from sql server logs.

no i don't have any, its a development database so we don't take backup at regular basis.

i think that one, where u r stucking, just start it once and try it should work, i also have faced the same problem. i have done the same it...

once u set up sql server in remote machine u will be able to access it but following condition has to be met.

1) go to configuration manager and enable tcp/ip.

2)...

It will work u just need to change something

UPDATE Community

Set NetworkLogin = 'c' + cast(id as varchar(255))

FROM Community c INNER JOIN

Constituencies cn ON c.ID = cn.ID

WHERE cn.ConstitCode = @PC

in join...

specially lowell, i will try to manipulate the code u have given to me.

thanks all,

for your replies.

thanks all,

as per sean, i am thinking to come up with a solution that at the time of saving the datetime i have to save the offset of it with...