You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Can you post the table definition and sample data? Please see the first two links in my signature for how to do this. You should have, at a minimum, CREATE...

It definitely sounds like a good idea to move this into a table.

Can you post a few of the lines? This will help us see what might be the best...

GilaMonster (10/15/2010)

<headdesk><headdesk><headdesk><headdesk>

(No, I'm not going into details, it's a little too sensitive a topic for that. Just.......

Whose are you talking about?

So, I decided to finally get around to testing the 64-bit ACE drivers (replacement for JET), from here.

Running the install, it tells me that I have to uninstall my Office...

In your query, start with a table that is a list of month numbers/names and from that left join to your table. If you don't have any data for months,...

The text datatype is depreciated, and will be removed in the next version of SQL Server. You should use (n)varchar(max) instead.

So, this does work:

declare @test nvarchar(max)

set @test='Hello'

print @test

Does this give you what you want?

DECLARE @test-2 TABLE (LoanApp_ID varchar(10), StatusMWCode varchar(20), StatusDateTime datetime);

INSERT INTO @test-2

SELECT 'A1737','APPROVED','3/5/10' UNION ALL

SELECT 'A1737','SCHEDULED','3/12/10' UNION ALL

SELECT 'A1737','PA-APPRV','1/20/10' UNION ALL

SELECT 'A1737','PA-APPLREC','1/12/10' UNION ALL

SELECT 'A1737','SUBMITTED','3/5/10'...

The microsoft jet drivers are only available in 32-bit systems.

Edit: The 64-bit ACE drivers are available here.

You might want to take a look at the series of Server Overview articles here[/url].

They use SSIS, so it's all free (except for the time required to implement).

I use this......

For Jeff (since he's harping on someone for doing a SELECT *...) :-D:-P;-):w00t:

DECLARE @test-2 TABLE ([*] INT IDENTITY);

INSERT INTO @test-2 DEFAULT VALUES;

INSERT INTO @test-2 DEFAULT VALUES;

INSERT INTO @test-2 DEFAULT VALUES;

INSERT...

When you created the log shipping, it created the database(s) on the second server, and starting the log shipping to them.

When you deleted the log shipping, all you deleted was...

And this is even easier:

declare @test-2 table (MyDate date, MyTime time);

insert into @test-2 values (getdate(), getdate());

select *,

convert(datetime, MyDate) + convert(datetime, MyTime)

...

Try this out:

declare @test-2 table (MyDate date, MyTime time);

insert into @test-2 values (getdate(), getdate());

select *,

DateAdd(second, DatePart(second, MyTime), DateAdd(minute, DatePart(minute, MyTime), DateAdd(hour, DatePart(hour,...