Hey Joe,

would you care to share a definition of the...

Alvin Ramard (8/19/2014)

---

Ed Wagner (8/19/2014)

---

SQLRNNR (8/19/2014)

---

Luis Cazares (8/19/2014)

---

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at...

John Mitchell-245523 (8/19/2014)

---

Normally, I'd agree you. On this occasion, however, the string manipulation appears to...

Using Tavis's data sample, here is a slightly more efficient query

😎

DECLARE @ID INT = 2;

-- Set up table variable

DECLARE @test_XMLQuery1 TABLE (

ID INT PRIMARY KEY,

MSG NVARCHAR(MAX) NOT NULL);

-- Insert some...

sgmunson (8/19/2014)

---

The question is, what's the meaning of the last 4 characters. Yes, you could throw them away, but if they hold meaning, that's not usually a good...

Quick suggestion, skip the string manipulation, use math and then format to taste.

😎

DECLARE @TIMEDECIMAL decimal(8,0) = 12310476;

SELECT

CONVERT(VARCHAR(5),DATEADD(MINUTE,(FLOOR((@TIMEDECIMAL / 10000) / 100) * 60)

...

Luis Cazares (8/18/2014)

---

Help! I was asked by my DBA to optimize the following query because it has a high cost.

DELETE MySchema.Facttable

WHERE datecol = @Date;

It's part of...

TSV stands for Tab Separated Values, since your incoming data is in XML format I...

Quick thought, why going through all this trouble with the case statement in the dynamic sql?

😎

declare @b-2 int

declare @action varchar(100)

declare @dbname varchar(100)

declare @a int

set @dbname = 'adt'

set @action = 'dfgf'

set...

<post>

<respond type="forum reply" >

<author username="Eirikur Eiriksson"

...

protix (8/6/2014)

---

Hello,

is it possible to create a cluster configuration, where 2 (or more) SQL Server instances running on different servers will simultaneously serve the same database attached to the same...

No worries. Just a quick question, it puzzles me how an empID can bear any weight on a salary, can you explain this?

😎

t.mounika01 (8/17/2014)

---

I have created a table Employee with empID and Salary. Using the case statement I tried to add a column called New Salary, which I tried to obtain by...

Hi Erland, I think Tom is mixing up us two from way up north, even the confusion is misspelled;-)

My (Eirikur :-D) first question...

There is definitely some room for improvement here but first can you provide the yearweek population code?

😎