CPiacente (6/22/2015)

---

Thank you for the information. I will look into that. In addition however, I noticed some percent_rank() values would only get to around 65% or so as the max....

I don't see how that answers...

There's always the option of using a CASE statement to set the value to...

jparks 85798 (6/19/2015)

---

Steve,

Thank you SO much for the assistance. I didn't think about removing the extraneous Minutes and seconds. I adjusted the code to pull from my...

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 NULL,

[Power]...

CPiacente (6/19/2015)

---

Hello,

I have a formula I am having difficultly with and cannot seem to find a solution for it. My understanding of the PERCENT_RANK function is it will break up...

GilaMonster (6/19/2015)

---

dhanekulakalyan (6/19/2015)

---

3) The reason I kept '%141928888%' is there will be CID like 141928888S12 or 1419288881X2 or 14192888812A or 14192888812 or 141928888M121 . So we need to get the...

Lynn Pettis (6/18/2015)

---

sgmunson (6/18/2015)

---

Yes, it will get rid of the commas, but it seems odd...

jparks 85798 (6/18/2015)

---

This is probably a mess, but it does the trick:

declare @start datetime

declare @end datetime

set @start = GetDate()

set @end = dateadd(hour,72,GetDate())

while @start < dateadd(day,30,getdate()) begin

Insert Into...

A couple of thoughts:

1.) Any chance you can UPDATE the base table's CID field to be LTRIM(RTRIM(CID)) on an overnight job and no longer have to deal with those parts...

What do we do if the quantity from any one shop isn't large enough?

For the original poster, the ROW_NUMBER() function you're looking for would look like this:

ROW_NUMBER() OVER(PARTITION BY [Name] ORDER BY [Date]) AS Weekdays

The PARTITION BY portion will start the numbering over...

Travis Dean (6/18/2015)

---

Thank you Steve - I was having a hell of a time trying to figure out the join that didn't have a join in the CTE. Are there...

sqlinterset (6/18/2015)

---

Sorry for confusion, while testing few of the conditions came in picture. here is the updated one:

create table #cs([Year] float,

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255)

,[Issue] nvarchar(255), [Type] nvarchar(255), [Dept age]...

sqlinterset (6/18/2015)

---

This is working but failing for specific conditions like where for a perticular week, if no data exist for a perticular category combination, then its assigning c1 as previous...