to add my 2 cents. 🙂

Hungarian notation is good for compilers, but T-SQL is an interpreter.

Prefixes on names make it longer and inflate system indexes

It slows slows down interpreting of...

Another surprising for someone result comes from simple primary school exercise.

[font="Courier New"]X / N * M = X * M / N[/font]

Is it true?

Let's check.

[Code]

declare @d decimal(18,15), @f FLOAT

SET @d...

If you're expecting the answers from DECIMAL calcs to match those of FLOAT calcs, you'll be surprised. You do have to take some post-calulation action as you suggested...

If you import into numeric column you'll never have a chance to sort anything out.

Insert will fail immediately.

Well, if it's true then too many typewrites all around...

When you need to send emails.

Or upload/report data from/to...

In fact what you are doing is...

Use

GROUP BY Code_t

and SUM() for all other columns.

[Code]select @sql ='SELECT distinct top ' + @MyCount + ' ' + @sqlrest + ' FROM Employee E

WHERE E.Firstname LIKE '''+ '%' + @term + '%' + ''''

print...

You have not lost anything.

You just display the same value in different representation.

Think...

Always do

[font="Courier New"]PRINT @sql[/font]

before you do

[font="Courier New"]exec sp_executesql @sql[/font]

This syntax was introduced in SQL2005.

In SQL2000 use SET ROWCOUNT @param instead.

[Code]

CREATE TABLE dbo.CustomerFlags (

FlagCode nchar(1) NOT NULL , -- change datatype if 1 letter is not enogh for some flags

CustomerID int NOT NULL ,

CONSTRAINT PK_CustomerFlags PRIMARY KEY ON (FlagCode, CustomerID)

)

CREATE...

Correct syntax:

DECLARE @smsglist VARCHAR(8000), @sDelimiter VARCHAR(8000) = '/'

SET @smsglist = 'Part 1/Part 2/Part 3'

SET @sDelimiter = '/'

Select * from dbo.fnSplitMsg (@smsglist, @sDelimiter)

DELETE tsd

FROM #tmp_searched_table1 tsd, table_2 dta

WHERE dta.doc_id=tsd.doc_id_pk