Suresh,

here is one way of doing it in SQL2000

create table appointment (

[name] varchar(50),

appt_date datetime,

appt_nbr int

)

insert into appointment ([name], appt_date, appt_nbr)

select 'JOHN CAMP','5/29/2008',67556

insert into appointment ([name], appt_date, appt_nbr)

select 'JOHN CAMP','5/29/2008',67557

insert into...

Although I can't find it in BOL, using 'w' in DATEPART (or DATENAME) returns the day of the week, i.e. the same as using 'dw'.

David,

you need to use

Select DATEPART(wk, GETDATE()) -1

or

Select DATEPART(ww, GETDATE()) -1

Kev

Yama,

you have changed the question!!

It's not a table with 4 columns, it's a table with one column 'column1' with 4 values 'value1','value2','value3','value4'

Kev

[whoops - beaten to it by Steve!!]

Aaron - did it work?

Thanks for the replies so far - this is exactly the kind of info I am looking to get.

Kev

There is an undocumented DBCC command you can use DBCC SHOWFILESTATS.

Check here http://www.databasejournal.com/features/mssql/article.php/3414111 for a explanation of its usage and a sample script from Greg Larsen

Kev

grasping at straws here...but could you post the definition of the inner function also....

You can use the

INSERT INTO table EXECUTE stored_proc

to capture the results of a stored proc into a table structure.

Look in BOL for more info.

Yes - that shows the difference between the default conversion format and the default display format. I've seen many people get caught out by that before, expecting that left(@date,1)...

Shaun - it's gone a whole week without another post to this thread!!!!

At long last it might be dead 😀

Glad to help - do you have any idea what caused it to break in the first place???

Kev

traceflags 1204 and 1222 return more detailed information about the processes involved :

http://msdn.microsoft.com/en-us/library/ms178104.aspx

gives a full description

In QA go to Tools - Options - Results tab

Maximum charcters per column -although you can only specify up to 8192!!!

That is why I added the caveats that the wait time value is low and the waittype is a latch waittype.

If you had waits due to parallelism the...