OK, I tried

WITH (FIRSTROW=2, LASTROW=1000, FIELDTERMINATOR=',', ROWTERMINATOR='\r', FIELDQUOTE='quote_characters');

But got the following error

Invalid quote character specified for bulk load. Quote character can be one single byte or Unicode character.

If you...

I have never worked with BULK INSERT, but maybe try adding

FIELDQUOTE = 'quote_characters'

A shot in the dark here .....

A shot in the dark here ..

Since you...

The following code will achieve your requirement.

However, you may want to add code to prevent duplicates

 INSERT INTO #t( id, name )
 SELECT ISNULL((SELECT MAX(id) FROM #t),...

Updating Phil's code, this will cater for the space in [Case ID]

CREATE TABLE #SomeXML ( TheData text NOT NULL );

INSERT  #SomeXML ( TheData )
VALUES ( '<SB><Case...

In addition to the responses above, the following part of the WHERE clause will always result in a table/index scan

AND (@Session = 0 OR @session = SessionID)

That...

i have rephrased the question

DECLARE @s-2 VARCHAR(MAX)= 'r1,r2' SELECT PATINDEX('%[^A-Za-z0-9-())![]]%',@s)

DECLARE @S1 VARCHAR(MAX)= 'X1;r2' SELECT PATINDEX('%[^A-Za-z0-9-())![]]%',@s1)

i need to get first text string  before first comma or semicolan ex "r1" and "x1" respectivily...

DECLARE @ColumnList nvarchar(4000);

SET @ColumnList = STUFF( (SELECT N',' + ac.name
                ...

Using LIKE %SomeVal% is always going to be slow as SQL has to do a table/index scan.

However, I have gotten pretty good performance using Trigram searches

https://sqlperformance.com/2017/09/sql-performance/sql-server-trigram-wildcard-search

You would probably get the best response directly from Brent Ozar

https://www.brentozar.com/contact/

I suspect that the amount of time that you are experiencing is due to the time for the data to be shown on the screen, not the time for SQL...

pgAdmin appears to be some sort of PostGreSQL tool

Perhaps yo would get better answers from a PostGreSQL forum.

So, you are expecting the value to be truncated and not rounded.

Try this

DECLARE @id numeric(17, 2) = ROUND('123.456', 2, 1)

SELECT  @id;

Your use of the RIGHT function is incorrect.

Here are 3 different ways to achieve the format you are looking for

Using SUBSTRING

            
November 22, 2021 at 6:52 am
            
#3955457