thomasrichardson2000 (10/11/2012)

---

RepairSheetNrunitnrgroupidbrandIdmodelIdversionType_Fleetclose_dateTotalModels

500000384EDMNFIATGRANDE PUNTO 1.28V DYNAMIC 5DROF 2012-07-31 00:00:00.0001

Sorry the query ran fine, it just returned the exact same result set as the...

thomasrichardson2000 (10/11/2012)

---

Didn't work just pulled back the same result set, I need the query to be able to search the vehicle table for all the modelid on the fleet at...

-- sample data

;WITH

MySample (ID, notes, account1, account2, account3, account4, account5) AS (

SELECT 1, 'notes', 1, 0, 1, 0, 1 UNION ALL

SELECT 2, 'notes', 0, 1, 0, 1, 0...

An inline table-valued function can perform equally as well as a join to tables. If the function has BEGIN/END in it,...

Do you get different results with/without the DISTINCT?

Here's a reformatted copy of the query. I've added table aliases to make it a little more readable and changed the order of...

Skanda (10/11/2012)

---

Am using below query, but it is not working.

select record_id,

if Col1= 'Student'

Begin

Insert record_id, Student as Stud into new_table

end

else if Col2 = 'Student'

Begin

Insert record_id, Student as Stud into new_table

end

else...

What's the UPDATE statement you are using, and is there any reason why it can't include VLoadnoteCarr?

Can you make ParentID a non-unique clustered index? It will almost certainly improve performance. Might as well remove the TOP 100 PERCENT too, it's only pretending to do something.

What denotes "existing record"? How do you identify it?

Why don't you use UPDATE instead of...

Skanda (10/11/2012)

---

Hi

i want to delete existing records from sql table, after inserting new record.

am using below code...

CREATE trigger Del_records on Active_Table

AFTER insert

as

delete from Active_Table

but it is deleting all records

plz...

Folks here would be happy to help you tune your query. Can you...

Jason-299789 (10/11/2012)

---

...as you're getting rid of a potentially expensive IN statement and using an Inner join from a CTE, the variable is no longer on the join and in the...

The filter is being applied locally. You could use EXEC with dynamic SQL as Chandan suggests; I'd personally use OPENQUERY, which will also require your statement to be constructed as...

aadharjoshi (10/10/2012)

---

What OPTION (RECOMPILE, QUERYTRACEON 8649) will do when i add it to query?

eg..

SELECT COUNT(T.CompanyID),

COUNT(UserDataID)

FROM...

RECOMPILE

QUERYTRACEON 8649

If you suspect you are experiencing performance problems with one or more of your queries,...