mathmath

Hi, All I encounter this problem when I am trying to insert some data manually for my project. Example: LA-R1, LA-R2 , LA-R5 , LA-R8 ….. [The Rs are Already in the Original Data] Simply put, my Goal is to fill in the gaps between the Rs. So, the result …

Hi All, I have data like the following: Stuff Sizes ID pen s1 100001 pen s2 100002 pen s3 100003 pencil s1 100001 pencil s3 100004 pencil s5 100007 pencil s2 100006 ruler s7 100005 ruler s8 100008 .. .. where each size is coordinate with a unique ID number; …

Hi all, I am trying to update Table[land] with the following data (simplified): [u]Scenarios:[/u] Num_1 like [A-Z], Num_1_Index like [1-9] Num_2 like [A-Z], Num_2_Index like [1-9] ..... Num_26 = [A-Z], Num_26_Index = [1-9] --------------------------------------------- Update land set Num_1_Index = case when Num_1 like 'A' then '1' when Num_1 like 'B' …

Hi everyone, I am working on a project where i have encounter such problems: Data samples: LA-1-2, LA-1-2-33, LA-1-22-333-4444, LA-2-3, LA-12-34, LA-123-45-67 .. with upto 8 dashes Objective: I need to find the values behind each dashes into multiple columns in orders. [e.g LA-1-2-33 will have columnA = 1,columnB = …