Skip

6 posts tagged with sql by DakotaPaul.
Displaying 1 through 6 of 6.

Finding rows that don't exist in an SQL Server 2005 table

I can't seem to build a query in SQL Server 2005 that returns rows that are not in a table. [more inside]
posted by DakotaPaul on Oct 7, 2009 - 17 answers

How does WITH work in MS SQL Server?

Can someone help me understand how the WITH common table expression works in Microsoft SQL Server? [more inside]
posted by DakotaPaul on Sep 11, 2009 - 9 answers

Replacing multiple spaces in a string using T-SQL

Please help me find the T-SQL that removes duplicate spaces within a string (or suggest your own method). [more inside]
posted by DakotaPaul on Dec 17, 2008 - 2 answers

How do I get the record with the most current date by a key field?

SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside. [more inside]
posted by DakotaPaul on Nov 21, 2006 - 14 answers

How do I get totals in a pivot table in SQL?

I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students? [more inside]
posted by DakotaPaul on Mar 17, 2006 - 6 answers

Any recommendations for SQL training in Lodi, California?

Any recommendations for SQL training in Lodi, California? [more inside]
posted by DakotaPaul on Oct 10, 2005 - 1 answer

Page: 1
Posts