Always start simple:

SELECT *

FROM Car

WHERE Price IN (@Price1,@price2,@price3)

AND Manufacture IN (@Manufacture1,@Manufacture2,@Manufacture3)

AND Model IN (@Model1,@Model2,@Model3)

AND City IN (@City1,@City2,@City3)

Did you look at the execution plans to see if the hash...

Your query filters out a very small number of rows from the table - you may as well scan them all from an index ordered by , which should give...

Using Eirikur's data set, here's a different way:

;WITH MyOriginalQuery AS ( -- a query which contains related records of payments made grouped by month and year

SELECT PAYMENT_ID, MEMBER_ID, [Year] =...

95% of the cost of the query is a key lookup of table2. The query...

Miller (4/14/2014)

---

How about this? I'd be curious to see results of performance testing with this.

CREATE FUNCTION [dbo].[BetterSplit]

(

@L NVARCHAR(MAX)

,@D NVARCHAR(100)

)

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

WITH

--A,B,C,D used to generate large number of rows...

bryan van ritter (4/12/2014)

---

i want to build a procedure which loops through table one

and print for each record a insert statement so i can insert the records into table two....

Miller (4/13/2014)

---

I made a few improvements: handles space delimiters now. Also added DISTINCT so you can use in JOINS

CREATE FUNCTION [dbo].[BetterSplit]

(@L NVARCHAR(MAX),@D NVARCHAR(100))

RETURNS TABLE AS RETURN

WITH A(N)AS(SELECT 1UNION ALL SELECT...

SELECT

[Open] = SUM(CASE WHEN DocStatus = 'Active' THEN 1 ELSE 0 END),

[Closed] = SUM(CASE WHEN DocStatus = 'Retired' THEN 1 ELSE 0 END)

FROM Document

CROSS APPLY (

SELECT

CurrentDateFiscalYear =...

Better to use an explicit conversion of string-date to actual date, than hope that local settings will accidentally give you the result you want with an implicit conversion.

CONVERT(DATE,po_date,101)

What do...

declare @todate as date = '01/04/2012'

Is this meant to be April 1st or January 4th?

Why do you prepare two date variables, then use literals in your query?

BWFC (4/11/2014)

---

Thanks Chris. I got my date formats well and truly mixed up there! I'd put date in as the target but because I mis-read the styles it...

aar.mba (4/11/2014)

---

Hi thanks for ur reply.

I tried somewhat like this.

SELECT LOCATION,SUM(SHIPQTY) LATE_QTY ,PO_DATE FROM mytable WHERE DROP_DATE_STATUS = 'LATE'

AND SUBSTRING(CAST(PO_DATE AS VARCHAR(11)),1,2) + '/' + SUBSTRING(CAST(PO_DATE AS...

Couple of errors in there, BWFC:

DECLARE @FromDate DATE = '2012-01-19'

DECLARE @ToDate DATE = '2012-02-23'

-- CONVERT po_date to DATE for the comparison,

-- using the correct STYLE argument for mm/yy/dddd

SELECT...