Hi Jeff,

Thanks,

Follow your suggestion.

Very glad to explained in both the versions.

😀

Hi

count(distinct col2) = 3 and count(distinct col3)= 2

then, Is you want to divided the value with col1 count?

Hi,

What is the logic beyond the columns C_col21 and C_col31? And how you determined the values?

Hi,

Refer BOL: http://msdn.microsoft.com/en-us/library/aa258255(SQL.80).aspx

Remarks

SQL Server can have as many as two billion tables per database and 1,024 columns per table. The number of rows and total size of the table are...

select a.dbdate, a.dbname, a.datasize

from db_size a inner join

(

select dbname,min(dbdate)Midt,max(dbdate)Madt

from db_size

group by dbname

)b

on a.dbname = b.dbname and

a.dbdate = b.Midt

union all

select a.dbdate, a.dbname, a.datasize

from db_size a inner join

(

select dbname,min(dbdate)Midt,max(dbdate)Madt

from db_size

group...

Hi,

Certainly Paul,

The situations are varying from the OP.

For the OP issue, I felt its enough, it’s my point.

Hi,

I know this, friend!

The tips/advice made based on the OP query.

I puzzling in some body say it have not guaranteed to work in other situations.

Hi,

nice move with inner join.

But the situation always not with max date

UPDATE t

SET t.date2 = (SELECT MAX(date2) FROM #temp WHERE date2 <= t.date1)

from #temp t

However, you should see the...

create table #temp

(

date1 datetime null,

date2 datetime null

)

insert into #temp (date1,date2)

select '2009-01-01','2009-01-01' union all

select '2009-01-02',null union all

select '2009-01-03',null union all

select '2009-01-04',null union all

select '2009-01-05','2009-01-05' union all

select '2009-01-06',null union all

select '2009-01-07',null union...

Hi,

Post the table schema,

Are you sure, its shows the ASCII values for the both the columns?

Hi,

Post the error message, when you’re got during compile the procedure.

declare @monthname varchar(50)

set @monthname = 'January 2009,May 2009'

set @monthname = SUBSTRING(@monthname,PATINDEX('%,%', @monthname)+1,LEN(@monthname))

--for select last month May 2009

declare @concat nvarchar(1000)

select @concat=coalesce(@concat,'')+datename(m ,DATEADD(mm, N-1, '01/01/1900'))

+ ' '+cast(year(@monthname)as varchar)+','

FROM DBO.Tally /*Ref...

Hi,

Repeated post, discussion already started, http://www.sqlservercentral.com/Forums/Topic864421-8-1.aspx

Hi Jothi Krishna,

Refer this link: discussed with same topic.

http://www.sqlservercentral.com/Forums/Topic862480-169-1.aspx#bm863021

Hi,

What Steve may try to say is, not in the OS log. In the error log of the server agent, its also can seen thro the sql server agent properties...