yeah thats fine, but how do you identify your 'first' record?

Is this what you are looking for?

Create table #t (ip varchar(1000))

INSERT INTO #t VALUES ('http://192.49.42.39/bcccontent')

INSERT INTO #t VALUES ('http://192.49.42.39/bcccontent1')

INSERT INTO #t VALUES ('http://192.49.42.39/bcccontent2')

INSERT INTO #t VALUES ('http://200.49.42.39/bcccontent1')

Select REPLACE(ip, '192.49.42.39','192.49.42.40') ...

Dupe post.

http://www.sqlservercentral.com/Forums/Topic824312-145-1.aspx

based on which column are you saying that 1, 2 is your first record? ( i mean in which order?)

SSSolice (11/24/2009)

---

Hi Nabha, I was curious about any differences in...

I am guessing its a case of PIVOT. Please provide the data in the format as described in the link below. Thanks.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Select * from (SELECT *,

Row_Number() OVER(PARTITION BY CustomerNumber ORDER BY

CustomerNUmber) as row_no

FRom CustomerContactsXref) t

Where row_no > 1

Not sure if this is what you are looking for.

CREATE TABLE #t (varr varchar(50))

INSERT INTO #t values ('XYZAP99123')

INSERT INTO #t values ('XYZAP98123')

INSERT INTO #t values ('XYZAP97123')

INSERT INTO #t values...

Pravin Patel-491467 (11/24/2009)

---

SELECT A.Name

FROM Students

WHERE

A.No IN (22,34,12,67)

Hi Guys,

In above query i am using "IN" clause to find out Student No. but some time no. of find are very large.

Thanks in...

Create an SSIS package to read from the excel sheet and load it into the database. Execute this package using a sql job.

There are lot of other ways as...

Does this help you?

Create table #user(location int, grade_value int)

INSERT INTO #admin VALUES(1,240)

INSERT INTO #admin VALUES(2,270)

INSERT INTO #admin VALUES(3,300)

INSERT INTO #user VALUES(1,246)

INSERT INTO #user VALUES(1,273)

INSERT INTO #user VALUES(2,301)

Select location, grade,nearest from...

You have an 'END' and there is no corresponding begin at the start?

🙂

INSERT...

-- END IF

(Sorry Vikas, dint see your reply!)

Jeff Moden (11/20/2009)

---

Heh... no it's not...that function has a While Loop in it and it's going to be...