It looks like you aren't using SQL Server 2019 but MySQL. May be post it in MySQL forums?

Something like this should work ...

SELECT DISTINCT Age, ESPAC
 ,MIN(B2) OVER  (PARTITION BY Age, ESPAC ORDER BY B2) as MIN_B2
      ,PERCENTILE_CONT(0.05)...

• This reply was modified 3 years, 1 month ago by  murthyvs.

Hi Jeff,

Thanks for your note. Can you please reshare the link? It didn't come through in your post.

Here are two sample data sets that I made up:

Objective: Has Header. Ignore...

@jeff - Thanks for your advice.

@Ed - Thanks for your code snippet. It works. Here is what I had done.

declare @strPath varchar(2000);

declare @strDataFile varchar(2000);

declare @strCmd varchar(2000);

declare @scriptName varchar(100);

SET...

Hi Jeff - "W" is a FTP folder mounted as drive using a program called Webdrive. Thanks

Think its my error. I was selecting db_datareader, db_datawriter, db_ddladmin under Owned Schemas section. I selected the same ones in Membership and its working as expected now. Thanks for your...

Thanks for your input. I tried adding "database roles db_datareader, db_datawriter and db_ddladmin instead of the individual permissions" to the adhoc database for the testuser. I could login just fine...

Thanks for your reply. Tried it but wont work. May be few more things needed? Please see below for my steps.

Steps:

0. Logged in as windows user (admin)

1. Create a login...

Jeff Moden (12/21/2012)

---

murthyvs (12/11/2012)

---

Hello all - I am having hard time to split an input string into multicolumn - multirows.

Task - Create a stored procedure that reads an input string...

Results:

DelimitedSplit8K (Lynn Pettis)

SQL Server Execution Times:

CPU time = 280 ms, elapsed time = 133 ms.

PatternSplitCM (Dwain.C)

SQL Server Execution Times:

CPU time =...

mtassin (12/17/2012)

---

murthyvs (12/16/2012)

---

Hi dwain.c - I tried changing VARCHAR(8000) to VARCHAR(MAX). Ran the query with new pattern [0-9A-Za-z]. My input string is a very long string.

sample:

3038469

3138470

The results were as expected...

Hi dwain.c - I tried changing VARCHAR(8000) to VARCHAR(MAX). Ran the query with new pattern [0-9A-Za-z]. My input string is a very long string.

sample:

3038469

3138470

The results were as expected BUT the...

Hi - this a nice method. didnt know this before.

I have created this function and using it in a stored proc..

CREATE FUNCTION [dbo].[FnXmlSplit](@input_string VARCHAR(max))

RETURNS @temptable TABLE (

...

dwain.c (12/11/2012)

---

Here's another way:

DECLARE @MyString VARCHAR(8000) =

'30;38469|31;38470|32;38471|33;38472|34;38473|35;38474|36;38475|37;38476|38;38477|'

SELECT col1=MAX(CASE ItemNumber%4 WHEN 1 THEN Item END)

,col2=MAX(CASE ItemNumber%4 WHEN 3 THEN Item END)

FROM PatternSplitCM(@MyString,...

Hi - Quick question. Do you know why VARCHAR(MAX) doesnt work in this query?

It returns the following error:

Msg 240, Level 16, State 1, Line 110

Types don't match between the anchor...