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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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'

...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

how about this one keep an eye on the primary key

DECLARE @test-2 TABLE

(

ID INT...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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 ...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]