Database

<br />
select Name<br />
from table<br />
where value is null<br />
and name not in<br />
  (select Name<br />
   from table<br />
   where value is not null)<br />

select * from tbl_Item itm 
inner join tbl_ItemValue val on itm.itemid = val.itemid 
inner join (Select max(updateddate) as MaxDate, itemid 
		from tbl_itemValue 
		group by itemid) as val2 on val.UpdatedDate = val2.MaxDate and val.ItemID = val2.ItemID

greekius@hotmail.com wrote:

i cant connect what is missing?:

greekius@hotmail.com wrote:

;User ID=SA;

<br />
update alarm_log set timestamp = dateadd(d,430,timestamp) <br />

DECLARE @cSQL varchar(100)
DECLARE @cTableName varchar(100)

SELECT @cSQL = ''

DECLARE  TableNames CURSOR FOR 
SELECT DISTINCT table_name 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE column_name = 'timestamp'

OPEN TableNames
FETCH NEXT FROM TableNames INTO @cTableName 
WHILE @@FETCH_STATUS = 0
BEGIN
	EXEC('UPDATE ' + @cTableName + ' SET timestamp = DATEADD(d,430,timestamp)')

	FETCH NEXT FROM TableNames INTO @cTableName 
END

CLOSE TableNames
DEALLOCATE TableNames 

kozu wrote:

How can I print the names and the number of times they show up?

SELECT Name, COUNT(*) AS Counter
FROM MyTable
GROUP BY Name

kozu wrote:

second question, how can i print the following?

CREATE FUNCTION GetData (@cName varchar(100))  
RETURNS varchar(100) AS  
BEGIN 

DECLARE @nData int
DECLARE @cDataHold varchar(100)
SELECT @cDataHold = ''

DECLARE  DataCursor CURSOR FOR 
SELECT Data 
FROM TestTable
WHERE Name = @cName

OPEN DataCursor
FETCH NEXT FROM DataCursor INTO @nData 
WHILE @@FETCH_STATUS = 0
BEGIN
	select @cDataHold = @cDataHold + case when len(@cDataHold) > 0 then ', ' else '' end + CAST(@nData as varchar(100))
	FETCH NEXT FROM DataCursor INTO @nData 
END

CLOSE DataCursor
DEALLOCATE DataCursor
RETURN(@cDataHold)
END

select name, dbo.getdata(name) as Data from (select distinct name from TestTable) as tbl