Since you have multiple tables using the same exclusion data set i would create a work table with that data set and index it, then use a LEFT JOIN tbl...

thats what i mean by sub query.

However how many rows are in the logging table and what indexes there are will affect this a lot. Also is End_Time a...

it should.

How many rows are in [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL]?

Your sub query could be causing the issue if there are only 133k rows in [CHARACTER_01_DBF].[dbo].SKILLINFLUENCE_TBL and its taking hours.

if the...

insanityflyff (2/27/2013)

---

133.723 rows total and i wanna keep 77.646

i wanna delete the custom amount according to the query u see above but i tried to run a count for the...

What percentage of the rows are you keeping and how many rows are there in the tables?

At some point its easier just to loop a delete statement depending on how...

Can you post the DDL for the tables and a couple of sample rows and what you would like inserted into the logging table?

This information will help when writing the...

foxxo (2/6/2013)

---

You need a tab delimited file for excel to recognise it and the file extension needs to be .csv (.xls will work but will display an error first).

eg.

DECLARE @query_result_separator...

Eugene Elutin (1/28/2013)

---

purushottam2 (1/28/2013)

---

Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have 10...

dwain.c (1/27/2013)

---

I think you need a calendar table to do this:

CREATE TABLE #Guests (checkin date, checkout date, FullName varchar(50))

INSERT INTO #Guests

SELECT '10/12/2012', '10/16/2012', 'Corky Doe' UNION ALL

SELECT '12/12/2012', '12/17/2012', 'Janice...

Cursors VS Loops...

Did you add a clustered index or resolve it in some way or do you now need...

Is there a clustered index...

Personally i would rather "Store" the null value than "N/A" as i can save space and if its a numeric field dont have to make any thing special. I...

this is my thoughts as well. when we deal with a table that has a trigger...

CELKO (12/12/2012)

---

That is not how the relational model works. A table is a set whose attributes are fully known at schema creation time. Elephants do not fall out of the...