how did you use a column in the from clause it would be like this

SELECT organisations.organisation_number, organisations.name, organisations.status,

activities.activity_desc, activity_values.activity_value_desc, organisation_categories.quantity,

orgcat2.activity, orgcat2.activity_value, actval2.activity_value_desc,

bmf.dbo.activities.activity_desc actdesc2

FROM bmf.dbo.activity_values activity_values, bmf.dbo.organisation_categories organisation_categories, bmf.dbo.organisations...

can you please tell me what is this

bmf.dbo.activities.activity_desc

is it a table or view or proceduer or function etc, what ever it may be i have some doubt here

bmf.dbo.activities.activity_desc

from this

what...

WITH SampleData (PERSON, [DT], [HRS], [DOW]) AS

(

SELECT 1234,CAST('03/31/2014' AS DATETIME),CAST('8.00' AS NUMERIC(5,2)),'Monday'

UNION ALL SELECT 1234,'04/01/2014','8.00','Tuesday'

UNION ALL SELECT 1234,'04/02/2014','8.00','Wednesday'

...

i think op is still not clear about what he want,

ok one more guess

Hi OP What is the output of the below data

SELECT * FROM

(

VALUES

(1234,'03/31/2014','7.00','Monday'),

(1234,'04/01/2014','7.00','Tuesday'),

(1234,'04/02/2014','7.00','Wednesday'),

(1234,'04/03/2014','7.00','Thursday'),

(1234,'04/04/2014','7.00','Friday'),

(1234,'04/07/2014','8.00','Monday'),

(1234,'04/09/2014','8.00','Wednesday'),

(1234,'04/10/2014','8.00','Thursday'),

(1234,'04/11/2014','8.00','Friday'),

(1234,'04/12/2014','4.00','Saturday')

) AS vtable...

The solution is already there making a small adjustment will produce a result you want

seems something logically missing there

calculating the ot on the last day of the week is it right is it intend or is it a mistake

how about this one keep an eye on the primary key

DECLARE @test-2 TABLE

(

...

i have give three different type of approach tak which one you want

DECLARE @GEOLINE TABLE

(

GEOLINE_ID INT IDENTITY(1,1) NOT NULL

,GEOLINE_LINE GEOMETRY NOT NULL

);

INSERT INTO...

Same logic slightly changed

;WITH cte AS

(

SELECT ROW_NUMBER() OVER ( ORDER BY ResourceID, dt) AS Rno,x.ResourceID, x.Activity, Dt, opr, jobno

FROM (

SELECT j.ResourceID, d.Reason AS...

not sure a better solution but it's a solution

;WITH cte AS

(

SELECT ROW_NUMBER() OVER ( ORDER BY ResourceID, dt) AS Rno,

x.ResourceID, x.JobNo, Dt, xdt.Type

FROM ...

thank you people for you time and effort, you people made my day

i am also found one but it is not good even though i share it

DECLARE @id INT =1;

WITH CteTokens AS(

SELECT ROW_NUMBER() OVER (ORDER BY id) WordCount, Token

...

Thanks , but it only return one record i need both records, i think we are close to the solution, so it is possible

Thanks for your info, those are some messages to show the user in the front end, out application is data driven that's why we have such messages in our Tables,...

Thanks for the response, well that answer was promoted by my seniors, but the trouble is we hold lots of columns in a same table, and tons of tables like...