How can we help you today? How can we help you today?
tanya
Activity overview Badges (0) Posts (17) Comments (226)

Comments

Sort by recent activity
Hello, Ahh...I just noticed the bug that has been introduced with this option. I have logged the issue in our database and we will have it fixed for the release. Thank you for reporting the problem:) Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Cannot turn off automatic trigger / objects
Hello, Ahh...I just noticed the bug that has been introduced with this option. I have logged the issue in our database and we will have it fixed for the release. Thank you for reporting the problem...
0 votes
Hi George, Thank you for reporting the issue. We have been able to replicate the crash and will have it fixed for the beta release. Apologies for the inconvenience caused. Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Identity seed causes an error
Hi George, Thank you for reporting the issue. We have been able to replicate the crash and will have it fixed for the beta release. Apologies for the inconvenience caused. Regards, Tanya Project Ma...
0 votes
Hi, Nice suggestion [image] However it is highly unlikely we will have this done for v4 but I have logged it as a feature enhancement request in our database which we will review for the future releases. Thank you for taking the time to post your suggestions! Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. How About ID'ng parenthesis pairs.
Hi, Nice suggestion However it is highly unlikely we will have this done for v4 but I have logged it as a feature enhancement request in our database which we will review for the future releases. ...
0 votes
Hello, Thank you for reporting the issue. The problem has now been logged in our bug database and we will keep you posted with updates. Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Exception Error - Using FORMAT from SQL Analyzer-vSQ L8.00.1
Hello, Thank you for reporting the issue. The problem has now been logged in our bug database and we will keep you posted with updates. Regards, Tanya Project Manager Red Gate Software Ltd
0 votes
Hello, Apologies for the inconvenience caused. Your suggestions are heard by Red Gate and the fix for this issue will be available in our next release scheduled for next week [image] I hope that helps. Thanks, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. SQL Prompt and permissions
Hello, Apologies for the inconvenience caused. Your suggestions are heard by Red Gate and the fix for this issue will be available in our next release scheduled for next week I hope that helps. Th...
0 votes
Hi, Oops...sorry about the bug (Problem 2) But it is a good catch! We will have this sorted for the RC. Problem 1 - Temporary tables are not yet implemented and that is the reason you don't see support for it. However, this will be done for the release. Thank you for taking the time to report the issue. Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Table Variables
Hi, Oops...sorry about the bug (Problem 2) But it is a good catch! We will have this sorted for the RC. Problem 1 - Temporary tables are not yet implemented and that is the reason you don't see sup...
0 votes
Hello, Automatically inserting the closing characters and validating them features are not yet done on the EA build and so the issue. However, it will be sorted for the release build. Excuse us for any inconvenience caused. Thanks, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Early niggles
Hello, Automatically inserting the closing characters and validating them features are not yet done on the EA build and so the issue. However, it will be sorted for the release build. Excuse us for...
0 votes
Hi Mike, Fair enough! That said, it is unlikely we will change this behaviour for v4 but I have logged this in our bug tracking system and we will review the sorting order of variables for our future version. Thank you for voicing your suggestion [image] Regards, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Ordering in Candidate list
Hi Mike, Fair enough! That said, it is unlikely we will change this behaviour for v4 but I have logged this in our bug tracking system and we will review the sorting order of variables for our futu...
0 votes
Hello, It actually orders the variables in reverse order i.e. the nearest variables are listed on top of the suggestions as it is generally useful for cases when a DECLARE is followed immediately by a SET statement. Is there any other ordering that you would rather prefer? Thanks, Tanya Project Manager Red Gate Software Ltd / comments
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. Ordering in Candidate list
Hello, It actually orders the variables in reverse order i.e. the nearest variables are listed on top of the suggestions as it is generally useful for cases when a DECLARE is followed immediately b...
0 votes
Hi Mike, Thank you for the feedback and the script. It is because temporary tables are not understood by SQL Prompt as yet as the functionality is not implemented. However, this will be resolved in the next release build. Thanks, Tanya Project Manager Red Gate Software Ltd MikeONeill wrote: 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
  1. Community
  2. SQL Prompt 4 (Early Access Program)
  3. See lots of red lines?
Hi Mike, Thank you for the feedback and the script. It is because temporary tables are not understood by SQL Prompt as yet as the functionality is not implemented. However, this will be resolved in...
0 votes
Total activity
385
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
142