elee1969 (8/30/2013)

---

Hello all,

i have view which displays duplicate id numbers. Is there somehow i can alter my view to not pull up duplicate id's? Any help would be greatly...

ScottPletcher (8/30/2013)

---

To me, that's not a logical claim. While NOLOCK is clearly dangerous, it DOES in fact reduce overhead by...

Brandie Tarvin (8/30/2013)

---

Sean Lange (8/30/2013)

---

Brandie Tarvin (8/30/2013)

---

ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment...

Brandie Tarvin (8/30/2013)

---

ARGGGGH!

The crappy thing about a new computer?

Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL...

@SQLFRNDZ (8/30/2013)

---

One of the application is getting the error as below after migarted and upgraded to SQL 2008 R2 from SQL 2000.

Error: User Lock not found in dB, System...

Something like this?

select dateadd(hour, 15, dateadd(dd, datediff(dd, 0, GETDATE()) - 1, 0)),

dateadd(minute, 899, dateadd(dd, datediff(dd, 0, GETDATE()), 0))

There are very likely some things to help performance. Please see this article about what we need to see in order to help.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

Also, you need to drop the NOLOCK hints....

Jeff Moden (8/30/2013)

---

Heh... all this work just to avoid typing "SELECT * FROM ", which can be a really bad idea in itself depending on the number of rows in...

That's because you added aggregates back into your recursive cte.

danka_6786978 (8/29/2013)

---

Thanks, and I only just now figured it out.

Yes, it was ssms, trying to remove a record from a table that is referenced many times by many tables. We...

ScottPletcher (8/29/2013)

---

Here's an idea: let the proc get the schema name for you :-), then you don't even have to type it in at all!

create PROC [dbo].[sp_getrecords]

(

@TableName sysname

)...

danka_6786978 (8/29/2013)

---

It has happened to me for the 2nd time, on two different servers but both were 2008 R2. I tried to do a little research and find out why...

xRafo (8/29/2013)

---

Thanks.

I modified the script a bit and doesn't generate errors:-), but isn't listing the desired result .. please see document attached (img_1/DataExample.txt). If you can see the nodes_level with...

Stylez (8/29/2013)

---

Hi Sean,

The First Query That you Gave Me Helped.

what i want to do is first split the value from the first Table(Units)

and them Afterwards i will need to insert...

I am having a hard time trying to figure out what you are trying to do here. Your original query has a recursive cte but you don't reference the original...