var query = ( from v in dbContext.UnitFeatureValue join u in dbContext.Unit on v.FK_Unit_ID equals u.ID join t in dbContext.FeatureTitle on v.FK_FeatureTitle_ID equals t.ID where v.FK_Unit_ID == 15 && t.canMoreSelect == 1 select new { v.FK_Unit_ID, u.unitNumber, u.unitTitle, t.featureTitleName, }).Distinct(); 3 solved Convert this sql command to c# linq
Introduction This article will provide a step-by-step guide on how to convert a SQL command to a C# LINQ query. LINQ (Language Integrated Query) is a powerful query language that allows developers to write queries in a more concise and expressive way. It is a great way to simplify complex SQL queries and make them … Read more
You can use concat as SELECT Source, QtyPrevious, QtyToday, ProductPrevious, ProductToday, AvaDatePr, AvaDateToday, Clusters, CONCAT(X, ”, Y) as Z from your_table_name; solved How to concatenate two different values from two different columns with comma ” , ” using TSQL?
You can use FLOOR function to do this. It will round up your numbers, so you can pick only this that are not integers. create table #t (i decimal(12,6)) insert into #t values (1), (1.1) select * from #t where FLOOR(i) <> i solved Show data where the value is after the decimal point
Move the CA_AN subquery to a Cross Apply and check the is not null on the where clause SELECT REGION = et_region, [STORE CODE] = e.et_etablissement, [STORE NAME] = et_libelle, CA = CONVERT(DECIMAL(15,2),SUM(gl_totalttcdev)), NBRTICKETS = CONVERT(DECIMAL(15,0),COUNT(distinct(GL_NUMERO))), NBRARTICLES = CONVERT(DECIMAL(15,0),SUM(GL_QTEFACT)), UPT = CONVERT(DECIMAL(15,2),SUM(GL_QTEFACT)/COUNT(DISTINCT(GL_NUMERO))) , PM = CONVERT(DECIMAL(15,2),SUM(gl_totalttcdev)/COUNT(DISTINCT(GL_NUMERO))), CA_AN = MAX(CA_AN.caan) FROM piece LEFT JOIN ligne ON … Read more
You need cross join : select t1.*, t2.category from table1 t1 cross join (select distinct category from table2) t2; However if you don’t have duplicate then you can directly express it as : select * from table1 t1 cross join table2 t2; 3 solved SQL Server Temp Table Insert from other temp table [closed]
In Oracle, you have to use dynamic SQL as you can’t execute DDL in PL/SQL as is. Why PL/SQL? Because IF-THEN-ELSE is PL/SQL, not SQL. Presuming this is part of your PL/SQL procedure, you’d then if col_length(‘EMP_NUM’, ‘EMPLOYEE’) is not null then execute immediate ‘alter table employee modify emp_num not null’; end if; That’s for … Read more
Please try this one it will give output as yours. Create table #Table (rowNo int identity(1,1), ID varchar(100)) insert into #Table values(‘32132’) insert into #Table values(‘32132,32132’) insert into #Table values(‘32132,32132,6456,654,645’) declare @TableRow int = (select count(*) from #Table),@Tableloop int = 1 while(@Tableloop <= @TableRow) begin Declare @var varchar(100) ; SET @var = (select ID from … Read more
You need just this: SELECT @list = seg_tag + ’01’ + RIGHT(‘0′ + CAST(LEN(ID_Type) AS varchar), 2) + ID_Type + ’02’ + RIGHT(‘0′ + CAST(LEN(IDNumber) AS varchar), 2) + IDNumber FROM #TEMP_TABLE_ID Or SELECT @list = seg_tag + ’01’ + CASE WHEN LEN(ID_Type) < 10 THEN ‘0’ ELSE ” END + + CAST(LEN(ID_Type) AS varchar) … Read more
Your sample data was ambiguous and misleading. If you really just want to order by whatever column isn’t ”, and given your assurance that no columns are NULL and there are no ‘ ‘ etc., you can use CONCAT, which will simply munge whatever value is not empty with two empty strings: SELECT FirstName, LastName, … Read more
Reserved words usually only cause problems if you’re using them as field names, and in that case you need to wrap them with brackets (“[]”) to eliminate the problem. I will amost guarantee you that your PlateState has some garbage in it, so you need to either trim it first (LTRIM(RTRIM(PlateState)) = ‘IN’) or use … Read more
With 2 courses you are always going to get 2 rows when joining like this. It will give you the minimum date value for each course. The first way you can get a single row is to use TOP 1 in your query, which will simply give you the course with the earliest test date. … Read more
CASE is an expression that returns a single expression/value. You need to write one CASE statement per column: ORDER BY CASE WHEN @cOrderBy = ‘USER_FNM_USER_LNM ASC’ THEN USER_LNM END ASC, CASE WHEN @cOrderBy = ‘USER_FNM_USER_LNM DESC’ THEN USER_LNM END DESC, CASE WHEN @cOrderBy IS NULL THEN USER_KEY END ASC, CASE WHEN @cOrderBy = ‘USER_FNM_USER_LNM ASC’ … Read more
The security flaw would — conceivably — arise if user input is put directly into the table without validation and users are limited to what they can see. That is, if ‘%’ could allow someone to see data they shouldn’t. However, using a column name for the like pattern is not a SQL injection risk, … Read more
Something like: DECLARE @artSales TABLE (artid int, dt date, price money); INSERT @artSales VALUES (1, ‘20170102’, 10), (1, ‘20170108’, 10), (1, ‘20170112’, 8.50), (1, ‘20170115’, 8.50), (2, ‘20170102’, 20), (2, ‘20170109’, 20), (2, ‘20170112’, 35), (2, ‘20170116’, 40), (3, ‘20170101’, 500), (3, ‘20170111’, 500), (3, ‘20170130’, 500); SELECT artid, dt, oldPrice = price, PriceChange = … Read more