Have a look here

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Not sure how well this will perform, but should give correct results

WITH CTE AS (

SELECT log_ticket,

ROW_NUMBER() OVER(PARTITION BY log_ticket ORDER BY log_event) -

...

bhavster27 (7/14/2009)

---

Mark (7/14/2009)

---

Try changing

SELECT R.nref.value('@ExpressionRef', 'INT') AS ExpressionRef,

R.nref.value('@ErrorResult', 'VARCHAR(50)')...

Try changing

SELECT R.nref.value('@ExpressionRef', 'INT') AS ExpressionRef,

R.nref.value('@ErrorResult', 'VARCHAR(50)') AS ErrorResult,

...

Use FOR XML PATH

SELECT Name AS "@SubscriptionName",

DeliveryMethod AS "@DeliveryMethod",

(SELECT

...

Lamprey13 (7/10/2009)

---

Nice article. I've used other commercial geo-location products in the past and it is nice to have a free solution that is able to get reasonable results for BI...

Something like this then

WITH CTE AS (

SELECT pa_contactidname,asmemberof,ballotcommitteename,

ROW_NUMBER() OVER(PARTITION BY pa_contactidname,asmemberof ORDER BY ballotcommitteename) AS rn

FROM user_table)

SELECT pa_contactidname,asmemberof,

...

Try changing

a.ballotcommitteename b. ballotcommitteename

to

a.ballotcommitteename < b. ballotcommitteename

Possible issues with Google Chrome?

http://www.sqlservercentral.com/Forums/FindPost749128.aspx

What syntax error are you getting?

SELECT a.ID,

MAX(a.Quantity) AS Quantity1,

MAX(b.Quantity) AS Quantity2

FROM MyTable a

LEFT OUTER JOIN MyTable b ON b.ID=a.ID AND b.Quantity<a.Quantity

GROUP...

If you are using SQL Server 2005, you can use XQuery instead of OPENXML

DECLARE @x XML

SET @x=' ...your XML here'

SELECT Packet.value('1+count(for $a in . return $a/../*[. << $a])','INT') AS packet_id,

...

SELECT teacher,

SUM(CASE WHEN Year=2006 THEN 1 ELSE 0 END) AS [2006],

SUM(CASE WHEN Year=2007 THEN 1 ELSE...

Try this

SELECT a.id1,

a.DOS AS StartDate,

MIN(c.DOS) AS EndDate,

DATEDIFF(d, a.DOS, MIN(c.DOS))+1...

Use sp_executesql with OUTPUT variables

CREATE PROCEDURE [dbo].[sp_GetOverallStatus] @statusid int, @rowcount int OUTPUT

AS

DECLARE

@tablename varchar(200),

@query varchar(1000)

BEGIN

SET NOCOUNT ON;

SELECT @tablename = (SELECT Tablename FROM...