Odd question, odd answer : Obsolescence By the way, if you wish to ask for support for unsupported solutions good luck. Here is the official Microsoft post on SQL Server versions supported. Another reason, is the inter-compatibility between application versions and maintenance cost. By the way, updating products allow flaws to be fixed, security flaws … Read more
There is a workaround for indexed views with ’emulated outer joins’. However, it’s hideous and I wouldn’t advocate it. A better solution would be to index the underlying tables and skip the whole view. Or create two indexed views and do the outer join in the query calling the views. Yet another solution is to … Read more
This should work: SELECT cast(COALESCE(sum([ColumnA]), 0) as DECIMAL(18,0)) AS [Weight] FROM [DB1].[dbo].[Tabel1] 0 solved How to handle NULL’s to show 0 in T-SQL query
You almost for sure will need a sub query to achieve this one way or another. select movie.title, actor.name from movie inner join casting on movie.id = casting.movieid and casting.ord = 1 –Assuming this is the cast order flag inner join actor on casting.actorid = actor.id where movie.id in ( select movie.id from movie inner … Read more
Try Group by.. Having clause with MAX() to find out players name who never scored century SELECT NAME FROM table GROUP BY NAME HAVING MAX(SCORE) < 100; 4 solved how to retrieve player names who never scored a century?
An inner join should do it. Here’s the syntax, but you’ll have to apply it to your database: SELECT c.name, o.name FROM cats c INNER JOIN owners o ON c.owner_id = o.id “cats c” basically means “Cats table, which I’m nicknaming c.” “owners o” basically means “Owners table, which I’m nicknaming o.” In your select, … Read more
. It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs solved . It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs
Based on my partial understanding of your question, I think this might be what you are looking for: DELETE t FROM SQL_TABLE t INNER JOIN ( SELECT max(time1) time1 ,country ,STATE FROM sql_table GROUP BY country ,STATE ) q1 ON q1.country = t.country AND q1.[State] = t.[state] and q1.time1 = t.Time1 WHERE q1.time1 > t.time2 … Read more
If your filed is a Date or DateTime, I would use the function DATEPART. For example, this gets the current year: DATEPART(year, GETDATE()) View the msdn page for the full documentation. If your field is text, use CONVERT to convert your field to a DATE, then use the first method with the converted date as … Read more
You can use group by and having: select name from t group by name having count(*) = (select count(distinct type) from t); This assumes that the name/type rows are not repeated in the table. Edit: If you just want to check for A/B/C, then: select name from t where type in (‘A’, ‘B’, ‘C’) group … Read more
You can easily calculate the % difference using lag() select name, date, number, Cast(((number * 1.0) – Lag(number,1) over(partition by name order by date))/ Lag(number,1) over(partition by name order by date) * 100 as int) from table solved Group by and calculation from value on the next row
Has nothing to do with recursion. Basically you can get what you want with UNION SELECT ProdId as MarkerId, ProdName as MarkerName, NULL as MarkerParentId from t1 UNION ALL SELECT OrdId as MarkerId, OrdName as MarkerName, ProdId MarkerParentId from t2 ORDER BY MarkerId, MarkerParentId 3 solved Create hierarchical data from 2 tables
Anyways I managed to figure out the solution. I executed the query and saved it in a Dataset. Read all the results from dataset and saved the result comma separated in a string. When the user clicks the button the query will be executed and they will be prompted to save the output. String str; … Read more
look at this query. it’s just for demonstration, DECLARE @YEAR INT SET @YEAR = (SELECT YEAR(GETDATE())) DECLARE @MONTH INT SET @MONTH = (SELECT MONTH(GETDATE())) DECLARE @DT TABLE(ID INT, MONTHNAME NVARCHAR(20)) INSERT INTO @DT SELECT NUMBER AS ID, DATENAME(MONTH, CAST(@YEAR*100+NUMBER AS VARCHAR) + ’01’) AS MONTHNAME FROM MASTER.DBO.SPT_VALUES WHERE TYPE = ‘P’ AND NUMBER BETWEEN @MONTH … Read more
SQL Server Management Studio includes the following general features: Supports most administrative tasks for SQL Server. A single, integrated environment for SQL Server Database Engine management and authoring. Dialogs for managing objects in the SQL Server Database Engine, Analysis Services, and Reporting Services, that allows you to execute your actions immediately, send them to a … Read more