Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall trying to...

Potty

Luis Cazares (8/5/2015)

---

Eirikur Eiriksson (8/5/2015)

---

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Or better...

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Or better yet - don't forget...

Ed Wagner (8/5/2015)

---

Jack Corbett (8/5/2015)

---

I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think...

Luis Cazares (8/5/2015)

---

Eirikur Eiriksson (8/5/2015)

---

Brandie Tarvin (8/5/2015)

---

I am shattered, y'all. Just shattered.

Romance is officially dead.

I'll be in the back of the Tent in the Desert, crying my eyes out for...

DBAMike (8/5/2015)

---

Has anyone seen this error returned from an application server whilst running a stored procedure against a SQL2012 database?

I have a simple SP that returns 2 columns with 4...

Quick example, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = N'<worksheet name="All itemss Totals">

<layout-options>

<title>

<formatted-text>

<run fontalignment="2" fontcolor="#ffffff">finance</run>

</formatted-text>

</title>

</layout-options>

<repository-location derived-from="www.xyz.com/test" id="AllitemssTotals" path="/workbooks/SubitemsActivity" revision="" />

<table>

<view>

<datasources>

<datasource caption="Allitemss" name="sqlserver.42074.554624143515"...

c'est la vie

😎

Days

Koen Verbeeck (8/5/2015)

---

I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end of the...

sumit4bansal (8/5/2015)

---

I have a table with 8 columns, I need to update data in multiple columns on this table, this table contains 1 million records, having single update was taking...

Corn

haichells (8/4/2015)

---

Hello everyone,

I am trying to run a query from a Linked server "ABCD"

Set @SQLCMD = 'Select * from TableName"

Insert into @TempTableName

Execute (@SQLCMD) AT ABCD

I am getting below error while...

chandrika5 (8/4/2015)

---

This is SQLSERVER 2008 with the management studio. I have a simple table with 250 rows. This table is updated via a web app.

On SQL SERVER management studio:

1.simple query...