Sean Lange (7/17/2015)

---

eboucicaut (7/17/2015)

---

Hi Guys,

how can I use words reserved in selected t sql, as Select GROUP, DESC, EXTERNAL, etc ..., i use thems with a linked server, i have...

brandonarrigo (7/17/2015)

---

I am somewhat new to SQL Server and am trying to add a customized query to a report I am building. I have to take the current Accounting...

How did you fix the issue? Others may have the same problem and you solution may...

I was actually looking for the formula you wanted for each of those months. In fact, how should...

s.raddy.89 (7/16/2015)

---

Hi I have a table like this

NameCostMonthYear

Dgjsdj384738740114

Dgjsdj3084895214

Dgjsdj64376482314

Now I want to calculate the relative average, meaning I go to Jan 2014, take the cost and divide it by average(cost in...

Markus (7/16/2015)

---

We have a SQL Server 2008R2 SP2 on Win2008R2. When we run the below query in Mgt Studio it returns results. When it is a prepared statement...

Here is another way to accomplish the task with no need to create a sort column in a CTE.

SET NOCOUNT ON;

DECLARE @TEST_NULL_SORT TABLE (AREA VARCHAR(50) NOT NULL, CATEGORY VARCHAR(50) NULL);

INSERT...

rourrourlogan (7/14/2015)

---

Hello,

here's an example of what I am trying to do.

--Exec Database.Employees

--Use Database

--Go

--Create PROCEDURE AEM.TempTable

--AS

--BEGIN

--Select * into #emptemp From Database.Employees

--End

--Select * From #emptemp

Is something like this possible? I can get...

Matt Miller (#4) (7/15/2015)

---

T & M is used to define: rough duration, billable rates, what is assumed to be in scope and any other specifics as to what's acceptable....

Jeff Moden (7/8/2015)

---

derek.colley (7/10/2012)

---

In the process of tuning up and fixing the obvious deficiencies, only been here a couple of weeks so far. There's no shortage of targets :-)...

So, we are now in mid July, should I start looking at airline and hotel reservations for the Summit?

Not as concerned about getting a flight to Seattle as I am...

Like this:

with SampleData as (

select TestData from

(values ('house:app.apx&resultid=1234,clientip'),('tost:app.apx&resultid=123,clientip'),('airplane:app.apx&resultid=123489,clientip'))dt(TestData)

)

select

substring(TestData,charindex('=',TestData) + 1,charindex(',clientip',TestData) - charindex('=',TestData) - 1),

TestData

from SampleData;

Brandie Tarvin (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

Brandie Tarvin (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071...

SQLRNNR (7/14/2015)

---

Ed Wagner (7/14/2015)

---

With all the talk about copy/paste of the code, I have the ask the obvious. Do you understand how the code works? If you don't...

Eirikur Eiriksson (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row...