Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.

Group by

Aggregrating varchar columns

Concatenate columns grouping on Index column (approach for summing varchar columns by grouping on index)

group by

Limit Groups by Number Using Transact-SQL or MS Access

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.

RE: Serach for free drive Space on all my SQL Servers

Sure thing!This is an introduction to some of the most interesting undocumented xp'shttp://www.sql-server-performance.com/ac_extended_stored_procedures.aspBut keep in mind, that mostly they are undocumented for good reasons. So, evaluate carefully if you want to rely on such features in production code.

Data Export/Import Using T-SQL

Hi,I am having a database on Server1, now in my application I need to copy data from few tables residing on Server1 to the database residing on Server2, I can do this usin EM , however I need to do this in a stored procedure, the stucture of the database on both servers is always […]

RE: concurrent queries

Hai,Are you trying to use multiple threads from any front end application. 

RE: Multiple Column Join

As far as I can see, you have solved your own problem: SELECT d.company, d.address1, d.address2, d.city_id, d.state_id, d.country_id, d.zip, dr.directory_roletype_id, x.eng_itemdesc FROM T_MTSTM_DIRECTORY d INNER JOIN T_MTSTM_DIRECTORY_ROLE dr ON d.ID = dr.DIRECTORY_ID JOIN T_MTSTM_XREF x ON x.ID = dr.directory_roletype_id AND x.id = d.city_id AND x.id = d.state_id AND x.id = d.country_id If this is […]

foreign key - index

I understand that an index for foreign key is not automatically created, and must be created manually. Is there a way or command to find out the foreign key that don't have an index?