Database

abdelhameed81 wrote:

select datediff(year,12/2/2000,getdate())

select itemid from (select count(*) as TotalWords, itemid
			from item_keyword ik inner join keyword k on ik.keywordid = k.keywordid 
			where k.keyword in(<code>'C++','C#','ASP'</code>)
			group by itemid) as tbl 
<code>where TotalWords = 3</code>

Elina Blank wrote:

My concern is, that if there are 3 keywords, say 'Java','C#','ASP',
this query will still select it, or wouldn't it?

devboycpp wrote:

In two of my pages I have 6 roundtrips to sql server.In the other 3.Lets say in the worst case average of 3 roundtrips per page.All queries are simple queries that return records with few fields.and number of records are not more than 30.
Can problem be from my side ???? Is it that hard ?

SELECT AccountTypes.ATypeID, AccountTypes.AType, Accounts.OpDr +<br />
  SUM([Transaction].Debit) AS TDr, Accounts.OpCr +<br />
  SUM([Transaction].Credit) AS TCr<br />
FROM Accounts<br />
LEFT OUTER JOIN [Transaction]<br />
 ON Accounts.ATypeID = [Transaction].ATypeID<br />
 AND Accounts.AC = [Transaction].AC <br />
INNER JOIN AccountTypes<br />
 ON Accounts.ATypeID = AccountTypes.ATypeID<br />
GROUP BY Accounts.OpDr, Accounts.OpCr, AccountTypes.AType, AccountTypes.ATypeID