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
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
I have a temptable built using a dynamic query but it is not displaying the fields inside...this is why I suggested it. / comments
  1. Community
  2. SQL Prompt
  3. Feature Request / Question - Global Temp Tables
I have a temptable built using a dynamic query but it is not displaying the fields inside...this is why I suggested it.
0 votes
Sure that would be fine Thanks, / comments
  1. Community
  2. SQL Search
  3. SQL Search not working on Windows 10 Laptop
Sure that would be fineThanks,
0 votes
https://northwell-my.sharepoint.com/:u:/r/personal/vjacob1_northwell_edu/Documents/Documents/SQL%20Search/Windows10_Desktop_SQLSearchAddin-1d3fb988-09cf-4dff-9239-aa717512a51a.log?csf=1&e=3X9brM / comments
  1. Community
  2. SQL Search
  3. SQL Search not working on Windows 10 Laptop
https://northwell-my.sharepoint.com/:u:/r/personal/vjacob1_northwell_edu/Documents/Documents/SQL%20Search/Windows10_Desktop_SQLSearchAddin-1d3fb988-09cf-4dff-9239-aa717512a51a.log?csf=1&e=3X9brM
0 votes
https://northwell-my.sharepoint.com/:u:/r/personal/vjacob1_northwell_edu/Documents/Documents/SQL Search/Windows10_LaptopSQLSearchAddin-210f1d0b-c46d-471f-a216-bd7ea24fe258.log?csf=1&amp;e=OzNg3k  / comments
  1. Community
  2. SQL Search
  3. SQL Search not working on Windows 10 Laptop
https://northwell-my.sharepoint.com/:u:/r/personal/vjacob1_northwell_edu/Documents/Documents/SQL Search/Windows10_LaptopSQLSearchAddin-210f1d0b-c46d-471f-a216-bd7ea24fe258.log?csf=1&amp;e=OzNg3k 
0 votes
Total activity
70
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
13