thank you for reply

function is good but hot to modify dynamic query generated @sql

with another meaning how to use function above  on @ConStr to prevent error from happen

can...

sample data

CREATE TABLE [Parts].[Nop_Part](
[PartID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[PartNumber] [nvarchar](70) NOT NULL,
[Masked_ID] [int] NULL,
 CONSTRAINT [PK_Nop_Part] PRIMARY KEY CLUSTERED 
(
[PartID] ASC
)

insert into [Parts].[Nop_Part](PartID,PartNumber,Masked_ID)
values
('31345983','PLT0603Z1372ABT0','29283933') ,
('31345984','PLT0603Z1372ABT1','29283933') ,
('31345985','PLT0603Z1372ABT5','29283933')...

OK

TradeCodeIdPartIdPartlevelCodeTypeCodeValue
1         1222  1         ECCS-USAB123-US
2      ...

• This reply was modified 4 years, 8 months ago by  ahmed_elbarbary.2010.
• This reply was modified 4 years, 8 months ago by  ahmed_elbarbary.2010.

I need to replace while loop above with any thing else can do loop but good performance

meaning i dont need to loop using cursor or while loop

i need any thing...

according to your solution it will be one time only

I need repeated check

so  it will not be valid to use

I have insertiondate on table have formate dd/mm/yyyy

I need when user write any formate different from dd/mm/yyyy

like mm/dd/yyyy or yyyy/mm/dd

convert to dd/mm/yyyy

How to do that please ?

• This reply was modified 4 years, 11 months ago by  ahmed_elbarbary.2010.

can any one help me on that

revision_ID COUNTPARTS COMPANY
1000 3 KMCOMPANY
2000 2 WANDERCOMPANY
3000 1 WILIAMCOMPANY

parts.rohs

zprtid forign key for table [Parts].[Nop_Part]

id zpartid revisionid

parts.rohs
zprtid forign key for table [Parts].[Nop_Part]
id zpartid revisionid 
9000...

many records returned may be one militon rows from cte to temp table

how to indexes field i selecting

can you help me please 
query what i do as following
select BranchCode,UnitCode,RequiredAmount, Serial,Year,Month,CurrentReadingDate,CurrentMeterReading,LastMeterReading,CurrentConsumption,CurrentConsumptionValue ,VATValue,CleaningFees
from
(
select BranchCode,UnitCode,RequiredAmount, Serial,Year,Month,CurrentReadingDate,Convert(varchar,CurrentMeterReading) as CurrentMeterReading,Convert(varchar,LastMeterReading) as LastMeterReading,Convert(varchar,CurrentConsumption)...

thank you for reply 
right side OK working on EXPR2 but
expr1 not working as left side 
my query used 
SELECT   TOP (99.9999999) PERCENT SpecialCode , ...

yes

but remaining to get packages related to hotels
can any one help me how to write sql query get packages related to hotel as below
i do as following

i do it as following and it working :
DECLARE @DateFrom DATE = '20170628';DECLARE @DateTo DATE = '20170705';
DECLARE @StartID NVARCHAR(255) = 'SD01';
WITH  DurationDetailsNumeric AS ( SELECT *...