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

Comments

Sort by recent activity
Hi Dan The SSMS Version that I am using is shown below SQL Server Management Studio 15.0.18369.0 SQL Server Management Objects (SMO) 16.100.46041.41 Microsoft Analysis Services Client Tools 15.0.19342.0 Microsoft Data Access Components (MDAC) 10.0.18362.1 Microsoft MSXML 3.0 6.0  Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.18363 Logging is set to Verbose as that was the first thing that I did check. / comments
  1. Community
  2. SQL Search
  3. SQL Search does not work in SSMS
Hi DanThe SSMS Version that I am using is shown belowSQL Server Management Studio 15.0.18369.0SQL Server Management Objects (SMO) 16.100.46041.41Microsoft Analysis Services Client Tools ...
0 votes
Version 1809 Build 17763.1457 - this the other computer where SQL Search works without any issue / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
Version 1809 Build 17763.1457 - this the other computer where SQL Search works without any issue
0 votes
Version 1909 Build 18363.1082 - on this version the SQL Search is not working at all / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
Version 1909 Build 18363.1082 - on this version the SQL Search is not working at all
0 votes
I have changed the connection time out and that still does not work and still gets the same error. It is still getting the indexing error - as mentioned previously this is only happening on this machine only  There is another computer when I use while working from home where SQL Search works without any issues  The only difference is that it is an older Windows Version I would like to fix it on this computer so I can use while working in the office / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
I have changed the connection time out and that still does not work and still gets the same error.It is still getting the indexing error - as mentioned previously this is only happening on this mac...
0 votes
What is the maximum value that you can put in that field? / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
What is the maximum value that you can put in that field?
0 votes
This only occurs on that specific network when I am connected and that is only when I am working in the office. Today I am working remote and connect to another computer for SSMS on that computer (which is a desktop) SQL Search works without any issues. it is only when I am in the office and run SSMS off of that connection - please keep this ticket open  I will try increasing the timeout the next time that I go in. / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
This only occurs on that specific network when I am connected and that is only when I am working in the office.Today I am working remote and connect to another computer for SSMS on that computer (w...
0 votes
Hi Tianjiao, No Force Encryption is turned off for the server / comments
  1. Community
  2. SQL Search
  3. SQL SEARCH getting Error while trying to index
Hi Tianjiao,No Force Encryption is turned off for the server
0 votes
The query would not work because the data is different The only thing that I can say is that the I am using a dynamic query to fill the global temp table as illustrated in my code snippet. Perhaps that is why it is not displaying the fields properly?? / comments
  1. Community
  2. SQL Prompt
  3. Feature Request / Question - Global Temp Tables
The query would not work because the data is differentThe only thing that I can say is that the I am using a dynamic query to fill the global temp table as illustrated in my code snippet.Perhaps th...
0 votes
The step by step procedure on how the global temp table is the code I sent I did not create the table ahead of time - I am just running a select statement and insert into the global temp table. I just want SQL PRompt to be able to display the columns in that table as it is a pain to manually have to type them in the code / comments
  1. Community
  2. SQL Prompt
  3. Feature Request / Question - Global Temp Tables
The step by step procedure on how the global temp table is the code I sentI did not create the table ahead of time - I am just running a select statement and insert into the global temp table.I jus...
0 votes
SET NOCOUNT ON; --Clear Temp Tables --IF (OBJECT_ID('tempdb..#UnderweightBMI') IS NOT NULL) -- DROP TABLE #UnderweightBMI IF (OBJECT_ID('tempdb..##UnderweightBMIPatients') IS NOT NULL) DROP TABLE ##UnderweightBMIPatients IF (OBJECT_ID('dbo.UnderweightBMI') IS NOT NULL) TRUNCATE TABLE dbo.UnderweightBMI --Dynamic Query Variables DECLARE @Columns NVARCHAR(MAX), @SQLQuery NVARCHAR(MAX) IF (@StartDate = @EndDate) BEGIN INSERT INTO dbo.UnderweightBMI (     AccountNumber,     Name,     LocationID, QueryID,     BMI ) SELECT  vnad.AccountNumber, vnad.Name, vnad.LocationID, vnnqr.QueryID, [BMI] = CAST(LEFT(vnnqr.Response, CHARINDEX('.', vnnqr.Response) - 1) + '.' + SUBSTRING(vnnqr.Response,(CHARINDEX('.', vnnqr.Response)+1),3) AS DECIMAL(9,1)) --vnnqr.Response --INTO #UnderweightBMI FROM livedbNWH.dbo.vNWH_AbstractData vnad  JOIN livedbNWH.dbo.vNWH_AdmVisits vnav ON vnad.VisitID = vnav.VisitID JOIN livedbNWH.dbo.vNWH_AdmittingData vnad2 ON vnad.VisitID = vnad2.VisitID JOIN livedbNWH.dbo.vNWH_NurQueryResults vnnqr ON vnad.VisitID = vnnqr.VisitID WHERE  ((vnav.InpatientOrOutpatient = 'I' OR vnad.ObservationPatient = 'Y') OR vnav.Status = 'REG SDC') AND vnad.DischargeDateTime IS NULL --AND vnnqr.QueryID = 'N.BMI'  AND vnnqr.QueryID IN ('N.BMI', 'NNUBMI') AND CAST(LEFT(vnnqr.Response, CHARINDEX('.', vnnqr.Response) - 1) + '.' + SUBSTRING(vnnqr.Response,(CHARINDEX('.', vnnqr.Response)+1),3) AS DECIMAL(9,1)) < 19.0 GROUP BY vnad.VisitID, vnad.AccountNumber, vnad.Name, vnad.AdmitDateTime, vnad.LocationID, vnav.Status, vnnqr.QueryID, vnnqr.Response ORDER BY  --vnad.LocationID vnad.VisitID END ELSE     BEGIN INSERT INTO dbo.UnderweightBMI (     AccountNumber,     Name,     LocationID, QueryID,     BMI ) SELECT  vnad.AccountNumber, vnad.Name, vnad.LocationID, vnnqr.QueryID, [BMI] = CAST(LEFT(vnnqr.Response, CHARINDEX('.', vnnqr.Response) - 1) + '.' + SUBSTRING(vnnqr.Response,(CHARINDEX('.', vnnqr.Response)+1),3) AS DECIMAL(9,1)) --vnnqr.Response --INTO #UnderweightBMI FROM livedbNWH.dbo.vNWH_AbstractData vnad  JOIN livedbNWH.dbo.vNWH_AdmVisits vnav ON vnad.VisitID = vnav.VisitID JOIN livedbNWH.dbo.vNWH_AdmittingData vnad2 ON vnad.VisitID = vnad2.VisitID JOIN livedbNWH.dbo.vNWH_NurQueryResults vnnqr ON vnad.VisitID = vnnqr.VisitID WHERE  ((vnav.InpatientOrOutpatient = 'I' OR vnad.ObservationPatient = 'Y') OR vnav.Status = 'REG SDC') --AND vnnqr.QueryID = 'N.BMI'  AND vnnqr.QueryID IN ('N.BMI', 'NNUBMI') AND CAST(LEFT(vnnqr.Response, CHARINDEX('.', vnnqr.Response) - 1) + '.' + SUBSTRING(vnnqr.Response,(CHARINDEX('.', vnnqr.Response)+1),3) AS DECIMAL(9,1)) < 19.0 AND ((CONVERT(DATE, vnad.AdmitDateTime) BETWEEN CONVERT(DATE, @StartDate) AND CONVERT(DATE, @EndDate)) OR (CONVERT(DATE, vnad.DischargeDateTime) BETWEEN CONVERT(DATE, @StartDate) AND CONVERT(DATE, @EndDate))) GROUP BY vnad.VisitID, vnad.AccountNumber, vnad.Name, vnad.AdmitDateTime, vnad.LocationID, vnav.Status, vnnqr.QueryID, vnnqr.Response ORDER BY  --vnad.LocationID vnad.VisitID END --Get QueryIDs for the Pivot Column Names SELECT @Columns = STUFF((SELECT Distinct  ',' +   QUOTENAME(ub.QueryID) from dbo.UnderweightBMI ub group BY ub.QueryID, ub.BMI --order by Question   FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)')  ,1,1,'') --SELECT @Columns /* SELECT ub.AccountNumber,    ub.Name,    ub.LocationID,    ub.QueryID,    ub.BMI  FROM #UnderweightBMI ub */ --Dynamic Pivot SQL Query SET @SQLQuery = N'SELECT AccountNumber, Name, LocationID, ' + @Columns + N' INTO ##UnderweightBMIPatients from  ( SELECT ub.AccountNumber,    ub.Name,    ub.LocationID,    ub.QueryID,    ub.BMI  FROM dbo.UnderweightBMI ub          ) x pivot  ( max(BMI) for QueryID in (' + @Columns + N') ) p ' --SELECT @query; EXEC  sys.sp_executesql @SQLQuery --Output Final Results for Daily Report SELECT   AccountNumber, Name, LocationID, [BMI] = COALESCE([N.BMI], [NNUBMI]) FROM ##UnderweightBMIPatients / comments
  1. Community
  2. SQL Prompt
  3. Feature Request / Question - Global Temp Tables
SET NOCOUNT ON; --Clear Temp Tables --IF (OBJECT_ID('tempdb..#UnderweightBMI') IS NOT NULL) -- DROP TABLE #UnderweightBMI IF (OBJECT_ID('tempdb..##UnderweightBMIPatients') IS NOT NULL) DROP TABLE ...
0 votes
Total activity
70
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
13