Advertisement
Advertisement
| 04.08.2008 at 06:49PM PDT, ID: 23306917 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 04.08.2008 at 08:02PM PDT, ID: 21311536 |
| 04.08.2008 at 08:04PM PDT, ID: 21311542 |
1: 2: 3: 4: 5: 6: 7: 8: 9: |
SELECT SUM(QTYSHIPPED), left(ITEM,4) as ITEM FROM [system-specific-product] WHERE INVDATE > @StartDte AND INVDATE < @EndDte GROUP BY left(ITEM,4) |
| 04.08.2008 at 08:07PM PDT, ID: 21311550 |
| 04.08.2008 at 08:09PM PDT, ID: 21311559 |
| 04.08.2008 at 08:09PM PDT, ID: 21311562 |
| 04.08.2008 at 10:23PM PDT, ID: 21311962 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: |
--step 1 create a test table
create table tmp_invoices(invnumber varchar(20),item varchar(20),invdate datetime,company varchar(20),qtyshipped int,invfisyr int)
-- step 2 insert some test data
insert tmp_invoices values ('INV73267','500LAPACK','20020701','COMP1',1,2002)
insert tmp_invoices values ('INV73354','KASU70','20020703','COMP1',1,2002)
insert tmp_invoices values ('INV73356','CAADLT2VM','20020703','COMP2',1,2002)
insert tmp_invoices values ('INV73356','KASU70','20020703','COMP2',1,2002)
insert tmp_invoices values ('INV73357','KASU408','20020703','COMP2',1,2002)
insert tmp_invoices values ('INV73362','KASU70','20020703','COMP2',1,2002)
insert tmp_invoices values ('INV73363','CAADLT2VM','20020703','COMP3',1,2002)
insert tmp_invoices values ('INV73366','KASU408','20020703','COMP4',1,2002)
--step 3 pretend we are a SP and create the needed date variables (must run this lot as complete set - ie highlight to end and F5)
declare @startdte datetime
declare @enddte datetime
set @startdte = '01 Jan 2000'
set @enddte = '01 Jan 2009'
SELECT SUM(QTYSHIPPED), ITEM
FROM (select case when item like 'KASU%' then 'KASU_TTL' else Item end as item, qtyshipped from tmp_invoices
WHERE INVDATE > @StartDte AND INVDATE < @EndDte) a
GROUP BY ITEM
|
| 04.08.2008 at 11:12PM PDT, ID: 21312136 |
| 04.09.2008 at 12:30AM PDT, ID: 21312527 |
| 04.09.2008 at 04:14AM PDT, ID: 21313587 |
| 04.09.2008 at 04:38PM PDT, ID: 21320197 |