Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
use winoasis DECLARE @Casino VARCHAR(254), @VAR INT SET @Casino = (SELECT RIGHT(CASINONAME, LEN(CASINONAME)-9) FROM CDS_CONFIG (nolock)) if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='CDS_SLOTMAST' and COLUMN_NAME='MaxCoins' ) BEGIN SELECT @VAR = '1' END if not exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='CDS_SLOTMAST' and COLUMN_NAME='MaxCoins' ) BEGIN SELECT @VAR = '0' END select @CASINO as Casino, a.slotnumber, a.locationstring, IsNull(a.nReels, ' ') as nReels, IsNull(a.Reels, ' ') as Reels, IsNull(a.nCoins, ' ') as nCoins, IsNull(a.nPaylines, ' ') as nPaylines, IsNull(a.MaxHandPay, '.00') as MaxHandPay, CASE WHEN SUM(@VAR) = 1 THEN (SELECT IsNull(a.MaxCoins, '0')) WHEN SUM(@VAR) = 0 THEN 0 END AS MaxCoins, IsNull(a.SealNumber, 'None') as SealNumber, IsNull(a.SerialNumber, 'None') as SerialNumber, IsNull(a.EpromId, 'None') as EpromId, IsNull(a.EpromId2, 'None') as EpromId2, a.denomination, b.cabinetdesc, c.styledesc, d.manufacturer, a.description, IsNull(g.CalcDesc, 'None') as CalcID, IsNull(e.leasedesc, 'Not Leased') as LeaseInfo, IsNull(f.ProgDesc, 'Non-Progressive') as ProgressiveType, IsNull(h.Description, 'None') as PointCalc_ID, a.active from cds_slotmast A (nolock) inner join bb_cabinet B (nolock) on a.cabinet_id = b.cabinet_id inner join bb_style C (nolock) on a.style_id = c.style_id inner join bb_mfr D (nolock) on a.mfr_id = d.mfr_id left outer join bb_lease E (nolock) on a.lease_id = e.lease_id left outer join bb_ProgressiveType F (nolock) on a.ProgressiveType_ID = f.ProgressiveType_ID left outer join bb_Calc G (nolock) on a.Calc_ID = G.Calc_ID left outer join cds_pointcalc H (nolock) on a.PointCalc_ID = H.PointCalc_ID where a.active = 'Y' and a.currentrevision = 'y' END
|Why do I get extra rows when I do inner join?||12||29|
Select column_name from INFORMATION.SCHEMA.COLUMNS
|vb6 connector to SQL Server||2||20|
|Inserting a column in a table that creates an ID and row number||4||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!