Hi,

have a look at pivot table in BOL. This shows how a case statement can be used to do roughly what you want to do.

Paul

hi,

try (from BOL)

create procedure {proc_name}... with encryption.

create trigger {trig_name} on {object_name}

with encryption

Paul

Hi,

don't forget that applying security patches from Microsoft can change the version number also.

Paul

hi,

just do the restore again with force restore over existing database, rather then removing it forst

Paul

hi homerJ

have you tried to DBCC the database ? (or just the table) This might clear the problem.

Paul

Hi HallD

you could try using substring to return the column name as follows :-

create table incomplete_test

(col1 int , col2 varchar(10))

insert into incomplete_test

values (0, "A")

insert into incomplete_test

values (0, "")

insert into incomplete_test

values...

hi,

in 6.5 backups couldn't be loaded into a database that was smaller than the original. Therefore if the database has been created/extended to a particular size then the secondary database...

hi,

in 6.5 backups couldn't be loaded into a database that was smaller than the original. Therefore if the database has been created/extended to a particular size then the...

hi,

use set rowcount 1 before the update, and only one row will be updated. (remember to use set rowcount 0 to display both records afterwards !)

Paul

hi,

taken directly from BOL,

"For example, to bulk copy data from the Authors.txt data file to the authors2 table in the pubs database, specifying that the data file is...

Hi, i've had a similar problem in the past. Too many successful login messages in the errorlog. What I did was use the NT command FINDSTR to ignore any lines...