What are the actual start dates for rows 3 and 4 as they are incorrectly formatted.

Based on that information you have provided this is how you would create the sample...

Thats selecting from the view, I want the create view syntax

CREATE VIEW view_work

AS

SELECT

a

b

c

d

e

f

g

FROM

sometable

I wouldn't of thought you would be which is why we ask for this information.

From the data you have provided we can make best quess as to which bits of...

what is the procedure doing? can you post the definition of the proc?

your looping through some sort of recurssion. where the stored proc calls another proc which calls another proc...

You could use multiple schedules one for each time you need to run it at, or have a constantly running job which looks at the day of the week value...

I wouldnt go that far Eugene

farooq.hbs (5/28/2012)

---

Hi Green,

This is simple,,I dont want to complex... If u run tis query u vl get actual start date N end date

SELECT DISTINCT TOP 2000 vw.work_id as WorkId, vw.name...

at the bottom of all my posts, it looks like this

How to post data/code for the best help - Jeff Moden

I need the DDL and data from your DB, please read the link on how to generate this information.

close but not the one, will keep digging when I have a spare moment.

Ok now I am going to insist that you read the link to posting code and data.

I need the DDL of the table/s and views.

The data from each tables

The expected...

external seal wont be an option as its on a joining wall with next door so, can only treat it from the inside, but yeah it is good stuff, used...

I know a good picture which shows battery desking, but my google search is not finding the right one.

the two walls which need patching and skimming are riddled in damp so needs a damp course doing and then going to put waterproof sand cement on the walls then...

its where you just put bits of glue for example in various places over a surface and then place the top coat over.

so instead of gluing the full piece of...