I want to do this only for the future entries, the existing data shud not change

I checked in the app, it looks very simple in tht, the app just calls my proc and when it asks for parameteri eneter 5.5, right after exucuting it displays...

yes i do tht through store proc, and also changed tht in my proc. Do u think there may be something from the app side

Ok guys I got it by this

select

convert(char(10),cast(date

I get this as output

usage: bcp {dbtable | query} {in | out | queryout | format} datafile

  [-m maxerrors]            [-f formatfile]          [-e errfile]

  [-F firstrow]             [-L lastrow]             [-b batchsize]

  [-n...

tried exec with all the parameters but still the same error

I still get the same error though my proc looks fine for me. may be execting it is a problem

Msg 8114, Level 16, State 4, Procedure spAddEmp,...

I am trying to do something like this for Proc 1

execute

Addemp '<jobs><Item JobID = "3" JobID = "2"></Item></jobs>'

Let me know if anybody has questions.

The data in the EmpJob wud be something like this

ID Empid   JobId

1  735      9

2  735      10

3  735       11

4  735       12

5  739        9

6  794      41

7 ...

yes..i need apce used by the table for the data in the year 1995.

like space used where

datepart(yyyy,convert(char(10),cast(c_date - 36161 as datetime),101))=1995

able to insert data but how can i select date column from my each table and sort accrodingly.

yeah I cehcked my master db and read that but

I wud like to know how i can change tht for

getting data for the table where datepart(yyyy,convert(char(10),cast(date...

any help??