Hey Joe - I'm using Project Deployment Model.

Packages run directly in Visual Studio, or if i manually run from Integration Services Catalog. It's very frustrating.

Thanks!!!

Thank you everyone! Appreciate the input and help!

Its for research purposes. The table that I am analyzing is a back end table of a front end clinical survey. A null value means that question was skipped and...

Thanks for this!

I sometimes work with large data sets where my tables have over 100 columns. Is there an easier way of doing this instead of 100 case statements? Maybe...

this works! thanks very much.

Here is the sql for my querry.

SELECT DATENAME(month, DateSvc) AS Month, DAY(DateSvc) AS day, YEAR(DateSvc) AS 'Year', COUNT(ChargeKey) AS total,

convert(char(19),datesvc,100), Right('0' + Case When DateName(hh,...

Yes, the field is a datetime field. 2009-07-15 17:30:00.000

Sorry, I shouldve provided more details:

My Table Name is Hiredates.

Here are the fields:

staffid int,

hiredate datetime,

terminationdate datetime,

status varchar(10).

I was hoping to allow the user to put in a future termination date....

Thank You very much!

Great job on this also, I would've never figured this out on my own. Very much appreciated. You

are obviously a genius.

:cool::cool::cool:

here is the ddl for the table and some raw data.

Create table [Orders] (

[item] [varchar] (40) NOT NULL,

[productkey] [int] NOT NULL,

[price] [money] NOT NULL,

[Dateofpurchase] [datetime] NOT NULL,

[ordernumber] [int] NOT NULL

)

Item...

Yes your right, my mistake. I would want the output to be :

8/29/2010

9/5/2010

9/12/2010

9/19/2010

9/26/2010

Thank You very much for your help. I am dumping these records into one table to then use for a Crystal Report, thats why I am deleting my results before...

Here is the CODE for the first procedure:

ALTER procedure [dbo].[TP_PatientNote]

(

@clientkey int

,@op__docid int

,@DOS DATETIME

)

as

--PATIENT NOTE DATA

DECLARE @AGE INT

DECLARE @DOB DATETIME

DECLARE @ATTENDED VARCHAR (40)

DECLARE @CHARGEKEY INT

DECLARE @CLINICIAN VARCHAR(40)

DECLARE...