1.

SELECT s2.[name]

FROM [sales] s

INNER JOIN [sales] s2 ON s2.city = s.city AND s2.[name] <> s.[name]

WHERE s.[name] = 'jones'

GROUP BY s2.[name]

HAVING COUNT(*) = (SELECT COUNT(*) FROM...

Check the Language setting for the logins on both servers as this will affect the ways dates are converted unless explicitly specified using SET DATEFORMAT as mkeast stated.

or

SELECT STUFF(CONVERT(varchar,GETDATE(),110),3,3,'')

If the table has a unique key then

SELECT (SELECT COUNT(*) FROM b WHERE b. <= a.), a.

FROM a

but check the performance though

If you want the result in varchar then

CAST((@col_yr_no*10000)+(@col_mm_no*100)+1 as varchar)

How about this

Yes could be two interpretations

Based on your interpretation

SELECT TOP 3 g.[ID],g.Title,g.Popularity

FROM Games g

WHERE NOT EXISTS(SELECT * FROM Games g2

    INNER...

CREATE TABLE #temp (ID2 int IDENTITY(1,1),[ID] int,Title varchar(30),Popularity int,Related int)

INSERT INTO #temp ([ID],Title,Popularity,Related)

SELECT g.ID,g.Title,g.Popularity,MAX(ISNULL(SIGN(r.rID),0))

FROM Games g

LEFT OUTER JOIN Related r ON r.ID=g.ID

GROUP BY g.ID,g.Title,g.Popularity

ORDER...

The error is telling you that the value of ptrval is null and is caused by either

The table is empty

Or the row in the table has null in the column...

But what does that SUM SIGN ISNULL do?

Because the query uses LEFT OUTER JOIN for @ObPrefs, if...

Create and use a wanted table e.g.

DECLARE @Wanted TABLE(PrefName VARCHAR(10))

INSERT INTO @Wanted VALUES ('nodogs')

INSERT INTO @Wanted VALUES ('waterside')

SELECT o.obId, o.obName

FROM @Obs o

CROSS JOIN @Wanted w...

The ESCAPE cannot be within the string passed to LIKE it must be outside e.g.

set @str =  '%^[7 Diamonds !!! !^]%'

where extbName like @str Escape '^'

Using a temp table, not sure if results are right

CREATE TABLE #temp (period int, rfreq int, pfreq int, startdate datetime PRIMARY KEY CLUSTERED...

Depends if the table has indexes

If not then either will use a Table Scan

If the column is indexed SUBSTRING will use Index Scan and LIKE will use Index Seek

If the...