Just want to point out that ISNUMERIC and ISDATE is not reliable

SELECT ISNUMERIC('12d5'),ISDATE('2000')

This may help you

declare @files table(dbname varchar(100), filename varchar(1000))

insert into @files

exec sp_msforeachdb 'select ''?'', filename from ?..sysfiles'

select dbname,min(left(filename,1)),max(left(filename,1)) from @files

group by dbname

having min(left(filename,1))<>'E' or max(left(filename,1))<>'F'

Note that sp_msforeachdb is undocumented which...

Insert into TableB(columns)

Select columns from TableA

Where TransDT between '01-Dec-2008 07:00:00' and '01-Dec-2008 18:00:00'

Searc for Common Table Expressions in google

Have you read previous replies? 😉

T Lehtinen (12/1/2008)

---

Hello!

I have this kind of data (about 40 000 rows)

id; keywords

1;horse, red, farm

2;cat, white, farm

3;dog

4;dog, farmer, farm, evening

How do I sererate those keywords into rows? in T-sql?

relults...

You can use TRANSFORM function in ACCESS to generate Cross-tab reports

Gouthama Kolivad (12/1/2008)

---

Check this... I think it will help you

declare @a bigint

declare @b-2 varchar(10)

declare @c varchar(100)

set @b-2 = 'test'

set @a = 5

set @c = @b-2 +'-' + cast(@a as varchar(50))

print...

Do you want to create a number...

It must be faster. If not compare the execution paln by applying these

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/07/21/ordering-interger-values-stored-in-varchar-column.aspx

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/02/empty-string-and-default-values.aspx

Also read http://www.sommarskog.se/dynamic_sql.html

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Also worth to read

http://www.sommarskog.se/dyn-search.html