sgmunson (6/19/2015)

---

With SQL 2012, the query can actually be simplified:

DECLARE @Spec1 AS TABLE (

Spec1ID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,

Channel int NOT NULL,

[Timestamp] datetime NOT NULL,

Lambda decimal(8, 2) NOT...

First attempt on getting this query working using Sean's sample data.

WITH cteCs AS(

select *,

ROW_NUMBER() OVER(PARTITION BY [Week],...

You mean sp_refreshsqlmodule because it's a UDF. 😉

You could also correct the source if at all possible,

Here's an example using AdventureWorks2012

SELECT a.AddressID,

a.AddressLine1,

a.AddressLine2,

a.City,...

I posted 2 options. The first is called cross tabs and the second one uses the PIVOT operator.

You can read more about this approaches in here: http://www.sqlservercentral.com/articles/T-SQL/63681/

I also posted...

Just remember that there's no order inside a table. There's an order inside a flat file, but there's no certainty that SQL Server will load it in the same order.

That...

How do you identify each group that you're converting to a row? You're missing the E on your EAV design.

You need to pay more attention to details.

You are missing one parenthesis in your second option and the target data type in the first one.

The precision in decimal indicates the...

This can be solved by adding one more ROW_NUMBER() function to create groups based on the SalesRep.

WITH

cteCust (RowNum, CustomerNumber, Division, SalesRepType, SalesRepNumber, BeginDate)

AS

(

SELECT

ROW_NUMBER() OVER (PARTITION By CustomerNumber, Division, SalesRepType...

Lynn Pettis (6/16/2015)

---

Basically, it is the same reason just not positional based. All values returned in the CASE statement must be of the same data type....

I couldn't even find the Millenium Falcon.

You're doing an inner join with Table3. Are you sure that Table3 has the rows needed?

Ed Wagner (6/16/2015)

---

ChrisM@Work (6/16/2015)

---

j.grimanis (6/15/2015)

---

Hi,

I have a procedure which inside I call two other Procedures, the first one is updating table Purchase Order and the second one is updating an...

gazy007 (6/16/2015)

---

Thanks Luis,

I managed to change and get this working so far

"ELECT

CompanyName, CustomerAccount.AccountNumber ,

SUM( CASE WHEN YEAR( DateEntered) = YEAR(DATEADD(YY, -4, GETDATE())) THEN (SalesLine.OrderQuantity*SalesLine.SellingPrice...

j.grimanis (6/16/2015)

---

The second procedure( which does not work correct some times) is being executed after a "Commit Transaction" inside the first proc. Is there a possibility that rows are...