Hi,

It seems you should make use of in-built function String_split .

Thanks.

Also, is the IP stored as below?
"192.168.13.12" -> "192168013012"

If that is the case, we can make use of SUBSTRING function to extract that.

Hi,

Does converting to unsigned int prior to converting to Bigint solve your problem as shown below?

SELECT
    ACCESSPANE.NAME AS IC_Panel_Name,
    ACCESSPANE.ADDRESS AS IC_Panel_Address,...

Hi,

What error you are getting if you try this?

SELECT
    ACCESSPANE.NAME AS IC_Panel_Name,
    ACCESSPANE.ADDRESS AS IC_Panel_Address,
    PANELTYPE.NAME AS IC_Panel_Type,
    READER.READERDESC...

Hi Daniel,

I am sorry, I missed a crucial condition while fetching the StartDate and EndDate in the loop. Please change the  following lines with the where clause:

Hi,

Can the following approach help?

CREATE PROCEDURE ExecuteBatch
AS
BEGIN
    DECLARE @CurrentMonth INT
    DECLARE @MaxMonth INT
    DECLARE @Year INT
    DECLARE @StartDate DATETIME
    DECLARE...

Hi,

As you are using SQL 2017 forum, you can make use of STRING_SPLIT() function passing ' ' as the delimiter I think.

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

Thanks.

Hi,

It should be Scaffold-DbContext. I think you have a typo.

Thanks.

Hi,

As per my understanding, running sp_updatestats is a good option (may be weekly or daily) for a OLAP environment where we have mostly static data not updated frequently....

Hi,

Can you please post the DDL needed to create the required tables (also with some sample data)?

Hi,

Can you use Powershell script as mentioned in this article?
https://docs.microsoft.com/en-us/powershell/module/sqlserver/get-sqlinstance?view=sqlserver-ps

Thanks.

Hi,

You can get a list of stored procedures that runs on startup by:

SELECT * FROM sys.procedures WHERE OBJECTPROPERTY([object_id],'ExecIsStartUp') = 1


If you...

I do not see any use of the other table (SPOOL), then why are you putting a JOIN with that?

In case you need to check whether the AGRNO...

Hi,

You have to go with UPDATE statement only here. But in case you have any index present on that table (which is going to be updated), you can...

Hi,

In case you are pulling data from a lookup table, you may dump all those values into a temporary table (say #TmpNotAllowed) and then do a query like...