Search results for query: *

I work with SQL Server 2019 on server I face issue when I try to read an Excel file from shared path using python 3.10. SQL Server exists on server 7.7 and files exist on another server on Active Directory domain 7.9. When I execute reading to Excel file on local server, it is working from...

I work on sql server 2019 i have table have 20 milion rows . i need to export data Exist on table to only one file by using sql server 2019 . so what best tool and faster tool can help me to extract 20 milions rows from sql server to csv file (only one file ) and on same time is good for...

I work on sql server 2019 . i can't write query below with stuff for xml . so how to change STRING_AGG to stuff xml ? query below take too much time so i need to try with stuff for xml to reduce time cost . query i try it select a.RecomendationId, cast(STRING_AGG(cast(f1.FeatureValue...

I work on sql server 2019 i face issue i can't reduce high cost of sort it reach to 86 percent so How to reduce it please additionally it take too much time to execute it . it take 6:06 minutes execution plan as below : Link statment that make issue select...

I work on sql server 2019 i can't make pivot for feature values based on feature name . i need to apply pivot dynamically because may be tomorrow add new features so it will depend on features on table . for original part id i have 4 features as...

I work on csharp i get error object reference not set to an instance of an object code give me error Error object reference not set to an instance of an object: var Data = result.items.Select(e => new { PartID = e.create._id, IsUpdated = e.create.error != null && e.create.error.reason !=null...

I work on sql server 2019 i face issue i can't get part number that have partstring from table chemical based on chemicalid so i get chemicalid from table chemicalParts when part number match part string star refere to variable number of charachters meaning may be 1or 2 or 3 ,etc until 9 or...

I working on script running on sql server 2019 using python 3.10 . I have directory path \\192.168.7.9\Import\8 and can write and read to files and delete and create files on this directory path \\192.168.7.9\Import\8. my issue when run script python on sql server 2019 it return false but...

I need to append data to excel file already exist from table students on SQL Server . So I need to append data when dbo.fn_FileExists(@FullFilePath)=1 Excel file already Created on D:\ExportExcel\dbo.students.xlsx with student IDs 1 and 2. student table with old data StudentId Name 1...

I work on csharp I have two arrays of string A1 = [Watermelon, Apple, Mango, Guava, Banana] A2 = [Orange, Kiwi, Apple, Watermelon] i need to write code by csharp get difference between two arrays and display difference between two arrays but without using linq or set operator expected result...

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 work on sql server 2019 i have table #parts have group of numbers on Part Value Field . my issue how to give unique number to every group of numbers on Part Value Field if group numbers on part Value not exist before on table then it will take new number. if group numbers on part Value...

I work on sql server 2017 I have table #partsfeature already exist as below create table #partsfeature ( PartId int, FeatureName varchar(300), FeatureValue varchar(300), TechnologyId int ) insert into #partsfeature(PartId,FeatureName,FeatureValue,TechnologyId) values...

I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist and keep header wihout change after export. header of excel file StudentExport.xlsx before export data to it as below StudentId,StudentName after run...

I work on sql server 2014 i face issue i can't make select statment get Partid from last month until current month march (3) . based on last date exist per partid and on same time if there are any gaps between dates then fill it based on last date so if I found partid with last date...

How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1 as example below I have two rows have Flag Allow=1 family 90AM will be family 90 and family unit AM on two column...

I work on c# desktop app I Can't export data to excel file with multiple tab(multi sheet). only that i can do create excel file with only sheet based on data exist on data table module field. I use open XML library Data table data as below : Divide Output Excel File To Multi Tab based On...

I work on SQL server 2012 I have temp table get data from excel and based on data exist on excel i insert on table inside loop temp table always have big amount of data may be at least 5000 or 10000 or 15000 or more I need every iteration increased by 5000 rows insert from temp table so...

problem How to make row that have different value with color red font to full row ? I have html dynamic table not static meaning i dont know how many rows or column inside table because it changed based on data show from back end . I need to give color red to row have distinct value...

I doing contact system web application using c sharp asp.net using library mail kit the problem is when some one reply to my email from outlook 2010 to any email I sent it then on my web application reply id on debug show null when receiving . so How any email server like google,Microsoft...