So do you know that read uncommitted is the same thing as NOLOCK??? The locking does NOT all happen in the vendors application. Are the users ok with the idea...

Why do you need to drop every foreign key, then truncate every table frequently enough that you need a procedure for this?

We can probably help but what does "I...

I just use the regular OPTIONS available with native SSMS. But then, it only color codes the bottom of the window and can be reset to default if something strange...

You can use a crosstab instead of a PIVOT. This will offer the ability to make it dynamic too. Take a look at the links in my signature about cross...

rpringnitz (8/28/2013)

---

SELECT SUM(ISNULL(ord_totalweight, 0)) AS Expr1

...

What have you tried? I still have no idea what your actual desired output should look like.

Snigdha Vartak (8/28/2013)

---

ChrisM@Work (8/27/2013)

---

Why are you using IN and not = for these comparisons?

SV00300.CUSTNMBR in (@CUSTNMBR)

or SV00300.LOCATNNM in (@LOCATNNM)

or SV00300.Contract_Number in (@Contract_Number)

If any of these variables are a comma-delimited list,...

thomas@the_grind (8/28/2013)

---

I do not understand why the exists() tests are not working. I'm using SQL Server 2008 R2.

Here's the code:

create trigger dbo.io_trigger_Insert_Alert

on dbo.ALERT

...

You can use a character in an aggregate (MIN, MAX,...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

What exactly are you trying to do here? It looks like you are just trying to format the current date? Have you looked at CONVERT?

http://technet.microsoft.com/en-us/library/ms187928.aspx

Generally speaking it is better if...

Duplicate thread. Post replies here. http://www.sqlservercentral.com/Forums/Topic1489145-3411-1.aspx

Colin Daley (8/27/2013)

---

Hello All,

Have you ever wanted to generate railroad diagrams from the Books Online grammar? That is, convert

CREATE TABLE

[ database_name . [ schema_name ]...

Nice job posting ddl and sample data. However you lost it with your description. It sound like you want a dynamic cross tab but some of your comments are very...

Isabelle2378 (8/27/2013)

---

Hi,

My tables do not have primary keys and as I understand it, transactional replication requires primary keys so my question is: Has anybody found a 3rd party solution...