Try this, Wayne:

USE Occupancy

;WITH BookingsToUpdate AS (

SELECT

*,

Seq = ROW_NUMBER() OVER (ORDER BY Booking_Skey)

FROM Bookings

)

SELECT

Seq,

Booking_Skey,

BookingNumber = 'B' + RIGHT('0000000' + CAST(Seq AS VARCHAR(8)),8),

AnotherBookingNumber = 'B' + RIGHT('0000000'...

wafw1971 (2/20/2013)

---

I have a column on my database called Booking Number this is to be used on correspondence etc however I don't want it to be Booking Number to be...

DwainC already figured it out for you:

SELECT

ArrivalDate,

BookingDate = DATEADD(day,

-(1 + ABS(checksum(NEWID())) % 90),

ArrivalDate)

FROM Bookings

ORDER BY ArrivalDate

DROP table #empl

CREATE TABLE #empl

(

row_id int,

ename varchar(120),

job varchar(120),

sal varchar(100)

)

INSERT #empl VALUES

('4','ram','IT','60000'),

('4','ram','IT','60000'),

('4','ram','IT','60000'),

('4','ram','IT','60000');

WITH OrderedData AS (

SELECT row_id, ename, job, sal,

rn = ROW_NUMBER() OVER(PARTITION BY row_id, ename, job, sal...

Gosh - thanks!...

-- Collect the matches

SELECT l.ID ;

FROM LARGE l ;

INNER JOIN small s ;

ON s.ID <> l.ID ;

AND LARGE.Z5 = small.z5 and Large.ln = small.ln and Large.fn = small.fn...

Paul White (2/18/2013)

---

ChrisM@Work (2/11/2013)

---

I don't know if this error (Error 8623) is dependant upon system resources, in which case you might get lucky using a server with more resources, or...

sqldba_newbie (2/16/2013)

---

This is more of generic programming question. We have a stored procedure which is used on many of our applications built using asp.net. The sp basically first gives total...

Sachin Vaidya (2/14/2013)

---

Hi Cadavre,

Your response definitely shows a path to move ahead, thanks a lot for that.

But on the other side, it was very rude. It will discourage people from...

Another way:

SELECT abc.*

FROM dbo.abc abc

WHERE NOT EXISTS (SELECT 1 FROM dbo.xyz)

OR abc.id IN (SELECT ID FROM dbo.xyz)

Which lookup table, Pat? The article (and the discussion) should provide you with all the...

+1

The option you have commented out will never be selected because there's an option before it in the CASE construct which will:

CASE

WHEN mb.name LIKE...

You're welcome. Thank you for the feedback.

42 of course. Doesn't everybody know this now?