Sean Lange (4/9/2014)

---

Yes indeed. One suggestion I would offer is to include an order by for your subquery...

GilaMonster (4/9/2014)

---

You might want to google Lynn's contributions here...

Well, looks like Sean and I have similar but different solutions.

Try this. Please note that the script also drops the table when completed to keep my sand box database clean.

CREATE TABLE [dbo].[Luke_PS2](

[Ward or Team Name] [nvarchar](255) NULL,

[Date] [datetime] NULL,

[Setting]...

Satheesh E.P. (4/9/2014)

---

Hi All,

Create Table Test01( 

business_date date)  

1. Insert into test01 (business_date) values ('2013may6')

2. Insert into test01 (business_date) values ('20140409') 

In the above example both the statement will succeed. But as per our requirement, the first statement should fail on inserting (i.e)...

GilaMonster (4/9/2014)

---

sql-lover (4/9/2014)

---

GilaMonster (4/9/2014)

---

You can't. sys.indexes is not a table, it's a view.

Please, don't try...

sql-lover (4/9/2014)

---

GilaMonster (4/9/2014)

---

You can't. sys.indexes is not a table, it's a view.

Please, don't try the...

Haven't started looking at SQL Server 2014 so I...

Add WITH TIES to your select top 20. Hope the following helps illustrate what you need:

create table dbo.production(

ServerName varchar(20),

ServerState varchar(10)

);

insert into...

First, sys.indexes is not a table but a system view. As the error message indicates it is made up of multiple tables and you can't update multiple tables at...

OMG!

yuvipoy (4/9/2014)

---

I have been using this statement for nearly 6 years in prodution i did not get any error or issue.

all of the sudden it happened today and i am...

Simple, don't use NOLOCK.

Jeff Moden (4/9/2014)

---

Thank...

kish1234 (4/8/2014)

---

Hi Team,

I have started putting together the logic for the above requriement..

CASE

WHEN RecurrenceType =1 and Recurrenceinterval =2 and datediff(day,'07/01/2013', RecurrenceStart)/ 14 < 7 then 'Week1'

When RecurrenceType =1 and...

awcrestview (4/8/2014)

---

Lynn,

Thanks for you help Lynn, you're awesome. Below is from your recommendation with minor change to get what I needed.

WHERE start_datetime >= dateadd(hour, -1, dateadd(day, datediff(day, 0, (getdate)),...