select employeename from employeemst where salaray = (select max(salaray) from employeemst.

ur way seems to be good enough though

thanks for the info

hi

I can give you some tips.

Check Whthr the hardware configuration is really the same and any other applications running in one server are not running in the other server.

Check the...

Andrew

I may have completely misunderstood your issue still here are my thoughts

"I thought of a TOP to get the first row, unioned with the rest, but in the second part...

hi

would DDL triggers help here? of course DDL triggers are available only in SQL 2005.

hi

u can right click on the view and select "script view as"  to script the view to a new query editor window.

for creating keyboard shortcuts for a procedure or...

dont know if i have understood ur problem correctly but this what i have to say.....

This will update column1 with current year and column2 with current month where ever column1 or...

hi

could you please explain why using varchar(max) is not such a good method in this case

Thanks

hi

u could use openrecordset or opendatasource functions to retrieve data from excel and update the table. I think you can use these functions in your update query itself.

for more info...

hi

try this

select CAST(dbo.TASMANOTIME.OTHrsWrked AS float) from dbo.TASMANOTIME where    ISNUMERIC(OTHrsWrked) = 1

hi

database collation supercedes the sql server collation. The collation set for the datbase is the default collation for the columns in the tables. U can change the collation of each...

hi

try this

UPDATE CustomerDownlList

set Downloaded =case when numdownloads = quantity  then 1 else Downloaded  end where...

hi

if u r using sql 2005 u can use unpivot operator for this.

hi

cant u  change the default db by clicking on the options button in the login screen.

hi

one row in sysindexes is for the table,

second  row is for primary key nonclustered index

third row is for the text datatype column (ldNote).

if there is a text column then there is...