I am confused. Earlier you said, "The default locations are blank on this one and yet it defaults to the D:\."

Did it default to D: or the data drive, or...

These are my thoughts. You should testing these, but it appears:

1. The log defaulted to the root directory of the server when it could not find the virtual drive.

My root...

jeff article, or one of them, on Tally tables is at URL: http://www.sqlservercentral.com/articles/T-SQL/62867/

I am look forward to going through it. This looks like a nice solution.

Jeff,

Still not sure of the format, but gave it 2 ways. Does this work for you?

DECLARE @date DATETIME, @number INT

SET @date = '2010-01-01 00:00:00'

--SET @number = 12

drop table monthcounter

create table...

another option is to use replace as in:

declare @a1 varchar(50)

declare @sql varchar(255)

select @a1 = 'Izmir''in en güzel yerleri'

-- char(39) = ' this means it replaces a single quote...

Another thought may be that you check the server properties.

1. Under general, what is the root directory?

2. Under security, what are the login auditing and options?

3. Under database settings...

I get it now.

Craig, I was not attempting to quote anyone. i was just commenting on what my answer did not cover.

Someone else addressed the quote that it appears to remind you of.

Another option is:

-- import

truncate table dbo.Importedtable

INSERT INTO dbo.Importedtable(data)

Values

('x'),

('y'),

('#1234567891'),

('Descript Prod 1'),

('12.34'),

('z'),

('a'),

('#1234567892'),

('Descript Prod 2'),

('22.44'),

('#1234567893'),

('Descript Prod 3'),

('33.3');

select UqDId.Id, UqDId.IRefId, UqDId.IDescription, i3.data price

from dbo.Importedtable i3

inner join

...

If I understand you correctly, use the dateadd function and subtract 1 from the number of months you wish to add.

DECLARE @date DATETIME, @number INT

SET @date = '2011-01-06 00:00:00'

SET @number...