Method #1

Select Left(Dte,4) Year, Right(Dte,2) Mon, Total

From

   (Select convert(char(7), CrDate,20) Dte, count(*) as Total

    from dbo.SysObjects

    where CrDate between @startdate and @enddate

    group by convert(char(7), CrDate,20)

   ) d

order by Dte

Method #2:

Select DateName(YY, CrDate) as Year, DateName(M, CrDate) as Month, count(*) as Total

from dbo.SysObjects

where CrDate between @startdate and @enddate

group by DateName(YY, CrDate), DateName(M, CrDate), month(CrDate) --extra level

order by DateName(YY,...

there are two approaches (that I know of)

one is to mix before grouping and extract after you do

the other which is simpler is to add level of wrapping

I am pretty sure with that is not going to happen again but just for curiosity how were you doing the detaching of it ?

Can you post what are you trying to achieve?

What is the purpose of this ?

OOps!  I was working on something else

I am not able to reproduce your problem I think SQL IS reactivating the constraints and maybe the problem is how are you checking that!

Ex:

In QA you

1. run the...

I don't exactly remember which step but when you are creating the publication you will be asked if the destination server has already the data in and you have to...

in the "agents profile" it is possible to configure how fast do you want the pooling to occur

The real question is if data can be changed at PC1 and PC2 independently?

If the anwser is yes then you do need merge

Next time I'll remember your name because it is definetly one of the most original post I have come accross

I don't even know the rules of the game

 I used to be one of the best swimers in town though (250k)

I keep typing slower than you do, dam!

Sure I do agree to yours as long as you post Before me last year <<

I wonder how many THIS year ?

Farrell,

I was refering to the tendency of someone new to SQL to "loop" on every scenario. It is a natural construct for most other languages and it takes a bit get...