Can we use...

Have a look at the output from the following query.

I reckon you're looking for all rows where [source] = 0, and also all rows where the value of the...

Fat Freddy's Cat.

Fertility Pills!

This should give you a few ideas

DROP TABLE #TABLE_A

CREATE TABLE #TABLE_A (DEl_No VARCHAR(6), L_Amt INT, T_Amt INT, A_Name VARCHAR(6))

INSERT INTO #TABLE_A (DEl_No, L_Amt, T_Amt, A_Name)

SELECT '087NT1', 24000, 28699, 'Physic'...

Of course!

You will have to write this bit though - Write a query to retrieve the ingredient...

Unreserved apologies, jvanderberg, for appearing shallow - however the remark passes the logic test. It appears your employers have no intention of raising your salary at the current threat level:...

Jon, you always lower the tone of...

Resign from BP and get a job with TexasOil.

Before Sing4you whines "Not Yet" and Jason protests "Wasn't me!", this is about football and not pregnancy, right? 😀

This looks too simplistic to be a real world problem.

Step by step:

Write a query to retrieve the ingredient rows of the recipe which you are cloning.

Hard-code the new RecipeID into...

-- query 1

SELECT

MyString,

--CHARINDEX('_', MyString),

--SUBSTRING(MyString, CHARINDEX('_', MyString)+1, LEN(MyString)),

--CHARINDEX('_', SUBSTRING(MyString, CHARINDEX('_', MyString)+1, LEN(MyString))),

MySubstring = LEFT(SUBSTRING(MyString, CHARINDEX('_', MyString)+1, LEN(MyString)),

CHARINDEX('_', SUBSTRING(MyString, CHARINDEX('_', MyString)+1, LEN(MyString)))-1)

FROM ( -- sample data

SELECT '00_MECH_UG' AS MyString...

Hello

There are at least three methods for deriving a running total:

1. Triangular join, as you are attempting here

2. Recursive CTE

3. Quirky update

Method 1 is not recommended as it performs poorly...

How long does the select part SELECT

a.policy,

a.form,

a.date,

SUM(a.premium/b.premprcnt) AS premium

FROM b

INNER JOIN a

ON b.policy = a.policy

AND b.form = a.form

AND b.date = a.date

AND...

Here's why I asked - a simple and fast way to get your results:

;WITH Sourcedata AS (

SELECT SubID = ROW_NUMBER() OVER (PARTITION BY ID ORDER BY OLD_VAL),

ID, OLD_VAL, NEW_VAL

FROM...

Hi Daniel

In your sample data, you have two rows in table #VAL for each row in your update target table. Is this always the case? What's the maximum number of...