TomThomson (6/25/2016)

---

BWFC (6/24/2016)

---

My wife was born in Edinburgh and we'll be legging it up the M6 as fast as we can with her passport stuck to the inside of the...

JoNTSQLSrv (6/25/2016)

---

J Livingston SQL (6/25/2016)

---

I am sorry...but I cannot tell you if its correct......you have to tell us.

your sample dataset is small ...perhaps if you expand this for more than...

I am sorry...but I cannot tell you if its correct......you have to tell us.

your sample dataset is small ...perhaps if you expand this for more than one sellerid and also...

JoNTSQLSrv (6/25/2016)

---

J Livingston SQL (6/25/2016)

---

maybe.....???

WITH cte as (

SELECT s.SellerID,

MAX(c.Mincredit) AS mc

FROM Seller_Table AS s

LEFT OUTER JOIN Credit_Mater AS...

maybe.....???

WITH cte as (

SELECT s.SellerID,

MAX(c.Mincredit) AS mc

FROM Seller_Table AS s

LEFT OUTER JOIN Credit_Mater AS c ON s.TotalcreditEarned >=...

based on your edited first post...with the code (thanks) please post what...

no image ??

suggest you read this article https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

and then provide what Kevin asked...

maybe....

--based on solution http://sqlmag.com/blog/solutions-packing-date-and-time-intervals-puzzle

CREATE TABLE #testtable(

ID INT NULL

,Code VARCHAR(6) NULL

...

maybe....

CREATE TABLE #Emp(EmpRight VARCHAR(10),

EmpGroup VARCHAR(10));

GO

INSERT INTO #Emp(EmpRight,EmpGroup)

VALUES ('EmpRight1', 'EmpGroup1'),

('EmpRight1', 'EmpGroup2'),

('EmpRight1', 'Empgroup3'),

('EmpRight2',...

for clarification please....what results would you expect from this data set

create table TestData (ID int,TestDate date, Score int)

insert into testdata Values ('1','1-Jan-16','10')

insert into testdata Values ('1','5-Jan-16','15')

insert into testdata Values ('1','10-Jan-16','5')...

squvi.87 (6/23/2016)

---

Luis Cazares (6/22/2016)

---

You could use the Quirky Update. Be sure to read and understand the following article as you might get this wrong if you don't know what you're...

GA_SQL (6/21/2016)

---

this task so huge..

Step 1 : Calculating the efficiency of the employee on daily basis, scenario calculate efficiency based on night and dayshift

Step 2: Getting this report

Month -...

Hi Luis

have you seen this other thread from OP?

http://www.sqlservercentral.com/Forums/FindPost1796115.aspx

this has been ongoing...

one way maybe....

WITH...