Database

insert into table1(cola, colb,.....)<br />
select case when datalength(valuea) = 0 then null else valuea end, case when datalength(valueb) = 0 then null else valueb end  .....

Alsvha wrote:

SELECT Name, Count(Count)) as cnt FROM NameTable1

/* set up example */<br />
create table #b1(cola int)<br />
<br />
declare @a int<br />
<br />
set @a = 0<br />
<br />
while @a < 10<br />
begin<br />
	insert into #b1 select @a<br />
	select @a = @a +1<br />
end<br />
<br />
set @a = 4<br />
while @a < 10<br />
begin<br />
	insert into #b1 select @a<br />
	select @a = @a +1<br />
end<br />
<br />
/* show the desired query */<br />
select cola,count(*),(select count(*) from #b1) <br />
from #b1<br />
group by cola<br />
<br />
/* tidy up */<br />
drop table #b1

declare @total int<br />
<br />
select @total = count(*) from #b1<br />
<br />
select cola,count(*),@total<br />
from #b1<br />
group by cola

SELECT     Name,<br />
(SELECT     SUM(t1.Value) <br />
 FROM          myTable AS t1) AS sumofcnt,<br />
(SELECT     COUNT(t1.Value) <br />
FROM          myTable AS t1<br />
WHERE      (t1.Name = myTable.Name)) AS cnt<br />
FROM         myTable<br />
GROUP BY Name