Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~744 People Reached
Favorite Forums
Favorite Tags
Member Avatar for tammy2512

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 …

Member Avatar for kplcjl
0
151
Member Avatar for tammy2512

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, …

Member Avatar for tesuji
0
593