Viewing 9 posts - 1 through 9 (of 9 total)
Yes, I searched and came across "Jeff Moden's infamous delimitedSplit8K function". I was looking for an alternative way. I will implement Jeff Moden's infamous delimitedSplit8K function. Thanks for the reply.
December 5, 2022 at 7:25 pm
Correction I need help with also the first name because I'm getting the middle Initial in my first name results;Example First Name Results= John J
December 3, 2022 at 11:15 pm
Hey Phil,
You are correct had 30,000+ records with the word "Responsibility" misspelled and 400+ spelled correctly. Ran replace function to correct the misspelling.
SELECT Pos1 = CHARINDEX('Total Paid amount is $',...
February 22, 2022 at 12:18 am
Phil,
I'm getting this error. Here is my sql statement:
SELECT Notes, NoteId
,TotalPaid = SUBSTRING(Notes, c.Pos1, c.Pos2 - c.Pos1)
FROM dbo.NoteReceive
CROSS APPLY
(
SELECT Pos1 = CHARINDEX('Total Paid amount...
February 21, 2022 at 1:46 pm
Never mind Phil, I got it. Thank you for your help. also thank you Jonah.
February 21, 2022 at 1:39 pm
Thanks Phil,
I'm sorry for such a novice question(New to SQL) I have this information in a Notes Field along with an ID Field in a table. How do I reference...
February 21, 2022 at 1:18 pm
Hi Phil,
I'm trying to exact the Payment information (In Red). My problem is they all have different starting positions, I did the Charindex recommend by Johan and I get 42,43,44,45,46...
February 21, 2022 at 12:54 pm
Thank you Johan,
I tried the Charindex and I'm able to find the starting position. I have multiple positions 42,43,44,45,46. What's the best way to go about this? a Case statement...
February 21, 2022 at 12:47 pm
Viewing 9 posts - 1 through 9 (of 9 total)