How can we help you today? How can we help you today?
eklein
Activity overview Badges (0) Posts (11) Comments (6)

Comments

Sort by recent activity
It continues to fail.   My curent configuration is  SQL Server Management Studio 15.0.18338.0 SQL Server Management Objects (SMO) 16.100.41011.9 Microsoft Analysis Services Client Tools 15.0.19205.0 Microsoft Data Access Components (MDAC) 10.0.19041.1 Microsoft MSXML 3.0 5.0 6.0  Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.19044 Sql prompt is at 10.12.0.27933  (most current as of 10 minutes ago)  Table def is  USE [CRD_2010_FMT_220331] GO /****** Object:  Table [dbo].[cell_data]    Script Date: 6/6/2022 12:35:27 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[cell_data]( [fld_name] [char](15) NOT NULL, [cell_row] [char](5) NOT NULL, [cell_col] [char](5) NOT NULL, [RPT_REC_NUM] [int] NOT NULL, [ITM_VAL_NUM] [bigint] NOT NULL, [ITM_VAL_NUMF] [float] NOT NULL, [ITM_VAL_ALPHA] [varchar](128) NOT NULL, [sheet] [char](4) NOT NULL, [suppress] [char](1) NOT NULL, [component] [char](4) NOT NULL, [TYPE] [varchar](30) NOT NULL, [Data_id] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[cell_data] ADD  DEFAULT ((0)) FOR [ITM_VAL_NUM] GO ALTER TABLE [dbo].[cell_data] ADD  DEFAULT ((0)) FOR [ITM_VAL_NUMF] GO ALTER TABLE [dbo].[cell_data] ADD  DEFAULT ('') FOR [ITM_VAL_ALPHA] GO ALTER TABLE [dbo].[cell_data] ADD  DEFAULT (' ') FOR [suppress] GO ALTER TABLE [dbo].[cell_data] ADD  DEFAULT (' ') FOR [component] GO with a cluster index and 3 2ndary indexes  Is there anything else I can do to help.  The base table is quite large(244M rows), but I could create a subset for debugging purposes.  The data is publicly availiable, so there are no security issues Or if you want send me a zoom or webex meeting invite and I could share my screen and show you what I am seeing.  I am in US in Eastern Time zone.   I won't be in the offices tomorrow until PM but we can work out a schedule.  If I recall correctly you are +5 hours from me so mornings would probably be best.    Again this is not a prioriity problem for me, but as a developer myself, I know strange errors sometimes show you things you didn't know and can be educational  / comments
  1. Community
  2. SQL Prompt
  3. Very minor bug in "expand wildcard"
It continues to fail.   My curent configuration is SQL Server Management Studio 15.0.18338.0SQL Server Management Objects (SMO) 16.100.41011.9Microsoft Analysis Services Client Tools ...
0 votes
It was in SSMS only, but that is the only environment that I normally work in / comments
  1. Community
  2. SQL Prompt
  3. Very minor bug in "expand wildcard"
It was in SSMS only, but that is the only environment that I normally work in
0 votes
It was in SSMS only, but that is the only environment that I normally work in  If it makes a differance here is the current release levels  SQL Server Management Studio 15.0.18338.0 SQL Server Management Objects (SMO) 16.100.41011.9 Microsoft Analysis Services Client Tools 15.0.19205.0 Microsoft Data Access Components (MDAC) 10.0.19041.1 Microsoft MSXML 3.0 5.0 6.0  Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.19042 / comments
  1. Community
  2. SQL Prompt
  3. Very minor bug in "expand wildcard"
It was in SSMS only, but that is the only environment that I normally work in If it makes a differance here is the current release levels SQL Server Management Studio 15.0.18338.0SQL Server Ma...
0 votes
Thank you The work around is easy enough for now / comments
  1. Community
  2. SQL Prompt
  3. Format SQL function fails if SQLCMD mode variable is present
Thank you The work around is easy enough for now
0 votes
Yes that could very well be the case. Sorry to inconvenience you. When you get that situation, (failure without an identified error) you might want to issue a different error message suggesting an error in the proceeding/following code. I'm sure I am not the first to think Sql prompt was the problem, when it was really my code that was faulty. / comments
  1. Community
  2. SQL Prompt
  3. Minor bug with Shift-F5
Yes that could very well be the case. Sorry to inconvenience you. When you get that situation, (failure without an identified error) you might want to issue a different error message suggesting...
0 votes
I've tried it and it now works as I had anticipated. Thanks for you quick response / comments
  1. Community
  2. SQL Prompt
  3. $SELECTEDTEXT$ only expands once
I've tried it and it now works as I had anticipated. Thanks for you quick response
0 votes
Total activity
21
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4