lawson2305 (6/9/2012)

---

Ok I have a question I have a 116gb DB the full backup ends up around 70.5GB in size I then perform a transaction log backup which the log...

The ANSI-89 style outer joins were depreciated and is no longer supported in SQL Server 2005 and later. For OUTER JOINS you need to use the ANSI-92 Style.

This would...

I hope you have a good backup. That is the the best way to recover your database.

Sean Lange (6/8/2012)

---

Stefan Krzywicki (6/8/2012)

---

Ugh, just found out we're switching to security that requires you to change your password every 90 days. Nice that we're switching to that now that...

thadeushuck (6/8/2012)

---

create table Zips (Zip int, City [varchar](36) null, StateCode [varchar](2) NULL, County [varchar](36) null)

insert into Zips values (75056, 'Dallas', 'TX', 'Dallas');

insert into Zips values (75057, 'Irving', 'TX', 'Dallas');

insert into...

thadeushuck (6/8/2012)

---

create table Zips (Zip int, City [varchar](36) null, StateCode [varchar](2) NULL, County [varchar](36) null)

insert into Zips values (75056, 'Dallas', 'TX', 'Dallas');

insert into Zips values (75057, 'Irving', 'TX', 'Dallas');

insert into...

Sounds to me like the someone needs to verify that the webservice is actually doing something with the value being returned. Perhaps a little debugging session on the wbservice...

Also, this looks like an estimated execution plan, the actual execution plan would be much more helpful.

Drop the NOLOCK hints, they will be ignored anyway as this is an UPDATE.

Glad to be able to help.

First, please pay close attention to how I created the tables and sample data. This is what you should do when asking questions instead of relying on us to...

Evil Kraig F (6/8/2012)

---

Lynn Pettis (6/8/2012)

---

You have to be kidding me.

OP: I don't want a union. How do I put these two queries together?

Me: Looks like you need...

You have to be kidding me.

OP: I don't want a union. How do I put these two queries together?

Me: Looks like you need a join.

OP: Yes, how...

Make the second query a CTE, then join it...

SueTons (6/8/2012)

---

Hi all, I'm new to SQL, any instructions or sample code to create the Store Proc below would be greatly appreciated.

Find below the details.

Requirement: create SP to validate...