mssql-select

.

select by date

select sum([Cost Posted to G_L]) AMT ,[location code]
from dbo.[DataBase$value entry] ve
where [posting date]>='2012-07-01'  and [posting date]<='2013-11-30'
group by [location code] order by [location code]


mssql-top

Select TOP 2 name, address1_stateorprovince from FilteredAccount

Select UPPER(name), LOWER(address1_stateorprovince) from FilteredAccount

Select UPPER(name) as name , LOWER(address1_stateorprovince) as address1_
stateorprovince from FilteredAccount

Select * from FilteredAccount WHERE name like '%damian'

Select * from FilteredAccount WHERE name like '%damian%'

Select * from FilteredAccount WHERE name = 'damian' OR telephone1 =
'9999'

Select * from FilteredAccount ORDER BY name desc

Select address1_stateorprovince, count(*) from FilteredAccount group
by address1_stateorprovince

Select address1_stateorprovince, count(*) as state_count from
FilteredAccount group by address1_stateorprovince

Select FilteredContact.fullname, FilteredAccount.name from
FilteredContact inner join FilteredAccount on FilteredContact.accountid =
FilteredAccount.accountid
















Update FilteredAccount set address1_country = 'U.S.'