jdbrown239 (8/26/2012)

---

Need to create view with no outer joins so I can index the view. Here is the query I use to create the view. Does anyone no of a...

mfundotogu (8/26/2012)

---

create table Rooms

(Room_no char(4) primary key not null,

Room_Status varchar(20) not null,

Room_Type_Code char(4) foreign key references Room_Type(Room_Type_Code))

go

Data in the Table.

1011AvailSTD1

1012AvailSTD1

2011AvailDLX2

Create table Room_Bookings

(Booking_ID char(8) NOT NULL ,

Room_no char(4) NOT NULL Foreign...

Saga... (8/27/2012)

---

SELECT @MSGOUT = @MSGOUT + '

<tr>

<td>' + ss.ServerName +'</td>

<td>' + ss.DBName +'</td>

<td>' + Occurrences +'</td>

</tr>

'

FROM /*DBINVENTORY ss --after removing this...

Try this instead then:

if EXISTS

(

select * from sys.columns

where object_id = object_id('TableA')

and is_identity = 1

)

SET IDENTITY_INSERT TableA ON

LOL or use Lynn's. His is probably a little better way to check for...

haiao2000 (8/24/2012)

---

Thank you for quick response. I actually replied to my post previously. you are right all i tried to do on that is basically squelching, definitely not handling. I...

Here is proof. In my database I do not have TableA.

DECLARE @ErrorMum INT

DECLARE @ErrorMessage VARCHAR(200)

DECLARE @Severity INT

DECLARE @State INT

BEGIN TRY

BEGIN TRAN BACKUP101

BEGIN TRY

SET IDENTITY_INSERT TableA ON

END...

My guess is one your early try-catch blocks has encountered an error but you can't tell because you have empty catch blocks. I call that error squelching, not handling. The...

stephen mehl (8/24/2012)

---

I spoke too soon.

I need multiple uses ... SQL does not like the second instance of "IF"

IF EXISTS (..)

summarize the data - 1

ELSE

add a...

For anybody else still following along I put together a test harness to check this out. Thanks to Jeff for the sample data.

CREATE FUNCTION RemoveLeftCharPatIndex

(

@Source VARCHAR(1000)

...

tyson.price (8/24/2012)

---

I get your point but, that is why we have comments. I will take performance over easy to read any day of the week. Comments are easy to type...

tyson.price (8/24/2012)

---

Eugene Elutin (8/24/2012)

---

Steven Willis (8/24/2012)

---

Try this:

CREATE FUNCTION dbo.svfRemoveLeftMostCharacters

(

@Source VARCHAR(1000)

,@Char CHAR(1)

)

RETURNS VARCHAR(1000)

AS

BEGIN

/* This function requires a Tally or Numbers table */

/* http://www.sqlservercentral.com/articles/T-SQL/62867/...

I tend to agree with Lowell on this one though. A phone number is rather meaningless by itself. It only gains relevance when you know what it belongs to. I...

You should change this to...

And no amount of testing can ensure that using join hints will be correct. What is better on the data today may very well be different tomorrow when the amount...

Well SSMS is not designed to be a data...