Recent content by sneki

If you don't need your tr.log (do backup if you have free disk space), just remove it: 1. detach database 2. delete transaction log 3. attach database

select mainid, productid from table group by mainid, productid having count(*) > 1

Don't use stored procedure, use Multistatement table-valued functions or Inline table-valued functions(I think, you need Multistatement...). You can read about user-defined functions in BOL.

no, no :))

-- Disable the trigger. ALTER TABLE tableName DISABLE TRIGGER triggerName . . . code . . . -- Re-enable the trigger. ALTER TABLE tableName ENABLE TRIGGER triggerName

--set dateformat dmy select distinct school, (select lost from tableName t2 where t2.school = t1.school and t2.[date] = '20/10/2003') as [20/10/03], (select lost from tableName t2 where t2.school = t1.school and t2.[date] = '21/10/2003') as [21/10/03], (select lost from tableName t2 where...

Try with CURSOR: declare @var1 as type1, @var2 as type2, ... declare cusrorName cursor for your_select_statement open cursorName fetch next from cusorName into @var1, @var2... while @@fetch_status = 0 begin do_what_you_want_with_your_record... fetch next from...

SELECT ISNULL(value1, value2) as col,... or SELECT col = CASE WHEN value1 is null THEN value2 END, ... What kind of statment is faster?

SELECT CONVERT(decimal(10,5), columnName) from tableName

ok, give me your variable.

set @strSql = 'update...' exec(@strSql)