hi,

i have done both of them and i think it depends,

somethimes you do not have the ablility to run your query with union all because you may have your...

hi

you may need something like this:

select REPLICATE('0',2 - LEN(cast(month(getdate())as varchar(2)))) + cast(month(getdate())as varchar(2))

hi

smith is right, very nice idea

hi

i think you better use html.encode in your application code before saving

the data

hi

select *

from TableName

where DateField Between DATEDIFF(day, GetDate(), 90) and getdate()

i thing derek is right

order by f1 desc , f2 asc

works...

hi

i think smith is right

hi

i think you can use xml datatype for ommiting the extra spaces on the document

hi,

i think jack is right.

hi,

you can use sum function but also you need to grou by other fileds too,

select f1, f2,sum(f3)

group by f1,f2

hi

i think the given query works

Hi

I agree with the @@Nestlevel

hi,

you can set the default property of the column to getdate() for new records , and for updates you may use some trigger to handle that,

hi,

if you have table1 and table2 and a totalTable with the same columns and same datatypes, you can use something like this:

insert into totalTable

select * from table1

insert into totalTable

select *...