Is that your entire stored procedure or did you strip something out?  It looks to me like you are missing a FROM.

My understanding, it won't work QUITE like that.  BUT what you could do is something like:

SELECT Itemcode,Itemname,ItemGroup
FROM tbl1
WHERE (itemgroup IS NULL and @ItemGroup IS NULL) 
 ...

DISREGARD THIS POST

I agree with Grant - you shouldn't need to do anything with the Antivirus.  I also agree that it is likely going to be firewall related on either...

• This reply was modified 3 years, 9 months ago by Mr. Brian Gale.

Sometimes it is good having a lot of detail, sometimes people are looking for a "quick and easy" answer and my detail just gets skimmed or ignored.

The XE trace will...

Do you have access to the source code behind the GUI?  If so, I would tackle it on the GUI source side of things NOT on the database side of...

I think a lot of it falls under "it depends".  IF you have the licenses, I would recommend putting it on a separate machine.  BUT SSRS needs a SQL license...

My opinion - I would try your query as just a SELECT without the CAST and see what you get back, as well as selecting all values in that CTE.

If...

Could you post your code and sample data and DDL?

You are doing something that the query optimizer thinks will be a SMALLINT, but that being said, 0.0000005328 WILL successfully cast...

My opinion, if you want to toss the full backup on onedrive in smaller chunks, I would include MD5's with the backups.

I am a bit confused what you mean by...

I can't say with 100% certainty the cause of the error, but to me that doesn't look like TSQL.

What I mean is the $ part and ESCAPE_NONE.  I don't know...

Has anyone used Brain Box SQL app for Android in the google play store?

What do you think?

I've been using it to connect remotely to my SQL Servers via...

I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect):

December 13, 2021 at 2:09 pm

#3963068

The way I would do it is similar to this:

DECLARE @test1 DATE = GETDATE()
DECLARE @test2 TIME = GETDATE()
SELECT @test1, @test2, CAST(CAST(@test1 AS VARCHAR(255)) +' '+ CAST(@test2 AS...

That last bit is EASY  to fix - trim your strings:

SELECT PARSENAME(TRIM(@statement), 1)

What I would check, and what I expect the problem is, is the "Package" tab.  What is probably happening or happened is that the SQL instance you are configuring the...