Comments by ahmed_sa (Top 200 by date)

please provide to me full answer


--Select--
@foreach (var printer in Model.PrinterList)
{

@printer.PrinterName


}



on JavaScript i do as below :

var selectElement = document.getElementById("PrinterName-select");
selectElement.addEventListener("change", function () {
var selectedOption = selectElement.options[selectElement.selectedIndex];
var selectedText = selectedOption.text;
var selectedId = selectedOption.id;
console.log("Selected Text: " + selectedText);
console.log("Selected ID: " + selectedId);
on page model two properties display as null value so How to solve this issue please

public ActionResult OnGetSelectedPrinter(string selectedtext,string selectedvalues)
{
string a = SelectedOptionValue;//display as null
string b = SelectedOptionText;//display as null
}

JS.InvokeVoidAsync not working on event OnInitializedAsync()

so can you help me answer these questions
1- are this issue must solved or this is normal and no impact for it
2- if i publish my blazor web app will stuck and hang on same line or what
please can you answer me for these questions please ?

but this is normal not make issue when run on server application

are this will happen on server or ignore it

so are ignore it or what i afraid if stuck when run on server

so please how to solve error on publish Warning: Failed to connect via WebSockets, using the Long Polling fallback transport. This may be due to a VPN or proxy blocking the connection. To troubleshoot this, visit

yes

ok but if i need to return count with rows
are this possible if yes how

i get error
Uncaught TypeError: $(...).Pagination is not a function
at HTMLDocument.<anonymous> (site.js:4:26)
at e (jquery.min.js:2:30005)
at t (jquery.min.js:2:30307)
so what this error and how to solve it

can you tell me what tools will be used to working with this code as jquery version and css like that

can you show me how to use jquery with web page index.cshtml

so can you tell me how to call jquery inside index.cshtml

thanks for support i don't ask for code i ask for sample scenario or situation or cases using delegate and events

only one question please connection string will be
server=DESKTOP-L558MLK\AHMEDSALAHSQL,database=testdata_Dev,userid=sa and password=321
OR
using connection string

metadata=res://*/ERPEntities.csdl|res://*/ERPEntities.ssdl|res://*/ERPEntities.msl;provider=System.Data.SqlClient;provider connection string="data source=DESKTOP-L558MLK\AHMEDSALAHSQL;initial catalog=testdata_Dev;persist security info=True;user id=sa;password=321;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient"

so what i do to solve issue

can you show me what you mean ?

if i need both equal how to write statment make both two value equal
according to me both are equal
so how to make both statment equal please

so can there are any function can make both values equal
these two value are equal
can i add any function can make both equal

why this paths display
are this paths below have issue
are paths mention must have permission
and what permission must have
also sql installing on d drive
are this issue
or must sql install on pth it have operating system

File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 307, in read_excel
io = ExcelFile(io, engine=engine)
File "D:\SQL Data\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 394, in init

last question are using python on sql server 2019 support create and write and read file remotely on shared path meaning reading and writing excel file from remote server
or not support

All application package permission for shared path I need to access AND read it is necessary
now shared path not have all application package so must add it or not

are netservice/launchpad must add permission read and write for path i need to access
or not needed

I have permission on folder every one and system and account create running service

so please how to setup correctly

you can connect to a 3rd machine and query data on it?
yes

i can't over python script
but using openrowset using same path i need to read from it
it read success
but using python can't

using account sobhy i can connect to another server and read data using openrowset
so if there are way to read data from server to server this meaning i can access it
so why message display access is denied
can you help me please

account is i login with it name sobhy

thanks for support
sure file not open
and if account i run python from it not have permission
i use this account with open rowset and read data
so can you give me more detail please

also it is not job it is python script running on sql server

I appreciate your support
1-What account is running the Python scripts? Are these Jobs running on the SQL Server?
yes running on sql server 2019 with account admin
2-On the 192.168.7.9 machine, is there a network share setup holding the files you're trying to read? What's the name of that share?
yes there are network shared setup exist and i can expolore it and open it manually
3-Is your network setup as in an AD domain and are BOTH of these machines in that domain?
yes
I try it by openrowset and read data from server 7.9 shared path
to server 7.7 by using openrowset
4-is the account running the scripts on the remote server setup to have Read permissions to the share?
yes have permission read

i need to write another query instead of above because comparison make query is very slow with big count so can you help me with another query writing

good but what tools can let me boot to hard without using current operating system

how to use this to solve error please
if (Object.ReferenceEquals(null, myObjVar)) { ....... }

After more search I found that `os.path.isdir`working local not remote
so How to solve this issue please

thank you for reply
can you help me
i will show the actual Python script and the output of when it runs.
but how to show it
tell me what i do to show you

the goal mfrom asking question is to get result above without string aggreagte or comma separated
suppose i have
p1 1,2,3
p2 2,2,2
both p1 and p2 both have same count and same sum
so are there are another solution without
using string aggregate

i need it because it must feature name and feature value display order by ZfeatureKey

this error generated with every package i need to install with python

thank you for reply
so what i do to solve issue please
im beginner on python

so how to solve issue and get expected result please
i try as below
SELECT *
FROM #mass
WHERE ABS(chemicalmass - chemicalmassmodified) > 0.01
but not working

but if not access why
open rowset get data from same ip and same path

after apply answer above i get error as

full error as below

Msg 39004, Level 16, State 20, Line 0
A 'Python' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
Msg 39019, Level 16, State 2, Line 0
An external script error occurred:

Error in execution. Check the output for more information.
Traceback (most recent call last):
File "<string>", line 5, in <module>
File "C:\ProgramData\MSSQLSERVER\Temp-PY\Appcontainer1\B6088BCA-3151-4E8E-B865-76108461458A\sqlindb_0.py", line 31, in transform
df = pd.read_excel("\\192.168.7.9\\Import\6\strtinsertinput (4)-953aee07-ca14-4213-a91e-ab0b0f7f3db2.xlsx", sheet_name = "Sheet1")
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\util\_decorators.py", line 178, in wrapper
return func(*args, **kwargs)
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\util\_decorators.py", line 178, in wrapper
return func(*args, **kwargs)
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 307, in read_excel
io = ExcelFile(io, engine=engine)

Msg 39019, Level 16, State 2, Line 0
An external script error occurred:
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\excel.py", line 394, in __init__
self.book = xlrd.open_workbook(self._io)
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\xlrd\__init__.py", line 111, in open_workbook
with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory: '\\192.168.7.9\\Import\x06\\strtinsertinput (4)-953aee07-ca14-4213-a91e-ab0b0f7f3db2.xlsx'

SqlSatelliteCall error: Error in execution. Check the output for more information.
STDOUT message(s) from external script:
SqlSatelliteCall function failed. Please see the console output for more information.
Traceback (most recent call last):
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy\computecontext\RxInSqlServer.py", line 605, in rx_sql_satellite_call
rx_native_call("SqlSatelliteCall", params)
File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy\RxSerializable.py", line 375, in rx_native_call
ret = px_call(functionname, params)
RuntimeError: revoscalepy function failed.

thank you for reply
i try answer posted above but i get error
Msg 39004, Level 16, State 20, Line 0
A 'Python' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
Msg 39019, Level 16, State 2, Line 0
An external script error occurred:

Error in execution. Check the output for more information.
Traceback (most recent call last):
File "<string>", line 5, in <module>
File "D:\ProgramData\MSSQLSERVER\Temp-PY\Appcontainer1\F760843E-D95E-47A2-B40E-3106F323A76E\sqlindb_0.py", line 31, in transform
f = open("\\192.168.7.9\\Import\6\strtinsertinput (4)-953aee07-ca14-4213-a91e-ab0b0f7f3db2.xlsx")
FileNotFoundError: [Errno 2] No such file or directory: '\\192.168.7.9\\Import\x06\\strtinsertinput (4)-953aee07-ca14-4213-a91e-ab0b0f7f3db2.xlsx'

SqlSatelliteCall error: Error in execution. Check the output for more information.

thank you for reply and interset
what you mean by following

You are defining the relationship between the tables with [MessageRule] [varchar](800) NULL and [GeneratedGroupRule] [nvarchar](500) NULL. What do you think will happen if there are any rows in the tables where those values are NULL?
You will essentially get a Cross Join (a Cartesian Join). In general, do not use columns that can contain NULL as a way of defining the join.

what you mean by that please
i need to understand this point

all point i understand and release it

let me know
what i put on where
and why and use where
and what you mean by
Cartesian join on 800 char columns
can you tell me

i can assign rank for parts based on feature name and feature value
issue i face if feature name and feature value exist before then take technology id for that

you calculate by "addition" with :
Technology = dense_rank over ..... + select max(technologyId)
yes

how to write query detect numbers like IE only
i need to write query detect numbers like IE only

if i using checksum hasing will be good or not good to get every hash store as integer

are will bad performance if i make it varbinary(300) or no need

so which is best length i can use for my case above
i use varbinary(32)
Msg 8152, Level 16, State 30, Line 2
String or binary data would be truncated.
The statement has been terminated.

this is excellent answer for my question
so 1- which is best SHA256, or SHA2_512
2-compare multi column hash with each other is best
or concatestring string hash on one column and compare it
3-can i create index on column varbinary

so are possible to get text data from
0x11AF8281C1FB70097586CDCA6A9B2CA35BCC464CCD4F57D3C1D347371EB8433015080669AE93141D8A170822BB803CC36015841ED3BA853D322201C4A25F9E8D

how to get data from
0x11AF8281C1FB70097586CDCA6A9B2CA35BCC464CCD4F57D3C1D347371EB8433015080669AE93141D8A170822BB803CC36015841ED3BA853D322201C4A25F9E8D

i need to get header from file instead of write it because
may be i will use this query to export data for another table

yes very good
but if i need to read it from excel
without write it can you help me on that please

meaning i will get header exist on excel file already exist and export data based on it

can you show me how to implement below if possible please
im beginner on python
header bool or list of str, default True
Write out the column names. If a list of string is given it is assumed to be aliases for the column names.

sorry you are correct
so how to add header names as described in the documentation at pandas.DataFrame.to_excel

my script is dynamically may be table changed so column will be changed i can't pass it static
so can you help me please

Thank you for reply
I test that and give me data without header


1 ahmed
2 eslam
3 mohamed

no header for data
see image below
https://www.mediafire.com/view/fgkrnvmg0iox9ka/img_picture_issue.png/file

i don't have permission to change or renamce column on sql server
so please can you help me
ho to et data to excel have header without change it

I updated original post by expected result

thanks for reply
no no need that
I don't need to change column from sql
no practical to go to table and change column name
i need to export data without overwrite header excel
meaning i will get data and fill excel with header exist on excel without change it
so excel file have header
studentid studentname
export data to these two columns without change header name
so please can you help me please ?

are there are any issue if i use delete

I Need overwrite excel sheet without change header
as example
i have excel sheet have studentid and student name
when export i will get data for same header

thank you for reply
really i need to solve issue but can't know what i do
i need to overwrite excel file already exist without change header

i need to insert data from excel to sql server 2017

im not read from excel
i need to import data from excel to sql server 2017

it compare two excel file and if it matched then it return file and if not then it must return message not matched

function compare excel

public bool CompareExcel(string filePath, string templatePath, out int rowCount, out string error)
{
error = ""; rowCount = 0;
bool areIdentical = false;
string templateSheetName = "";
List<string> columns;
GetTemplateSchema(templatePath, out templateSheetName, out columns);
areIdentical = CompareBySchema(filePath, templateSheetName, columns, out rowCount, out error);
return areIdentical;
}

thank you for reply can you help me please
when i debug my api it not give me exception
so how it server error

sorry i know that
but i can't share public ip
so this is not issue

can you check update original post

but remain to get dates until current date so how to do it please

can any one help me
i do part from what i need as below
1-i get gap between dates

;with cte as (
select partid, createddate,
dateadd(month, -1,
coalesce(lead(createddate) over (partition by partid order by createddate),
max(createddate) over ()
)
) as end_month
from Parts
union all
select partid, dateadd(month, 1, createddate), end_month
from cte
where createddate

how to reduce it please can you please answer to me

can you show me how by code if possible

MNH32 5601 484456
KLMD33 5022 484456

these two rows i don't need it because i need group that have only one souce 484456

no not that what i need
i need vcompany and given part number that have only one source type 484456

IF OBJECT_ID('[dbo].[gen]') IS NOT NULL
DROP TABLE [dbo].[gen]
IF OBJECT_ID('[dbo].[PartAttributes]') IS NOT NULL
DROP TABLE [dbo].[PartAttributes]
IF OBJECT_ID('dbo.core_datadefinition_Detailes') IS NOT NULL
DROP TABLE core_datadefinition_Detailes




CREATE TABLE core_datadefinition_Detailes(
[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[ColumnName] [nvarchar](500) NOT NULL,
[ColumnNumber] [int] NOT NULL,

CONSTRAINT [PK_Core_DataDefinition_Details] PRIMARY KEY CLUSTERED
(
[ID] ASC
)
)
insert into core_datadefinition_Detailes([ColumnNumber],[ColumnName])
values
(202503,'Product Shape Type'),
(1501170111,'Type'),
(202504,'Package Family')







CREATE TABLE [dbo].[gen](
[TradeCodeControlID] [int] IDENTITY(1,1) NOT NULL,
[CodeTypeID] [int] NULL,
[RevisionID] [bigint] NULL,
[Code] [varchar](20) NULL,
[ZPLID] [int] NULL,
[ZfeatureKey] [bigint] NULL,

) ON [PRIMARY]


GO
SET IDENTITY_INSERT [dbo].[gen] ON
INSERT [dbo].[gen] ([TradeCodeControlID], [CodeTypeID],[RevisionID], [Code], [ZPLID], [ZfeatureKey]) VALUES (7565, 849774, 307683692, N'8541100050', 4239, 202503)
INSERT [dbo].[gen] ([TradeCodeControlID], [CodeTypeID],[RevisionID], [Code], [ZPLID], [ZfeatureKey]) VALUES (7566, 849774, 307683692, N'8541100050', 4239, 202504)
INSERT [dbo].[gen] ([TradeCodeControlID], [CodeTypeID],[RevisionID], [Code], [ZPLID], [ZfeatureKey]) VALUES (7567, 849774, 307683692, N'8541100050', 4239, 1501170111)


SET IDENTITY_INSERT [dbo].[gen] OFF

CREATE TABLE [dbo].[PartAttributes](
[PartID] [int] NOT NULL,
[ZfeatureKey] [bigint] NULL,
[AcceptedValuesOption_Value] [float] NULL,
[FeatureValue] [nvarchar](500) NOT NULL
) ON [PRIMARY]

GO
INSERT [dbo].[PartAttributes] ([PartID], [ZfeatureKey], [FeatureValue]) VALUES (413989, 202503, N'Discrete')
INSERT [dbo].[PartAttributes] ([PartID], [ZfeatureKey], [FeatureValue]) VALUES (413989, 1501170111, N'Zener')
INSERT [dbo].[PartAttributes] ([PartID], [ZfeatureKey], [FeatureValue]) VALUES (413989, 202504, N'SOT')






SELECT PartID,Code,Co.CodeTypeID,Co.RevisionID,Co.ZPLID,Count(1) as ConCount,
stuff(( SELECT '$' + CAST( CP.ColumnName AS VARCHAR(300)) AS [text()]
FROM(SELECT distinct d.ColumnName,C.codeTypeId,C.Code,C.ZfeatureKey from gen C
inner join core_datadefinitiondetails d with(nolock) on C.ZfeatureKey=d.columnnumber
INNER JOIN PartAttributes P on P.partid=PM.partid)CP
where CP.codeTypeId=Co.codeTypeId and CP.Code=Co.Code
ORDER BY CP.ZfeatureKey

FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
, 1, 1, '') as FeatureName,
stuff(( SELECT '$' + CAST( CP2.FeatureValue AS VARCHAR(300)) AS [text()]
FROM(SELECT distinct P.FeatureValue,C2.codeTypeId,C2.Code,C2.ZfeatureKey FROM gen C2
INNER JOIN PartAttributes P on C2.ZfeatureKey=P.ZfeatureKey)CP2
where CP2.codeTypeId=Co.codeTypeId and CP2.Code=Co.Code
ORDER BY CP2.ZfeatureKey
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
, 1, 1, '') as FeatureValue
FROM
PartAttributes PM
INNER JOIN gen Co ON Co.ZfeatureKey = PM.ZfeatureKey Group By PartID,Code,Co.CodeTypeID,Co.RevisionID,Co.ZPLID

expected result
PartID Code CodeTypeID RevisionID ZPLID ConCount FeatureName FeatureValue
413989 8541100050 849774 307683

so please are this correc
CREATE NONCLUSTERED INDEX IDX_ZPLID
ON ExtractReports.dbo.TPls ( ZPLID)
INCLUDE ( Code, CodeTypeID, RevisionID );

why you say index for all these column
if i put index on zplid column will be correct or muest create on all these columns

when create index on key and value both
as
CREATE INDEX Tradecodessd_idx on Parts.Nop_PartsFamilyAttribute([key],[value])
i get error
Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'Tradecodessd_idx' has maximum length of 4404 bytes. For some combination of large values, the insert/update operation will fail.
Msg 1946, Level 16, State 3, Line 1
Operation failed. The index entry of length 2004 bytes for the index 'Tradecodessd_idx' exceeds the maximum length of 1700 bytes for nonclustered indexes.
The statement has been terminated.

ReplyModify the comment. Delete the comment.
i create index
create index pf_idx on Parts.Nop_PartsFamilyAttribute([Key]) include ([Value])
but nothing affect index seek

i create index
create index pf_idx on Parts.Nop_PartsFamilyAttribute([Key]) include ([Value])
but nothing affect index seek

subquery as below
SET FamilyGroup = STUFF(
(
)

thanks for reply
are statement above write best practice correct

i need regex on sql server get me > and not get <>
as sample below
create table #temp
(
InsertData nvarchar(50)
)
insert into #temp(InsertData)
values
('>10'),
('<> solid data')

how to return first result on insertdata column value >10

so can you show me if possible

I need to get same features name and feature values based on group by fields

only can you show me how to do on cte as feature name and feature value
can you help me please

how to cast this line
IIF(CHARINDEX('~', ZValue)>0, SUBSTRING(ZValue,1,CHARINDEX('~', ZValue)-1),TC.ZValue) AS EStrat,
to varchar(3000) to accept create index

table created by this statment
SELECT TradeCodeControlID ,
VersionYear ,
Version ,
CodeTypeID ,
RevisionID ,
Code ,
ZPLID ,
ZfeatureKey ,
ZfeatureType ,
IIF(CHARINDEX('~', ZValue)>0, SUBSTRING(ZValue,1,CHARINDEX('~', ZValue)-1),TC.ZValue) AS EStrat,
LTRIM(IIF(CHARINDEX('~', ZValue)>0, SUBSTRING(ZValue,CHARINDEX('~', ZValue)+1,LEN(ZValue)),'')) AS EEnd
INTO ExtractReports.dbo.TGen
FROM Parts.TradeCodeControl TC with(nolock)
WHERE TC.ZPLID=@productID

how to case column Estrat to can create index it

so how to reduce it
for what i will reduce

imake select MAX(LEN(EStrat)) from [dbo].[TGen]
it give 2252

so reduce to what
now it is nvarchar(2500)
so make it as what
how much

if i need to generate id for every hash on two table then join by it
are this possible
how to do that please ?

Index on (i.partid,i.partlevel)
Index on(tr.partlevel,tr.zplid)
AND MY ISSUE solved
thank you

if not using while loop
then is good idea
but how to execute sub procedure on sample i attach without using loop
can you show me please

i will use go inside procedure or outside

i mean drop issue when i make drop on first of procedure it must not give me
invalid column name

full structure script dd and query as below
https://www.mycompiler.io/view/3LncvaR

thank you for reply
can you write these statement below by joining using id
without join by url text
are there are any way to do that

update t set t.Revision_ID = r.rec_id
FROM extractreports.dbo.TempROHS t
INNER join Z2urlSystem.zsrc.Local_URL l (NOLOCK) ON t.ZURLSource1 = l.local_url
INNER join Z2urlSystem.zsrc.Online_URL o (NOLOCK) ON t.OnlineSource1 = o.url
INNER join Z2urlSystem.zsrc.Revision r (NOLOCK) ON l.rec_id = r.local_id AND o.Rec_ID = r.online_id
WHERE t.[Status] IS NULL

thank you for reply
can you write these statement below by joining using id
without join by url text
are there are any way to do that

update t set t.Revision_ID = r.rec_id
FROM extractreports.dbo.TempROHS t
INNER join Z2urlSystem.zsrc.Local_URL l (NOLOCK) ON t.ZURLSource1 = l.local_url
INNER join Z2urlSystem.zsrc.Online_URL o (NOLOCK) ON t.OnlineSource1 = o.url
INNER join Z2urlSystem.zsrc.Revision r (NOLOCK) ON l.rec_id = r.local_id AND o.Rec_ID = r.online_id
WHERE t.[Status] IS NULL

so how i do below
You can try indexing your fields that you are joining on. Can you add ids to your tables and join on them instead?

so what i do

so how to make update more faster
i already put on status index but nothing changed
it take 6 hour for 68 k
so if you have any suggestion to do it faster
i attach execution plan above

i found issue do that
SendKeys.Send("{TAB " + TimesToSend + "}");
but problem how to focus first cell on next row without using tab key send

thanks for reply
can i get data from Request.Form.Files[0];
instead of copy to file then get data from copied file

thank you very much
1- first question are using memory stream like below is correct
var memory2 = new MemoryStream();
using (var stream = new FileStream(exportPath, FileMode.Open))
{
stream.CopyTo(memory2);
}
memory2.Position = 0;
2-second question when I have exception file using by another process
so How to solve issue
3- Are using async task wait will have benefit or no need

can you please answer me on this comment
please hel me

ok thank you

i have 14 component on my app
how to know which component that have this issue

ok can you help me
i have 14 component and i don't have any message or error tell me
that issue on these component to solve it
can you tell me how i know that please
it take from me two days and i can't know from what this issue done

ok how to get that please can you tell me how to get that

invoice id is invoice no

and i use this field to store Purchase ID AND sales or consume ID

but my issue How to handle transfer from inventory to another inventory

this is my question

i already do cast so why it display like that

yes but i don't know how to get true or false from api

i try to do like below

PostUpload(selectedoptionsId, file):Observable<response>
{
const formData: FormData = new FormData();
formData.append('file', file,file.name);
formData.append('selectedoptions',selectedoptionsId.toString());
return this.http.post('http://localhost:61265/api/DeliverySys/', formData);
}
error as below

is not assignable to type 'import("e:/TestInternalSystemZ2Data/FullProjectAngApiLastUpdate/Z2DataAngularV1.8/node_modules/rxjs/internal/Observable").Observable<response>'.
Type 'Response' is missing the following properties from type 'Response': redirected, trailer, clone, body, and 2 more.ts(2322)

this is my function
can you help me tell me
how to call it please
without make service and function
thi is below do what i need

this.http.post('http://localhost:61265/api/DeliverySys/', formData,{ responseType: 'blob' })
.subscribe((response: Blob) => saveAs(response, this.fileToUpload.name + '.xlsx'));

PostUpload(selectedoptionsId, file)
{
const formData: FormData = new FormData();
formData.append('file', file,file.name);
formData.append('selectedoptions',selectedoptionsId.toString());
return this.http.post('http://localhost:61265/api/DeliverySys/', formData);
}
i make it as you tell me

PostUpload(selectedoptionsId, file): Observable<blob> {
and it give me error

but why function call above give me error

without doing service and call function
i make that and it working
this.http.post('http://localhost:61265/api/DeliverySys/', formData,{ responseType: 'blob' })
.subscribe((response: Blob) => saveAs(response, this.fileToUpload.name + '.xlsx'));
so please how to call function to give me same result

on service i got this error

Type 'Observable<response>' is not assignable to type 'Observable<blob>'.
Type 'Response' is missing the following properties from type 'Blob': size, slice, streamts(2322)
after i modify function to
PostUpload(selectedoptionsId, file): Observable<blob> {
can you please help me

can any one help me
my issue online below
this._dataService.PostUpload(this.selectedoptions.toString(),this.fileToUpload)
.subscribe((response: Blob) => saveAs(response, this.fileToUpload.name + '.xlsx'));

according to point 1,3 and 4 is ok
but point 2 portion key length how to handle it best practice

1- can you tell me how foreign key will be
2- what i don on length of portionkey
3- how to use cte instead of @GetFinalResult

you are correct it must be int
so are there are any thing other can enhancement

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 possible can you help me applying

are there are any solution without using like

case when after <> or = is string then use Name else using AcceptedValuesOption_Value
so How to do that please

any one can help me please

yes this is good
public IActionResult Upload([FromBody] int selectedOwnerLevel)

and after that how to access value of selectedOwnerLevel
meaning how to get value 1 from key selectedOwnerLevel

thanks but i have two questions
first question how to get value on web api
meaning how to get value of this.selectedOwnerLevel on web api
second question how to add this this.selectedOwnerLevel on form data
i do as below
formData.append('selectedOwnerLevel', this.selectedOwnerLevel);
when make console.log(FormData)
it give me as below
formData.append('file', this.fileToUpload,this.fileToUpload.name);
formData.append('selectedOwnerLevel',this.selectedOwnerLevel.toString());
console.log(formData);
when inspect it come as below
file [object File]
selectedOwnerLevel 1
so How to access value of selectedOwnerLevel
on web api

thank you for reply
i need to pass value of this.selectedOwnerLevel on angular 7
to web api variable selectedOwnerLevel

public IActionResult Upload(int selectedOwnerLevel)
this actually what i need
any information need i can tell you
on angular 7 i
make console.log(this.selectedOwnerLevel)
it give me 1
but on web api value of selectedOwnerLevel is 0
so How to solve this issue please help me
by any way i need to get value of this.selectedOwnerLevel on server web api
so How to do that

System.IO.File.Copy(OutputfilePath, Path.Combine(exportDirectory, fileName), true);
System.Diagnostics.Debug.WriteLine(myValue2)
\\192.168.2.7\ImportExport\testImporter
System.Diagnostics.Debug.WriteLine(exportDirectory)
\\192.168.2.7\ImportExport\testImporter\5
System.Diagnostics.Debug.WriteLine(OutputfilePath)
\\192.168.2.7\ImportExport\testImporter\DeliveryGeneration_Output.xlsx
System.Diagnostics.Debug.WriteLine(Path.Combine(exportDirectory, fileName))
\\192.168.2.7\ImportExport\testImporter\5\orignal-e1f75892-7c35-4533-b2ff-ddc8e9893733.xlsx
System.Diagnostics.Debug.WriteLine(ex)
System.IO.IOException: The target file '\\192.168.2.7\ImportExport\testImporter\5\orignal-e1f75892-7c35-4533-b2ff-ddc8e9893733.xlsx' is a directory, not a file.
at System.IO.FileSystem.CopyFile(String sourceFullPath, String destFullPath, Boolean overwrite)
at System.IO.File.Copy(String sourceFileName, String destFileName, Boolean overwrite)
at Framework.WebApi.Controllers.DeliverySystem.DeliverySysController.Upload()

can we more clear please

both destination and source is files not directory

GetFilesDownload is

\\\\192.168.2.7\\ImportExport\\testImporter
string Month = DateTime.Now.Month.ToString();
string exportDirectory = GetFilesDownload + "\\" + Month;


var OutputfilePath = System.IO.Path.Combine( GetFilesDownload, "DeliveryGeneration_Output.xlsx");

System.IO.File.Copy(OutputfilePath, Path.Combine(exportDirectory, fileName), true);

can you more clear please
destination and source is files and can access it
so why error give me it is directory
the destination and source is file and not directory
it is ended by xlsx excel file
so why error give me it is directory

thank you for reply
what you mean by exact string

as above length 3962 are that related to length or what id o
statment sql not complete

statment not complete
as
following
'Competitor Automotive' as [Competitor Automotive], 'NXP Automotive' as [NXP Automotive], 'Competitor Normalized Package Name' as [Competitor Normalized Package Name], 'NXP Normalized Package Name' as [NXP Normalized Package Name], 'Competitor Accelerometers Type' as [Competitor Accelerometers Type], 'Competitor Amplifier Type' as [Competitor Amplifier Type], 'Competitor Battery Type' as [Competitor Battery Type], 'Competitor Diode Type' as [Competitor Diode Type], 'Competitor Function' as [Competitor Function], 'Competitor Multi-Demultiplexer Circuit' as [Competitor Multi-Demultiplexer Circuit], 'Competitor Multiplexer And Demultiplexer' as [Competitor Multiplexer And Demultiplexer], 'Competitor Output Type' as [Competitor Output Type], 'Competitor Type' as [Competitor Type], 'NXP Accelerometers Type' as [NXP Accelerometers Type], 'NXP Amplifier Type' as [NXP Amplifier Type], 'NXP Battery Type' as [NXP Battery Type], 'NXP Diode Type' as [NXP Diode Type], 'NXP Function' as [NXP Function], 'NXP Multi-Demultiplexer Circuit' as [NXP Multi-Demultiplexer Circuit], 'NXP Multiplexer And Demultiplexer' as [NXP Multiplexer And Demultiplexer], 'NXP Output Type' as [NXP Output Type], 'NXP Type' as [NXP Type], 'Competitor Axis' as [Competitor Axis], 'Competitor Capacitance' as [Competitor Capacitance], 'Competitor Charging Current Type' as [Competitor Charging Current Type], 'Competitor Function' as [Competitor Function], 'Competitor Maximum Reverse Peak Voltage' as [Competitor Maximum Reverse Peak Voltage], 'Competitor Normal Position' as [Competitor Normal Position], 'Competitor Number of Channels' as [Competitor Number of Channels], 'Competitor Number of Circuits' as [Competitor Number of Circuits], 'Competitor Number of Outputs' as [Competitor Number of Outputs], 'Competitor Sensor Type' as [Competitor Sensor Type], 'NXP Axis' as [NXP Axis], 'NXP Capacitance' as [NXP Capacitance], 'NXP Charging Current Type' as [NXP Charging Current Type], 'NXP Function' as [NXP Function], 'NXP Maximum Reverse Peak Voltage' as [NXP Maximum Reverse Peak Voltage], 'NXP Normal Position' as [NXP Normal Position], 'NXP Number of Channels' as [NXP Number of Channels], 'NXP Number of Circuits' as [NXP Number of Circuits], 'NXP Number of Outputs' as [NXP Number of Outputs], 'NXP Sensor Type' as [NXP Sensor Type], 'Competitor Capacitance' as [Competitor Capacitance], 'Competitor Interface' as [Competitor Interface], 'Competitor Interface Type' as [Competitor Interface Type], 'Competitor Maximum Operating Temperature' as [Competitor Maximum Operating Temperature], 'Competitor Maximum Reverse Peak Voltage' as [Competitor Maximum Reverse Peak Voltage], 'Competitor Number of Cells' as [Competitor Number of Cells], 'Competitor Number of Channels' as [Competitor Number of Channels], 'Competitor Number of Inputs' as [Competitor Number of Inputs], 'Competitor Output Configuration' as [Competitor Output Configuration], 'Competitor Output Type' as [Competitor Output Type], 'NXP Capacitance' as [NXP Capacitance], 'NXP Interface' as [NXP Interface], 'NXP Interface Type' as [NXP Interface Type], 'NXP Maximum Operating Temperature' as [NXP Maximum Operating Temperature], 'NXP Maximum Reverse Peak Voltage' as [NXP Maximum Reverse Peak Voltage], 'NXP Number of Cells' as [NXP Number of Cells], 'NXP Number of Channels' as [NXP Number of Channels], 'NXP Number of Inputs' as [NXP Number of Inputs], 'NXP Output Configuration' as [NXP Output Configuration], 'NXP Output Type' as [NXP Output Type], 'Competitor Acceleration Range' as [Competitor Acceleration Range], 'Competitor Capacitance Ratio' as [Competitor Capacitance Ratio], 'Competitor Fault Protection' as [Competitor Fault Protection], 'Competitor Maximum Forward Current' as [Competitor Maximum Forward Current], 'Competitor Maximum Supply Voltage' as [Competitor Maximum Supply Voltage], 'Competitor Number of Inputs' as [Competitor Number of Inputs], 'Competitor Number of Outputs' as [Compet

thank you for reply
can you help me on that
why error incorrect syntax near as display
what i do to solve it

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]

my problem that i have same display order and same columnorderby
so How to solve this issue please ?

i mean 6 on real data
and expected is result will be after remove last two digit

so what I do

thank you for reply
Expected result is :
PartIDC PartIDX
1222 3491
but i get it wrong as
PartIDC PartIDX
2243 2243
when apply answer above
can you help me get correct answer

sorry function exist on
dbo.split function exist on
https://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

dbo.split are built in function

so please what I do

so what I do to enhance performance of that long query

so what I do to do that fast

I need to make result above as SQL function so how to do that .
what I try give me correct result only what i need to do converting code above to SQL function

if possible can you help me by showing code

I got what you mean you mean then when I make return new SQL connection this meaning
this is not static because I take new object my question are connection with this way is good or bad

I read it but I need ask are my work is wrong and if I change my connection above to get query from another server what issue I will solve
please help me

so my question are using connection as I used is correct or what ?

thank you for reply i need to prevent it from display by using filter because totalCount display as last column on table
and i dont need to display it

I modify my original post if any more details i will explain to you

thank you for reply it is not give me correct result
remaining record number 5 and 6
as link
https://www.mediafire.com/view/7vjbonu46astw64/DataSheet.png/file
i do
delete t from #TradeCode t
left join #MappingCodeValue as m
on (t.codetype = m.parentcodetype) and (t.codevalue = m.parentcodevalue)
where m.parentcodetype is null and m.parentcodevalue is null
select * from #TradeCode

TradeCodeId PartId CodeType CodeValue partlevel PartDone
1 1222 ECCS-US AB123-US 0 NULL
2 1255 ECCS-US AB555-US 0 NULL
11 1255 HTS-US AB900-US 0 NULL
12 909 HTS-US AB900-US 0 NULL

OK i understand

thank you very much for help for support
I really get more benefit from that forum so much
and i learn so much .
sometimes i ask questions to get more efficient answer to my questions
OK i understand about what you talk above and i will improve my self
only one question i need answer for it
you confuse because task is trivial or Im not try .
please tell me i lookup to Learn from my wrong to not repeat again ?

I solved my issue
thank you
this is my answer
declare @SeletColumnComma varchar(max)
select @SeletColumnComma = coalesce(@SeletColumnComma + ',','') + coalesce('substring(DoneCode ,' +cast (FunctionId as nvarchar(20)) + ',1) as ' + FunctionName + '','') from #Donecode
select @SeletColumnComma

DECLARE @query nvarchar(max)
SET @query='select ' + @SeletColumnComma + ' from #filedetails'
exec(@query)

I ask this question because i need to access my laravel project from another machine on lan
locally laravel project work
but it not work ovrer lan
can you please tell me what i do to see my app from another pc on my lan
i use ip 192.168.2.37 and i can see that ip from anoter pc
but laravel project cannot see it
although it work locally

which tool need to install and what i do to solve this issue

it is found on this link
https://www.brentozar.com/pastetheplan/?id=Hyss6rlLL

can you see execution plan above

I need to write function with ado.net make same as API above

I need to write function with ado.net make same as above

no i dont need that i need it on angular 7 what i do to receive value of count
my API return number as 100
how to receive on angular 7 and display on component.html

Thanks for reply i ask here only to give me some idea about what i make only and give me public reasons for that

what you mean this line please
also fire the Send Alert method you have yet to write
are this meaning windows notifications or send by email
can you tell me what you mean by line above if possible ?

thank you for reply by email using asp.net core 2.2

OK this i will do and while loop what alternative to it

I Update my script query full so can you help me please if p[ossible
if there are any solution without using while loop

can i write my query above without using while loop solutions

OK and what about select top 5000 exist inside loop
are this OK or have something issue

can any one help me please

my problem in @Columns variables before union all not show dynamic values but after union all it display dynamic values so How to solve this problem

please can you help me to do that on angular 7

but i face problem on this line
FeatureName IN (' + @Columns + ')

can you help me
i need to run as select statement
see How to run that
DECLARE @Columns as VARCHAR(MAX)
SELECT @Columns =
COALESCE(@Columns + ', ','') + QUOTENAME(FeatureName)
FROM
--distinct FT.FeatureName
(select distinct FT.FeatureName from #InputData Feat inner join #ItemFeatures ItemF
on ItemF.CustomerId=Feat.CustomerId INNER join #FeatureType FT on ItemF.FeatureId=FT.FeatureId

) AS B
ORDER BY B.FeatureName

SELECT ItemCode, IPN,PartnerName,CustomerName, ' + @Columns + '
FROM
(
select F.ItemId,F.ItemId as ItemCode,I.IPN,I.PartnerName,I.PartnerPart,c.CustomerName,t.FeatureName from #InputData Itm
inner join #ItemFeatures F on F.CustomerId=Itm.CustomerId
inner join #Items I on I.ItemID=F.ItemId
inner join #FeatureType T on T.FeatureId=F.FeatureId
inner join #customers c on c.CustomerID=F.CustomerID
) as PivotData
PIVOT
(
COUNT(ItemId)
FOR FeatureName IN (' + @Columns + ')
) AS PivotResult
ORDER BY CustomerName

thank you for reply
how to concate number of characters from string
meaning i need to use concate for 150 from string

this is correct or wrong

why AND TCC.codeType IS NULL
i SEE
t.CodeType IS NULL IS enough

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 ?

thank you very much

thank you for reply
statement i write (not in)
give me correct result
but I need using join with where if there are condition
are this possible or not

thanks for help

above it based on partid i need to display based on tradecode
on my case every trade code have group of parts
when trade code on tempsupplier is 15
this meaning i will display all parts that exist on temp parts and not exist on temp trade code
missing i need to get is missing from trade code

I need missing parts on level of tradecode not level of part meaning parts have related parts 1,2,3 then i will search for missing on temp table parts meaning any part different from 1,2,3

i explain more and post final result at end

my wrong on that question is I cannot put points above on google map
so please i need help
I need resume code above to pinpoint these locations above on google map

there is no error display on inspect

can you tell me what final code i modify to get access to value of userPass

console.log("check new" + auth[0]);
it give me
check new[