Search results for query: *

Sorry for the earlier solution actually I focused on your null statement. do not use this line --compare=(rs1("equip_id")) The correct code is this... 'After conn.execute, Check for the eof-bof of recordset IF rs.eof and rs.bof then 'Means no record exists, so call the insert...

Instead of ------- if compare!=null Then ----- Use this ---------- if ISNULL(compare) = false Then ---------- Ramesh

May be following code can help you... ----------- declare @db varchar(30), @disk varchar(256), @weekname varchar(15) select @db = db_name() , @weekname = DATENAME(dw, getdate()) , @disk = '\\pc-name\' + @db + '-' + @weekname + '.BAK' backup database @db to disk = @disk with init...

Hi, Can you explain your problem with more detail. Since it is not very clear. If users uses different NT username but same sql logins e.g. sa In this case there is no way to differenciate btn the users because NT username will not be considered. You have to use windows authentication or...

Use select suser_sname() Ramesh

Hi Sherly, What exactly you want to do. If any case you resolve the problem of "Column 'C.High' is invalid in the select list because it is not contained in either an aggregate function " then you will get different error message stating that subquery returned more than one value. I...