Advertisement
Advertisement
| 03.14.2008 at 09:13AM PDT, ID: 23242194 |
|
[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! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: |
Declare @FarmName NVarChar Set @FarmName = 'x' If (SELECT Count(*) FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = @FarmName) = 0 BEGIN Print 'Inside the BEGIN' END ELSE Print 'Inside the ELSE' |
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 03.14.2008 at 09:20AM PDT, ID: 21126872 |
| 03.14.2008 at 09:33AM PDT, ID: 21126979 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: |
Declare @FarmName NVarChar
DECLARE @Count INT
Set @FarmName = 'x'
SELECT @Count = Count(*) FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = @FarmName
IF @Count = 0
If @Count = 0
Print 'Inside the BEGIN'
ELSE
Print 'Inside the ELSE'
|
| 03.14.2008 at 09:35AM PDT, ID: 21127002 |
| 03.14.2008 at 10:05AM PDT, ID: 21127241 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: |
Declare @FarmName NVarChar
DECLARE @Count INT
Set @FarmName = 'Pomeroy'
SELECT @Count = Count(*) FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = @FarmName
If @Count = 0
Print 'Inside the BEGIN'
ELSE
Print 'Inside the ELSE'
GO
SELECT Count(*) FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = 'Pomeroy'
|
| 03.14.2008 at 10:08AM PDT, ID: 21127266 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: |
Declare @FarmName NVarChar
Set @FarmName = 'Pomeroy'
If not exists(SELECT 1 FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = @FarmName)
BEGIN
Print 'Inside the BEGIN'
END
ELSE
Print 'Inside the ELSE'
|
| 03.14.2008 at 10:09AM PDT, ID: 21127279 |
| 03.14.2008 at 10:18AM PDT, ID: 21127371 |
| 03.14.2008 at 10:20AM PDT, ID: 21127404 |
| 03.14.2008 at 10:27AM PDT, ID: 21127477 |
| 03.14.2008 at 10:29AM PDT, ID: 21127495 |
| 03.14.2008 at 10:47AM PDT, ID: 21127657 |
| 03.14.2008 at 11:10AM PDT, ID: 21127891 |
| 03.14.2008 at 12:25PM PDT, ID: 21128597 |
| 03.14.2008 at 12:30PM PDT, ID: 21128647 |
| 03.14.2008 at 12:54PM PDT, ID: 21128887 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: |
Declare @FarmName NVarChar
Set @FarmName = 'Pomeroy'
If exists(SELECT 1 FROM [RDA Prod Pen Master] As pm LEFT JOIN (SELECT l.[Location ID],Farm,Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 3, 4)) As [Pen Number] FROM [RDA Prod Pen Totals] As pt INNER JOIN Location As l ON Convert(int, SubString(Convert(NVarChar, [Pen Scan]), 1, 2)) = l.House) As totals ON pm.[Location ID] = totals.[Location ID] AND pm.[Pen Number] = totals.[Pen Number] INNER JOIN Location As l ON pm.[Location ID] = l.[Location ID] WHERE totals.[Location ID] Is Null AND l.Farm = @FarmName)
BEGIN
Print 'Inside the BEGIN'
END
ELSE
Print 'Inside the ELSE'
|
| 03.14.2008 at 12:58PM PDT, ID: 21128928 |
| 03.14.2008 at 01:08PM PDT, ID: 21129016 |
