Thanks Bob..that works.

works fine...thanks!

Yep, you are right. Many thanks!

If I do this it works..

insert into Vendors

SELECT * FROM dbo.itfAPVEND()

Thanks for your help Sean!

Sean,

Running that returns records..but doesn't exec and fill the vendor table.

solution in case this helps someone else:

;WITH cte AS

(

select * from (SELECT

distinct pehPErcontrol

,case left(substring(pehPErcontrol,5,len(pehPErcontrol)),2)

when '01' then 'January'

when '02' then 'February'

when '03' then 'March'...

geez..thanks Chris...need to get some coffee..

Gotcha. Thanks Guys!

Very helpful and informative.

Okay Sean:

Here is table 1 - 'overtime budget 2013'

CREATE TABLE [dbo].[Overtime Budget 2013](

[Org Level] [nvarchar](50) NULL,

[Overtime Code] [nchar](10) NULL,

[January] [money] NULL,

[February] [money] NULL,

[March] [money] NULL,

[April] [money] NULL,

[May] [money] NULL,

[June] [money]...

It's not that it's returning zero records..it's that when opening a view it just spins and spins eventually timing out. but only on views

There are about 30 views. That...

..just a follow up..

I was able to shrink the log successfully.

you say mirroring was turned off or disabled, but that doesn't mean it was done correctly. If it's not removed from the source, and you don't have a destination, the...

Yeah I'm with you. Doesn't add up..

George - would it be helpful if I get the ldf exact size now and then the exact size tomorrow.

and then compare to that...

how big are the log backups? Any of about 30GB hence leading to the log file growth?

If you right click the database, select reports,standard reports,disk usage you can see if...

If the log file grows, it's because one of these

a) you don't have log backups

b) you have replication or mirroring that are preventing truncation

c) your load is increasing to the...