No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum … |
|
Hello I am a fresher and I am involved in designing and developing a database. Please critique my er diagram These are the following tables client-----auto generated Primary key(clientid) vendor----auto generated Primary key(vendorid) clientvendor---composite primary key(clientid, vendorid) employee----composite primary key(clientid and employeeid) invoice(aphistory)----composite primary key(vendorid and invnumber) aplid(invoicelineitem)-----composite primary key(invnumber, … |