User profile for MikeONeill

Thats even better , its not the first time I have refreshed the cache of a BIG db by accident and sat waiting, just to wait again for the one I wanted !! Its normally the one you working on tha needs it anyway Cheers Mike / comments

Thats even better , its not the first time I have refreshed the cache of a BIG db by accident and sat waiting, just to wait again for the one I wanted !! Its normally the one you working on tha nee...

0 votes

HI Tanya I suppose its down to individual styles , I normally declare all my variables as a block at the start of an sp , then @(#)Tables etc before I start to set any variables or work on logic . I just find it easier to find variables later . If I were tidier , I suppose I ought to sort these alphabetiacally for prettyness ( alas !!) I would have thought the sort order should be local variables on top sorted alphabetically to suit my style best . Maybe as an option to allow other sort styles. That said its not a problem as you start to type the @V.. the one you wnat pops to the top anyway , it just looked strange . Cheers Mike / comments

HI Tanya I suppose its down to individual styles , I normally declare all my variables as a block at the start of an sp , then @(#)Tables etc before I start to set any variables or work on logic . ...

0 votes

This is a good example , it seems to be not liking the #Machine I'm not sure if you can replicate not having the Db All the Inner Joins are underlined -- Retrieve Unique List of Machines INSERT INTO #Machines (Machine, MachineDesc) EXECUTE dbo.SelectMachineBy @LotSummaryName = 'PA-MATUR,PA-FERME,PA-FLAVO,PA-FILTR,PA-DABPR', @BrandCode = '-1', @MachineType = 'Bright Beer Tank,Fermentation Vessel,Storage Vessel', @ExcludeOffline = 1 INSERT INTO @Inventory SELECT DISTINCT MT.Machine ,ISNULL(L.LotID, '') ,ISNULL(R.[Description], 'None') ,QuantityStart = ISNULL(dbo.fncLotDestinationQuantity(L.LotID, @SelectedDate), 0) ,QuantityCurrent = ISNULL(L.PrimaryQty, 0) ,ISNULL(B.ShortDescription, '') ,ISNULL(B.LongDescription, '') ,ISNULL(L.MaterialName, '') ,ISNULL(L.MaterialVersion, '') ,ISNULL(SUBSTRING(M.MaterialName, 3, 10) , '') ,ISNULL(M.Description, '') ,FilledOn = ISNULL(dbo.fncFilledOn(L.LotID), '') ,StdGravity = ISNULL(dbo.fncStdGravity(L.LotID, 0), 0) ,Actual = ISNULL(dbo.fncStdGravity(L.LotID, 1), 0) ,ProcessTimeTarget = ISNULL(CASE WHEN R.RouteName LIKE 'Fermentation%' THEN BA.FVDaysProcess WHEN R.RouteName LIKE 'Maturation%' THEN BA.SVDaysProcess WHEN R.RouteName LIKE 'Filtration%' THEN BA.BBTDaysProcess END, 0) ,ISNULL(LI.CreateTimeLogged, '') ,CreateDate = ISNULL(LI.DueDate, '') ,ISNULL(R.paqtMenuCol, 0) ,ISNULL(R.DisplayOrder, 0) ,ISNULL(MC.Location, '') ,ISNULL(L.FinishedOn, '') ,'IN_USE' ,NULL FROM #Machines MT INNER JOIN Machine MC ON MT.Machine = MC.Machine INNER JOIN StartLog SL ON MT.Machine = SL.Machine INNER JOIN LotBaseLog LBL ON LBL.BaselogID = SL.TransLogID AND Undone = 'False' INNER JOIN Lot L ON L.LotID = LBL.LotID AND L.FinishedOn > @SelectedDate INNER JOIN Route R ON LBL.RouteName = R.RouteName AND LBL.RouteVersion = R.RouteVersion LEFT OUTER JOIN LotInfo LI ON L.LotID = LI.LotID INNER JOIN Material M ON L.MaterialName = M.MaterialName AND L.MaterialVersion = M.MaterialVersion INNER JOIN Brand B ON B.pkBrandCode = M.fkBrandCode INNER JOIN BeerAvailability BA ON BA.fkBrandCode = B.pkBrandCode WHERE LBL.TimeLogged <= @SelectedDate AND L.FinishedOn >= @SelectedDate ORDER BY MT.Machine / comments

This is a good example , it seems to be not liking the #Machine I'm not sure if you can replicate not having the Db All the Inner Joins are underlined -- Retrieve Unique List of Machines INSERT INT...

0 votes

Hi I agree , I have code which works fine that is literally scattered with squiggles in red and the tooltip showing "Syntax Error" when the code executes as expected . I like the concept , as I often get to the point of LayoutSQL with the odd error but you never quite see where it is . The error indication is good and paralells well with Visual Studio Cheers Mike / comments

Hi I agree , I have code which works fine that is literally scattered with squiggles in red and the tooltip showing "Syntax Error" when the code executes as expected . I like the concept , as I oft...

0 votes

Normality is restored thanks again Mike / comments

Normality is restored thanks again Mike

0 votes

Thanks Brian , I thought you may have seen it before Its on my home PC so I'll try it tonight and let you know Mike / comments

Thanks Brian , I thought you may have seen it before Its on my home PC so I'll try it tonight and let you know Mike

0 votes

Hi I too have both installed but keep a separate set of options For example , in Refactor I have column on a new line disabled , in SQLPrompt I have the opposite That way I can keep code compact while I'm working on it and then change the layout to "final" columns on new lines when I'm done I find having the 2 quite useful on occasions Mike / comments

Hi I too have both installed but keep a separate set of options For example , in Refactor I have column on a new line disabled , in SQLPrompt I have the opposite That way I can keep code compact w...

0 votes

I haven't actually seen SQL 2008 yet , I must have a look , it would be an excellent addition. When I bought my Visual Studio 2008 , they hadn't launched SQL 2008 or no doubt they would include the developer edition in there Cheers Mike / comments

I haven't actually seen SQL 2008 yet , I must have a look , it would be an excellent addition. When I bought my Visual Studio 2008 , they hadn't launched SQL 2008 or no doubt they would include the...

0 votes

Surely if you goto Cache management you get 2 offers , Refresh All or highlight a single Db and click Refresh , it does just the one selected Also theres a check box for Refresh the Cache when opening a new Queyy editor instance, but I suspct that could be a lengthy one . I normally use the single db Refresh when I am working a Db thats changing a lot Mike / comments

Surely if you goto Cache management you get 2 offers , Refresh All or highlight a single Db and click Refresh , it does just the one selected Also theres a check box for Refresh the Cache when open...

0 votes

No Problem now Thanks / comments

No Problem now Thanks

0 votes

How can we help you today?

MikeONeill

Comments