souLTower (1/29/2009)

---

Aren't left joins and NOT EXIST statements more efficient than NOT IN statements? I don't know if I made that up or read it somewhere. I usually...

I recommend you do a few things:

- Is it really necessary to join 7 tables all using FULL OUTER JOIN? It's really bad database design if that's the case. Most...

I'm still on 2000, so I'm not into CTE's (yet)... So this would be my solution:SELECT id, [desc], loc, SUM(qty1), SUM(qty2)

FROM (

SELECT T1.id, T1.[desc], T2.loc, T2.qty1, 0 qty2

FROM Table2 T2...

It seems not, however you can change it to something like this:

SELECT COUNT(*)

FROM

(

SELECT col1, col2, col3

FROM table

GROUP BY col1, col2, col3

) X

Hah! A question I could answer with my eyes closed 🙂

This should do it:SELECT a.groupid, b.name, COUNT(a.groupid) AS 'Total #'

FROM subjects a

INNER JOIN Group b ON a.groupid = b.groupid

WHERE subjecttype IN ('member','affiliate') AND a.groupid like '03%'

GROUP BY a.groupid, b.name

HAVING COUNT(a.groupid)...

When you can use Windows authentication, do that. However, applications using the database, are mostly not on the same domain, so that requires using SQL Server authentication. Means you'll end...

Please do not post the same question in 2 different categories, as urgent as it may be...

What you're trying to do is very dangerous, because what would you do with the following numbers:

1: 1,234.45

2: 1.234,45

3: 1234,45

4: 1234.45

The same value in different formats, based what country settings...

When you want to use a variable in a SQL statement, you need to do this a bit different:

CREATE PROCEDURE sp_GetTasks

@colname nvarchar(50),

@colvalue...

Can you provide table description and sample data, so I can play around with it? The article in the link below describes very well how to do this.

I don't know if you know anything about theory and understanding databases commons. I did, and I first learned (well, first dBASE III/IV) Access, then SQL Server. Using all the...

Only strange thing I see in your query is that tm_actvy appears in both as a table name and a column name, is that correct?

Other thing is that you should...

I'm glad to help... For understanding what went wrong, you might check out this article: http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

dvora.id (1/19/2009)

---

Hi,

I created a selective insert query.

When I’m activating the update part the query takes a lot of time more than hour.

I think that I’ll need to insert some index...