mpdillon (11/17/2008)

---

This has to be a very basic question but it just puzzles me. I want to select all the dates less than or equal to a given date, 01/01/2009....

If you have the space available on your server, you could restore it to a test database (using a different name, of course), being sure to move where the physical...

You are still missing the point. Is the DATA correct? That is what I was asking when I asked for the...

Multiple inserts for what? Can you write:

create table #MyTest (

TestID int,

TestData varchar(10)

);

insert into #MyTest (TestID, TestData)

select 1, 'A';

insert into #MyTest (TestID,...

I know WHAT you want, but I was asking what should the results BE based on the sample data provided. You...

Here is what I got, plus a slight mod towhat you provided.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[timberstands](

[acres] [smallint] NULL,

...

Based on the sample data, what is your expected results?

Okay. I have no idea what you are trying to do or accomplish. The questions you are asking aren't making much sense, as they have little substance and...

Glad to see you solved the problem.

Slight correction. We are using SmartFTP, not CoreFTP. Obiously my memory was shaky on this, and it took quite a bit of time before I could connect to...

It depends.

This is something you will have to determine based on your application and performance requirements, as well as the size of each of the tables. For very small...

1) Read the article whose link is listed below in my signature block.

2) Post everything the article tells you to post, CREATE TABLE statements for ALL TABLES/VIEWS involved(TESTED to be...

Look up the following in Books Online. you will find an example there.

sys.dm_db_index_physical_stats dynamic management function

Hard to say. I find debugging SSIS packages difficult based solely on a desription of what is going on. Is it possible to save the package to file...

The catch all phrase: It Depends.

If the applications using the databases are 3rd party, you shuld base it on what they currently support. If they are in-house applications, would...