Try following if your implementation is in SQL Server. SELECT tblgrade.fld1stGrade +’A’ FROM tblgrade WHERE CAST(tblgrade.fld1stGrade as int) >= 90 and cast(tblgrade.fld1stGrade as int) <= 99; For MySQL implementation use following. select concat(tblgrade.fld1stGrade, ‘A’) from tblgrade where tblgrade.fld1stGrade >= 90 and tblgrade.fld1stGrade <= 99; For multiple category comparison in MySQL, use something like below. select … Read more
An union is a mathematical operation between sets. This kind of operations requires the two tables to be COMPATIBLE, which means that they have to have the same columns in number and types. And it’s clearly obvious that you’re trying to make an union between a 3 columns SELECT and 1 column SELECT statements (the … Read more
I am trying to create a sql table in phpmyadmin, I’m getting 4 errors. This code works in phpmyadmin on my pc at my work but not on the pc at home [closed] solved I am trying to create a sql table in phpmyadmin, I’m getting 4 errors. This code works in phpmyadmin on my … Read more
Include a flag column in the user table to indicate the user’s status, then build views on top of this against which you run your actual queries. Maybe something like this: create table users ( …. is_active boolean not null ); create view active_users as select * from users where is_active = true; create view … Read more
You can use inner join to get price for each product in orders table: Select o.customer_id, p.product_id, o.quantity, p.price from PRICES p inner join ORDERS o on p.product_id=o.product_id solved How to join each order with its price? [closed]
Is this what you are looking for? SELECT EIID FROM UserTable AS t WHERE strings=”PDSCLm” AND NOT EXISTS ( SELECT 1 FROM UserTable AS t2 WHERE t.EIID = t2.EEID AND t2.strings IN (‘JPNaOn’, ‘PDSCLs’) ); 0 solved How to find particular string value for the particular group ID in a table? [closed]
Collect your error messages, if you get none return the result of your query, else return or raise the collected errormessages. Declare @a Table (a int,b int,c int) insert into @a Values(1,2,3),(4,4,4) Declare @va int=2 Declare @vb int=2 Declare @vc int=2 Declare @error Varchar(100)=” if not exists(select * from @a where a=@va) Select @Error=@Error + … Read more
What exactly you want to count? Only consumed? Or consumed by goal? If the second option, you need group by statment. SELECT count(consumed) as count FROM (some select) alias Or SELECT count(consumed) as count, goal FROM (some select) alias Group by goal solved COUNT and GROUP BY doesn’t works as expected [closed]
create the UFN_STRING_SPLIT function suggested by @Dave here link create FUNCTION [dbo].[UFN_STRING_SPLIT] ( @List NVARCHAR(MAX), @Delimiter NVARCHAR(255) ) RETURNS TABLE WITH SCHEMABINDING AS RETURN ( SELECT Item = y.i.value(‘(./text())[1]’, ‘nvarchar(max)’) FROM ( SELECT x = CONVERT(XML, ‘<i>’ + REPLACE(@List, @Delimiter, ‘</i><i>’) + ‘</i>’).query(‘.’) ) AS a CROSS APPLY x.nodes(‘i’) AS y(i) ); test your code: … Read more
You can make use of Pivot function in SQL server: Demo SELECT * FROM TABLE1 PIVOT(MIN(QTY) FOR [YEAR] IN ([2017], [2018], [2019], [2020])) PIVOT_TABLE; solved Pivot Data on A SQL WITH Query
The simplest solution, since you already have working C# code, is to create a Console Application, and use your existing code in the Main() method. Compile it into an EXE, and place the EXE somewhere on the computer where the code must run. Use Windows Task Scheduler to schedule your EXE to run as needed. … Read more
From a 10,000 ft view: a string comparison is being done between each Reach Report values, and the results of each comparison are used to order the 4 rows (ORDER BY [Reach Report] DESC). REACH 2012-13 REACH 2011-12 REACH 2010-11 REACH 2009-10 Then, the first one is chosen and returned (SELECT TOP 1 [Reach Report]). … Read more
have you tried the = operator and removing the % wild cards? 1 solved What’s the correct sql command to find exact matches?
all what i had to do is add this: ‘ into ##myTempTable DECLARE @DynamicPivotQuery AS NVARCHAR(MAX) DECLARE @ColumnName AS NVARCHAR(MAX) –Get distinct values of the PIVOT Column SELECT @ColumnName = ISNULL(@ColumnName + ‘,’,”) + QUOTENAME([month]) FROM (SELECT DISTINCT [Month] FROM MyTable) AS [Month] order by [month] –Prepare the PIVOT query using the dynamic SET @DynamicPivotQuery … Read more
It looks like you are trying to build a string. For that you can use snprintf. char sql[64]; int size = snprintf(sql, 64, “SELECT %lf/(%lf * %lf);”, peso, altura, altura); Note that I kept the return value. This is to handle any future error where you modify a statement in a way that might result … Read more