Database

		<br />
SELECT COUNT(*) FROM (SELECT MIN(BankID) AS DBComboValue, (BankSortCode) As DBComboText, BankName, BankAddress3<br />
            FROM tblBanks <br />
            WHERE BankSortCode LIKE @Query<br />
			AND BankActive = 1<br />
            GROUP BY BankSortCode, BankName, BankAddress3)

set ANSI_NULLS ON<br />
set QUOTED_IDENTIFIER ON<br />
GO<br />
ALTER PROCEDURE [dbo].[DropDownCombo_Banks_Lookup_Count]<br />
	-- Add the parameters for the stored procedure here<br />
		@Query As nvarchar(100)<br />
AS<br />
BEGIN<br />
<br />
		--SELECT Count(DISTINCT CONVERT(nvarchar(100), BankSortCode) + BankName + BankAddress3) AS RowCounter<br />
		--FROM tblBanks<br />
        --WHERE BankSortCode LIKE @Query<br />
		--AND BankActive = 1;<br />
<br />
		SELECT COUNT(*) FROM (SELECT MIN(BankID) AS DBComboValue, (BankSortCode) As DBComboText, BankName, BankAddress3<br />
            FROM tblBanks <br />
            WHERE BankSortCode LIKE @Query<br />
			AND BankActive = 1<br />
            GROUP BY BankSortCode, BankName, BankAddress3)<br />
END

GROUP BY BankSortCode, BankName, BankAddress3) A

DQNOK wrote:

Unless "TableName" is a synonym for "every table in the database", I don't really think "DROP TABLE TableName" will work. But then, I haven't tried it either...

allisha wrote:

i want to display column wise data in one row like this...
number
---------------
123,234,3435,5656

bool isFirst = true;
StringBuilder sb = new StringBuilder();
SqlDataReader reader = myCommand.ExecuteReader();
while(reader.Read())
{
    if (isFirst)
        isFirst = false;
    else
        sb.Append(",");
    sb.Append(reader.GetInt(0).ToString());
}
string displayResult = sb.ToString();