Try this

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,@Date)),DATEADD(m,1,@Date))) AS 'Last day of the month'

try this one.

SELECT ITEMNMBR, ITEMDESC, ABCCODE, UOMSCHDL, CurrentMonth,

QtyOnOrder, SafetyStock, QtyOnHand, Planning_Lead_Time, Supplier, PLANNINGLEADTIME, This_Month,

SUM(Month6) * - 1 Month6,

SUM(Month5) * - 1 Month5,

SUM(Month4) * - 1 Month4,

SUM(Month3)...

try this:

convert(char(10),convert(datetime, 'jul 5 2009 12:00 AM'),101)

Wow! Thanks a lot. It works.

select Substring(Name,CHARINDEX(' ', Name)+1,34)

Create project by using Integration Service Package in Visual Studio 2005. Import it into SSIS and add to your job.

select distinct stuff((select ',' + Rtrim(name) from Your_Table where id=1 FOR XML PATH('')),1, 1,'')name

Create procedure [dbo].[ftp_UploadFile]

@FTPServervarchar(128) ,

@FTPUservarchar(128) ,

@FTPPWDvarchar(128) ,

@FTPPathvarchar(128) ,

@FTPFileNamevarchar(128) ,

@SourcePathvarchar(128) ,

@SourceFilevarchar(128) ,

@workdirvarchar(128)

as

/*

exec s_ftp_PutFile

@FTPServer = 'myftpsite' ,

@FTPUser = 'username' ,

@FTPPWD = 'password' ,

@FTPPath = '/dir1/' ,

@FTPFileName = 'test2.txt' ,

@SourcePath = 'c:\vss\mywebsite\' ,

@SourceFile...

USE Northwind

SELECT ProductName FROM Products WHERE CategoryID IN

(SELECT distinct CategoryID

FROM Categories Where CategoryName = 'Beverages')

1. Products table doesnot have CategoryName

2. Always put distinct in subquery.

Won't be easy to exclude identity column from insert statement?

existing table T1 (ID [int] IDENTITY(1,1) NOT NULL,

A1 varchar(50),A2 varchar(50),A3 varchar(50)......)

insert into T1 (A1,A2,A3,...)

select B1,B2,B3,... from T2

Thanks a lot. It works

insert into has to be from exsiting table.

get any existing table, select 2 fields and hardcode it.

Insert into #check

select 1 Column1, default Column1 from tbl1

Thank you All, I solve the problem.

select da.ID, da.Date,

(select sw1.HRS_WKLY from SAL_WKLY sw1 where sw1.ID = da.ID...

it returs 3 records for the same date

ID Date hrs_wkly sal_wkly

---------- ---------- ----------

1 03/15/2007 25 300.00

1 03/15/2007 30 500.00

1 03/15/2007 35 700.00

you forgot to add  where [D].id=[W].id

It returns only 1 row (06/01/07).