Cadavre (2/14/2012)

---

(I'm not claiming it isn't worse than yours, just that I don't really see how - will have to do a nice big test set-up when I have time...

Jeff Moden (2/14/2012)

---

Cadavre (2/14/2012)

---

Am I missing something?

SELECT Code, Name, City

FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY City ORDER BY Code) AS rn

FROM #MyHead

...

Are you hoping...

Koen Verbeeck (2/14/2012)

---

Well,...

That's slightly strange.

The below is using the same logic as your code, so can't see that it would work any better.

DECLARE @sql NVARCHAR(MAX)

IF (SELECT COUNT(*)

FROM sys.dm_exec_sessions

...

John Mitchell-245523 (2/14/2012)

---

No they shouldn't. A table is an unordered set. The database engine will retrieve rows from a table in...

BEGIN TRAN

--Your sample data

CREATE TABLE [Temp#1] (ID INT, Two INT, Name VARCHAR(6));

INSERT INTO [Temp#1]

SELECT 1, 1, 'XXABCD'

UNION ALL SELECT 2, 2, 'BCA'

UNION ALL SELECT 3, 4, 'ABCD'

UNION ALL SELECT 4,...

Am I missing something?

SELECT Code, Name, City

FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY City ORDER BY Code) AS rn

FROM #MyHead

...

Vincy-856784 (2/13/2012)

---

Thank you Cadavre for your quick response. But this returns zero rows. Also, I cannot hardcode values and it should be dynamic based on the user selected...

Jeff Moden (2/13/2012)

---

Heh... there are a lot of tried and true methods available in SQL Server that seem to be going by the wayside in favor of "slick" stuff. ...

SELECT *

FROM Log

WHERE ActionTimeStamp >= '2012-10-02 07:30:00' AND ActionTimeStamp <= '2012-10-02 08:30:00'

memymasta (2/13/2012)

---

Hmm not really.

I got this query..

Select a.a from a LEFT JOIN b ON a.a=b.b WHERE b.b IS NULL

Is it possible to get same results with

Select a.a from a LEFT...

DECLARE @Fields AS VARCHAR(4000)

DECLARE @ClientName AS VARCHAR(100)

DECLARE @AuditYear AS VARCHAR(50)

SET @Fields = 'Audit Number,Audit Year,Client Name,status'

SET @ClientName = '''AAFES'''

SET @AuditYear = '''2010'''

DECLARE @SQLstmt NVARCHAR(MAX)

--Do the dynamic bit

SELECT @SQLstmt = COALESCE(@SQLstmt,...

Something like this should do: -

DECLARE @Fields AS VARCHAR(4000)

SET @Fields = 'Audit Number,Audit Year,Client Name,status'

DECLARE @SQLstmt NVARCHAR(MAX)

--Do the dynamic bit

SELECT @SQLstmt = COALESCE(@SQLstmt, '') + ',' + CHAR(13) + CHAR(10)...

vijay82 (2/10/2012)

---

User can not connect with below error.Can any one help me.

The connection statement looks like this:

conn.open "Provider=SQLNCLI10; Data Source='xxxxxx';Initial Catalog='yyyyyyyy';User Id=sssss ...