sql-server Archives - Page 4 of 39

USE AdventureWorks2008R2; GO SELECT SalesOrderID, ProductID, OrderQty ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg' ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server Restore Error – Access is Denied

I created a database on my local machine and then did a backup called tables.bak of table DataLabTables. I moved that backup to ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Multi-statement Table Valued Function vs Inline Table Valued Function

A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE AS RETURN SELECT a.SaleId, a.CustomerID, b.Qty FROM Sales.Sales ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL WHERE.. IN clause multiple columns

I need to implement the following query in SQL Server: select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

OPTION (RECOMPILE) is Always Faster; Why?

I encountered an odd situation where appending OPTION (RECOMPILE) to my query causes it to run in half a second, while omitting it ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

How to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field? [duplicate]

This question already has answers here: How to concatenate text from multiple rows into a single text string in SQL Server (47 answers) ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Keeping it simple and how to do multiple CTE in a query

I have this simple T-SQL query, it emits a bunch of columns from a table and also joins information from other related tables. ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Sql Server string to date conversion

I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, I would ...

May 30, 2022
0 Comments