can you help me

applying that please

thank you for reply

what i need to get part with related mask

so until now i not give my part number any unique number

and give mask number same unique number i...

thank you for reply

what benefit from above

familyIDPArtNumber(No column name)
7524090T496X755________
7524090T496X755KT________
7524090T496X755MT________
7524090T496X754________
7524090T496X754KT________
7524090T496X754MT________
7524090T496B755________
7524090T496B755KT________
7524090T496B755MT________
7524090T496B754________
7524090T496B754KT________
7524090T496B754MT________

why result ended with underscore

can you please tell me what idea from that

can i generate unique id for table getfinaldatapc by checksum or what every

and generate unique id for table getfinaldatapcmask also by checksum

then join between two tables by id generated

if this...

thank you for reply

are there are another solution dynamic for that

on my case there are partnumber and masknumber like below

familyid    PartNumber   MaskNumber
7524090    ...

thank you for reply

but this different code sample

so how to rewrite after where condition

i write this post again because i don't mention issue on first post clear

so i write here clear on this post

my issue on lines below

SELECT [Page ID],Substring([ParentObject],CHARINDEX('Slot', [ParentObject])+4, (CHARINDEX('Offset', [ParentObject])-(CHARINDEX('Slot',...

can you help me

issue on that line

Invalid length parameter passed to the LEFT or SUBSTRING function

SELECT [Page ID],

Substring([ParentObject],CHARINDEX('Slot', [ParentObject])+4, ABS(CHARINDEX('Offset', [ParentObject])-(CHARINDEX('Slot', [ParentObject])+4))) as [Slot ID]

CREATE TABLE [dbo].[Student]( [Sno] [int] NOT NULL, [Student ID] nvarchar(6) Not NULL , [Student name] [varchar](50) NOT NULL, [Date of Birth] datetime not null, [Weight] [int] NULL)...

thank you very much

thank you for reply

but sample is static code

I need query to be not static

as pt.PartId=22390

because table have more than 1000000 rows

thank you for reply

procedure above make pivot on general

so an you please help me how to execute it

exec  [dbo].[rs_pivot_table] ?,???????

what paramters i pass to work

this is exactly my question

thank you for reply

code above will get repeated rows per companyid and partid and this I need

but i need also different status

meaning

I Need below because repeated and different status

            
January 1, 2021 at 7:00 am
            
#3826110

            
            
                                                
        

thank you for reply

this is static i need it dynamic because sometimes i don't know features on table

so if possible i need it depend on features exist on table partsdata

and...

thank you for reply

can you help me do it by while loop