[ad_1] You should use joins. Your query will look like : SELECT t3.name FROM table3 t3 LEFT JOIN table2 t2 ON t3.id = t2.id2 LEFT JOIN table1 t1 ON t2.id2 = t1.id WHERE t1.id = <your_number> 1 [ad_2] solved SELECT * FROM table1, table2, table3 [duplicate]
[ad_1] As per MSDN those data types are deprecated, not removed. They will be removed in a future version but will still be usable in 2016. So this is just a strong message not to use them in anything new. 1 [ad_2] solved ntext/text/image datatypes in SQL server 2016 CTP 3
[ad_1] This will work in sqlserver 2005: DECLARE @startdate datetime DECLARE @enddate datetime SELECT @startdate=”2015-12-04″, @enddate=”2015-12-07″ ;WITH N(N)AS (SELECT 1 FROM(SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1)M(N)), tally(N)AS(SELECT ROW_NUMBER()OVER(ORDER BY N.N)FROM N,N a,N b,N c,N d,N e,N f) SELECT top (datediff(d, @startdate, @enddate) + 1) dateadd(d, N – … Read more
[ad_1] I’m going to take a stab at this despite there being incomplete information in your post. A chain of just AND operators will require every expression to evaluate true for every row returned. This is as fundamental as gravity. In short, AND works, it just doesn’t work as you expect it to. What is … Read more
[ad_1] This is currently possible. The following code deadlocks itself BEGIN TRAN CREATE TYPE dbo.OptionIDs AS TABLE( OptionID INT PRIMARY KEY ) EXEC (‘DECLARE @OptionIDs dbo.OptionIDs;’) ROLLBACK This is a long standing issue due to the use of internal system transactions when creating the instance of the TVP that can’t access the lock taken by … Read more
[ad_1] You can use a recursive CTE to accomplish this. This only excludes the weekends. Using DATEFIRST you can figure out what day is a weekend. This query should work no matter what day of the week is set to DATEFIRST. ;WITH DatesCTE AS ( SELECT CAST(‘2016-01-01’ AS DATE) AS [workingDays] UNION ALL SELECT DATEADD(DAY, … Read more
[ad_1] Use SUM and GROUP BY. SELECT Empid, SUM([No of Days]) AS Days FROM leavetable GROUP BY Empid Read more here GROUP BY and here SUM. This would give you: Empid Days 100 25 Or if you mean count the amount of times an employee has been off use Count. SELECT Empid, Count(Leaveid) AS LeaveTotal … Read more