What you have in hand is a classic "running total" statement..

i suggest you go thro the following excellent article by Jeff Moden to get the gist and solutions of...

This will also give u the result u wanted..

SELECT

EH.EmpID AS EmpID,

EH1.EmpName AS EmpName ,

EH.EmpName EmpApproverName

...

Please inform here if that code fixed your issue 🙂

You can acheive with a recursive CTE....

Here is a good example:

if object_id('Emp_Hierarchy') is not null

drop table Emp_Hierarchy

Create table Emp_Hierarchy

(

EmpId int identity(1,1) not null constraint pk_EmpId Primary key,

EmpName varchar(128) not...

The best place is the forums in this very website.. if u need real time examples/problems on a topic, say "inner joins" as you mentioned, just go up to the...

Buddy, thats a huge requirement.

1. Find out the who are FKs

2. Check for the Cascade rule.

3. Create a script to compare table in this relationship

4. Create a set-based code to...

Buddy, here is the code u had requested.. It will loop thro the PubName CTE and execute sp_helpArticle for each PublicationName without WHILE Loop. Please note that i have commented...

Tara, from your expected result set, i see u want the minimum date for the combination of size and DB name..

(if the above statement is right, then can u pls...

David, as in Gail's reply, please go thro that article which Gail wrote about the SQL-Injection probelms with dynamic sql and how to counter them.. excellent article that.. and take...

U need to do it using dynamic SQL mate..

please go through the following thread which is similar to ur request and find this post

http://www.sqlservercentral.com/Forums/Topic892483-338-1.aspx#bm892554

yes Arjun, i have to tweak ti for performance now.. i have added lot of garbage in that.. should clean the code.. once done, i wil post the optimized...

Thanks Arjun for an aliter code 🙂

Infact, i used a temporary table to old the data ranges and then joined it to get the ranges, much like your code...

Oh dave, how naive i have been.. the bug-pressure banded to me to do some astronimical calculations...thanks man.. thanks a lot..i did not even think in that line..

Dave, i guess the sample data made confusion.. the cost can be anything, say 1, 4, 7, 11, 13, 12, 22,27, 75,43 etc etc any integer number..

for your second...

Your code seems to work.. u missed out on the apostrophes at the end.. here is the working version (same ur code with slight modification)..

SET QUOTED_IDENTIFIER OFF

DECLARE @TABLE AS TABLE...