could be a number of issues

is sql browser running?

is the sql server running?

firewall blocking the TCP port

sql only set to accept local connections

Ah, yes it was, I didnt notice that.

MadTester (5/28/2012)

---

Been trying to solve this with a cursor on the initial query but I seem to be stuck in a loop adding the same record.

I am appealing since...

you have multiple process id and you can only link 1 row to 1 row, you cant link 1 row to many rows in a result set

CREATE TABLE #temp

(

Work_ID...

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