Cannot Connect to Server – A network-related or instance-specific error
Cannot Connect to Server – A network-related or instance-specific error
sql-server
How can I remove duplicate rows?
How can I remove duplicate rows?
How can you represent inheritance in a database?
@Bill Karwin describes three inheritance models in his SQL Antipatterns book, when proposing solutions to the SQL Entity-Attribute-Value antipattern. This is a brief overview: Single Table Inheritance (aka Table Per Hierarchy Inheritance): Using a single table as in your first option is probably the simplest design. As you mentioned, many attributes that are subtype-specific will … Read more
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
As per the documentation: FROM (Transact-SQL): <join_type> ::= [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ <join_hint> ] ] JOIN The keyword OUTER is marked as optional (enclosed in square brackets). In this specific case, whether you specify OUTER or not makes no difference. Note … Read more
hide/remove header and footer
For each element in your header or footer, whether it be an image or a text box or anything else, right click on each item and select the ‘properties’ option at the bottom of the menu. Then select the ‘visibility’ tab and change from ‘show’ to ‘show or hide based on an expression’. Click the … Read more
find 2nd highest salary in sql [closed]
Use this query SELECT MIN(s.Payment), e.EmpName, e.EmpID FROM dbo.Employee e INNER JOIN Salary s ON e.EmpID = s.EmpID WHERE e.EmpID IN (SELECT TOP 2 EmpID FROM dbo.Salary ORDER BY Payment DESC)
Subquery in select not working in SQL Server
The subqueries you are using in your select statement should return single value for your query to run without error. The following query will run without any issue, but it won’t give you the result you are expecting. SELECT TOP 10 (SELECT g_name FROM vgsales$ x WHERE g_platform = ‘X360’ AND a.g_rank = x.g_rank) AS … Read more
SQL server query to output the data shown below
You can create a statement using T-SQL built-in functions that is returning your desire result but it: will be complex will become even more complex when your conditions are changed So, it will be difficult for you to change it and support it. For me, such tasks can be handled more appropriately using regular expressions. … Read more
How to handle this scenario in single SSIS package?
This will help. how-to-read-data-from-an-excel-file-starting-from-the-nth-row-with-sql-server-integration-services Copying the solution here in case the link is unavailable Solution 1 – Using the OpenRowset Function Solution 2 – Query Excel Sheet Solution 3 – Google It Google it, The information above is from the first search result
Compare the values of column in SQL Server
Just select the needed columns: SELECT A, B FROM Table_1 WHERE B IN (2,3,4) EDIT: If you need them only if all params are present SELECT A, B FROM Table_1 WHERE A IN (SELECT A FROM Table_1 WHERE B = 2) AND A IN (SELECT A FROM Table_1 WHERE B = 3) AND A IN … Read more