Shailesh Chaudhary (11/17/2008)

---

I have two Tables

Citation(CitationID, Date , ISReportTaken) and ReportExport(CitationID, ApplicationID, ISExported)

I want to insert One column records from Citation table to reportExport with ApplicationID =2 and ISExported =1...

Run this query and see what you find:

select * from msdb.dbo.backupset where database_name = 'DBSwsam' -- use the appropriate DBName here

I also reread your orinial post, and have a change.

Select all records with an end date of yesterday:

select

*

from

dbo.myTable

where

EndDt...

Looks like you are trying to backup to a mapped drive. That may be the problem. Can you change the destination of the backup file to use a...

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...