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?

😎

In a way that is not too bad, we just have to figure out why;-)

😎

Now I have few...

Quick thought, is TCP/IP enabled?

😎

We all have to...

Here is the Window function version Jeff mentioned

😎

SELECT

M.ORDERNO

,ROW_NUMBER() OVER

(

...

Thank you for the timely question Vimal, XML is a topic that definitely needs more coverage, especially when the current SQL Server's capabilities provide some of the best tools for...

ado-712642 (8/14/2014)

---

Is there a different way I could do a query like this:

SELECT ID FROM PropertiesFreeholdAndCondos WHERE lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL...

rana_gman (8/15/2014)

---

Hello,

I have set the environment set for AutoRecover (for every 3 minutes and Keep information for 7 days under the SSMS 2014 Menu: Tools -> Option ->Environment -> AutoRecover).

I've...