Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sitka
Aged Yak Warrior
571 Posts |
 Posted - 2004-06-17 : 09:10:53
|
SELECT TOP 1 Identity_ColumnFROM apitem WHEREPATINDEX('%' + apitem.fcSource+ '%', 'RP') > 0AND(CASE WHEN ISNUMERIC( apitem.fapp_dt) = 1 THEN CASE WHEN apitem.fapp_dt = 0 THEN 1 ELSE 0 END ELSECASE WHEN ISDATE( apitem.fapp_dt) = 1 THEN CASE WHEN apitem.fapp_dt = '19000101' THEN 1 ELSE 0 END ELSECASE WHEN LEN( apitem.fapp_dt) = 0 THEN 1 ELSE 0 END END END) = 1 AND (fcinvkey IN (SELECT TOP 1 fcinvkey FROM apitem WHERE PATINDEX('%' + apitem.fcSource+ '%', 'RP') > 0 AND (CASE WHEN ISNUMERIC( apitem.fapp_dt) = 1 THEN CASE WHEN apitem.fapp_dt = 0 THEN 1 ELSE 0 ENDELSE CASE WHEN ISDATE( apitem.fapp_dt) = 1 THENCASE WHEN apitem.fapp_dt = '19000101' THEN 1 ELSE 0 END ELSECASE WHEN LEN( apitem.fapp_dt) = 0 THEN 1 ELSE 0 END END END) = 1 ORDER BY fcinvkey))ORDER BY Identity_Column ASCJust Kidding. Gosh I hate this application. It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-17 : 09:36:07
|
| I think I'm dizzy now.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Can someone format/indent this for me.