So if you just need a list of employees that were hired after King was hired, just use King’s hire date as the filter. select e.*,datediff(dd,e.hiredate,getdate()) min_exp from emp e where e.hiredate > (SELECT hiredate FROM emp WHERE ename=”king”) Test the statement and make adjustments where needed. I didn’t verify it.
Include @rate as an output parameter in the procedure and the code should be fine
Something like.. ORDER BY CASE WHEN ISDATE(DateTime) = 1 THEN CASE DateTime WHEN <= ‘2016-03-01’ THEN 1 — Preseason WHEN >= ‘2016-03-31’ THEN 3 — PostSeason ELSE 2 END — Season ELSE 4 END, — Not a date, figure out how to handle DateTime
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();
declare @Colcunt int; Select @Colcunt = count(*) from tbl_Calibration_Transaction where CardId = @CardId and ScalingMachine= @ScalingMachine IF (@Colcunt = 0 ) BEGIN INSERT INTO tbl_Calibration_Transaction …
You seem to want aggregation: select disport, actualagent, . . . , country, sum(pallats), sum(gross) from t group by disport, actualagent, . . ., country; You need to list all the columns where the . . . is.
Yet another option. Not sure if I agree with the last record of the desired results. I have 2019-01-07 while you have 2019-01-08 Example or dbFiddle Select A.[Name] ,[Begin_Date] = convert(datetime,left(dateadd(DAY,N ,[Begin_date]),10)+’ ‘+BegTime) ,[End_Date] = convert(datetime,left(dateadd(DAY,N+NxtDay,[Begin_date]),10)+’ ‘+EndTime) From YourTable A Cross Apply ( values ( left(replicate(Schedule,10),datediff(DAY,Begin_Date,End_Date)) ) )B(S) Cross Apply ( Select N=N-1 ,Subs=substring(B.S,N,1) From … Read more
The problem with your original query is you are asking to return results where the PermissionId is equal to two values at the same time – meaning the same row – this is impossible. However you can get return the UserID that has both PermissionId =5 AND PermissionId =7 by using a GROUP BY with … Read more
How about this one? (Because you posted minimal info, I reserve the right to create my own DDL as I interpret). IF OBJECT_ID (‘tempdb..#’) IS NOT NULL DROP TABLE #sales GO CREATE TABLE #sales (Dte datetime ,amt int ,id int ,rownum int identity PRIMARY KEY ) INSERT INTO #sales SELECT ‘9/1/17’,1200, 987 INSERT INTO #sales … Read more
A Cartesian join (note there is no JOIN condition). All possible combinations of records are in the results: tableA (charfield Char(2)) tableB (numberfield Number(1)) INSERT ‘A’ INTO tableA; INSERT ‘B’ INTO tableA; INSERT 1 INTO tableB; INSERT 2 INTO tableB; SELECT * FROM tablea CROSS JOIN tableb Results: charfield|numberfield ===================== A |1 A |2 B … Read more