my table as below

create table #partsfeature
  (
  PartId int,
  FeatureName varchar(300),
  FeatureValue varchar(300),
  PartFeatureNumber int
  )
   insert into #partsfeature(PartId,FeatureName,FeatureValue,PartFeatureNumber)
...

for the Part 3900

I have feature name grail and feature value 51V it exist on table before insert and take technology id 2

so when insert same feature name with value...

I solved issue

DECLARE @MaxTechnologyID AS BIGINT =

( SELECT MAX(TechnologyId)

FROM #partsfeature

)

SELECT *,CAST (DENSE_RANK() OVER ( ORDER BY FeatureString)

+ @MaxTechnologyID AS BIGINT) AS NewTechnologyId

from #partsfeature

how to write query detect numbers like IE only

i need to write query detect numbers like IE only

thank you for reply

this will solve issue of IE

but it will add  extra 0 on right on another values

8 become

8.00000000000000000

1005 become

1005.00000000000000000

so how to handle it please

Does the ChemicalHash table ONLY contain rows where the ChemicalID is NULL

yes

ChemicalHash table have chemical id is null and i will update it by chemical id

that exist on table fmdchemical

table...

thank you for interset

what ou need to understand i will answer you

my issue is if i have file already exist

and this file have header

studentid,studentname

then after using query

it become studentid,Name

How to keep header on excel file already exist without change

to do that...

thank you for reply

i need any one help me

i will explain issue

firstly i use script below to export data from sql server to excel

CREATE TABLE #FinalExportList(TableCount INT...

i updated my original post

Question is how to prevent header from change on excel if already exist

really very good support

thanks you

can you please give me function

dbo.fnTally

to check this query

code below give me part from my expected result

because it give me gaps null between dates remaining to get dates until current month

so How to do that please ?

what i...

• This reply was modified 2 years, 9 months ago by  ahmed_elbarbary.2010. Reason: make part from solution remaining get part id until current date

i make what you say above and remove index not needed

this is my estimated execution plan after remove indexes no needed

https://www.brentozar.com/pastetheplan/?id=HkBWmbWZ9

and this is actual execution plan after remove...

• This reply was modified 2 years, 10 months ago by  ahmed_elbarbary.2010.

can you may clear what you mean by

has caused a huge and terrible CROSS JOIN.

really this issue is very strange