Database

declare @t table(docvalue varchar(50),priority int)
insert into @t select 'aaa',0 union all select 'xxx', 1 union all select 'bbb', 3 union all
select 'ccc',0 union all select 'aaa',2

select docvalue,priority  from @t where priority <> 0 group by priority,docvalue
union all
select * from @t where priority = 0

select distinct * from @t where priority <> 0 group by priority,docvalue
union 
select * from @t where priority = 0

docvalue	priority
xxx	1
aaa	2
bbb	3
aaa	0
ccc	0

<<thashif>> wrote:

I neva asked u 2 work or complete the task for me

<code>SELECT</code> MyTable.Column1 , S.Column2,S.Column3, S.Column4
<code>FROM</code> MyTable , (
<code>Select</code> MyTable.T2 , MyTable.T3, MyTable.T4
<code>From</code> MyTable
<code>Group By</code> MyTable.T2 , MyTable.T3, MyTable.T4
<code>Having</code> ( Count(Sheet1.T2)>1 and Count(Sheet1.T3)>1 and Count(Sheet1.T4)>1 )
) as S
<code>Where</code> MyTable.T2=S.T2 and MyTable.T3=S.T3 and MyTable.T4=S.T4

SELECT 
(SELECT top 1 m2.Clmn1 FROM mytable m2 WHERE m2.Clmn2= m.Clmn2) Clmn1 ,--by this subquery you get first value of clmn1 column 
clmn2,clmn3,clmn7
FROM mytable m
GROUP BY m.clmn2,m.clmn3,m.clm7
HAVING 
COUNT (col2) > 0 AND
COUNT (col3) > 0 AND
COUNT (col7) > 0 

DbConnection.Open();

OdbcCommand DbCommand = DbConnection.CreateCommand();

DbCommand.CommandText = ("SELECT * FROM sqlite_master WHERE type='table' ORDER BY name");

DbReader = DbCommand.ExecuteReader();

List TableNames = new List();

while(DbReader.Read()){
    TableNames.Add(DbReader["name"]);
    Trace.WriteLine(DbReader["name"]);
}

DbReader.Close();
DbConnection.Close();

OdbcCommand DbCommand = DbConnection.CreateCommand();

//SQL query to return all table names
//http://www.sqlite.org/faq.html#q7
DbCommand.CommandText = ("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name");

DbReader = DbCommand.ExecuteReader();


List<string> TableNames = new List<string>();

while (DbReader.Read())
{
    TableNames.Add(DbReader["name"].ToString());
    Trace.WriteLine(DbReader["name"]);
}


DbReader.Close();

if (TableNames.Contains("bandwidth_records"))
{
    //check to make sure column names are present
    DbConnection.Close();
}
else
{
    //create table & columns
)

declare @t table(completeaddress varchar(100))
insert into @t
	select '1234 McKean Street' union all select '1234 McKean Street' union all
	select '1234 E McKean Street' union all select '1234 E McKean Street' 

select 
	StreetNum = 'StreetNum : ' + SUBSTRING(completeaddress,1,4) +',' 
	,Direction = 'Direction : ' + 
	
				case when ltrim(rtrim(SUBSTRING(completeaddress,5,2))) In('N','S','E','W') 
					 then SUBSTRING(completeaddress,5,2) else '' end + ','
	,StreetName = 'StreetName : ' + 
	
	case when ltrim(rtrim(SUBSTRING(completeaddress,5,2))) In('N','S','E','W')
	then SUBSTRING(completeaddress,7,LEN(completeaddress)) 
	else SUBSTRING(completeaddress,6,LEN(completeaddress)) end	
from @t

StreetNum : 1234,	Direction : ,	StreetName : McKean Street
StreetNum : 1234,	Direction : ,	StreetName : McKean Street
StreetNum : 1234,	Direction :  E,	StreetName :  McKean Street
StreetNum : 1234,	Direction :  E,	StreetName :  McKean Street

AndyInUK wrote:

The above cursor works good,

Ashfield wrote:

you should be able to add your set just before the insert

Ashfield wrote:

I think you lose your first record.

Ashfield wrote:

Why select the ID in your cursor if you don't use it.