This is the very premise I don't agree with. Most of the companies...

djackson 22568 (10/26/2011)

---

Matt, I guess I am not explaining myself well. I certainly am not missing the point.

What you and I believe is irrelevant. What matters is what...

djackson 22568 (10/25/2011)

---

Matt Miller (#4) (10/25/2011)

---

Steve Jones - SSC Editor (10/25/2011)

---

richj-826679 (10/25/2011)

---

Human Resource departments are similar to IT departments in that both of them are a cost to the organization...

CozyRoc (10/24/2011)

---

Griffster (10/24/2011)

---

I want to update a value in an xml file (a variable value in a xml configuration file actually for a SSIS package), and was wondering whether it...

Steve Jones - SSC Editor (10/25/2011)

---

richj-826679 (10/25/2011)

---

How many companies...

JamesMorrison (10/7/2011)

---

There is no obligation to be accurate on issues related to money. When you are negotiating over money, it is about strategy.

Be honest about your jobs, time of employement,...

Jeff Moden (10/8/2011)

---

SQL Guy 1 (10/7/2011)

---

Hi all,

Perhaps all of you from time to time encountered a problem, when a recruting agent asks you about your current salary, but you...

Phil Parkin (10/20/2011)

---

Surely another possibility is building a mapping table, if this is likely to be a repeated process?

Something like this:

select 'CITALOPRAM TABLETS' Pseudonym,

...

Phil Parkin (10/20/2011)

---

SQL_Surfer (10/20/2011)

---

SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test...

Do the CAST at the end. It seems to be stumbling on the "5" part of the Decimal(5,2) statement. This would bomb out if the counts were greater...

Chrissy321 (10/18/2011)

---

Getting

"A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement."

INSERT INTO DataUpdateCapture (mydate)

SELECT * FROM...

don't give up quite yet. You can STILL use the output, you just have to use the output as a derived table. Something like this:

insert bob2(col1)

select * from

(INSERT...

Jayanth_Kurup (10/17/2011)

---

As I expected we all agree on the right way of doing things and the reasons. Unfortunately this is what was done and we faced an issue in LIVE....

At home I use one wide screen. It's actually the best of both worlds when you combine it with a simple app like SplitView, which gives you the same...

I can't help but think that the count you're returning is being skewed by the joins you're doing. Not even sure why you're doing so many joins.

Are you using...