That helped a lot all.

Thanks

Pat

Hi,

I just need to get date on the report and the column is datetime format

select tdate from table

but the result i get back is Jul 5 2009 12:00

but on...

Hi,

I got that which SPID is blocking but I need to have see the Process that is running or TextData

Thanks

Pat

it says:

Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '+'.

I tried but it only creates value and then says this:

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET @FileName = REPLACE('E:\temp\result_'+CONVERT(char(8),GETDATE(),1)+'.txt','/','-')

SET @bcpCommand = 'bcp "select top...

here is the whole table and view scenario

create table table1

[pid] [int] IDENTITY(1,1) NOT NULL,

[num] [int] NULL,

[flag] [int] NULL,

[tp_id] [int] NULL,

[fe_id] [int] NULL,

[sym] [int] NULL,

[nvarchar](256) NULL,

[lbl] [nvarchar](256) NULL,

[sname] [nvarchar](256) NULL,

[fname]...

oh yes sorry it took me while to understand.. but the view does have other columns which could ne text, as well. What is the solution?

it is only numbers and integer it does not contains text!!

numbers from 1 to atleast 55000

Thanks

ok,

I tried creating new view. View created fine but now when i try to create index on the column it give me this error.

create unique clustered index idx on vw1(col1);...

ok,

Now i understand. but i changed the view now useing this

creaet view v1 as schemabinding as

select t1.name1, t2.name2

from

bdname.dbo.table2 t2 join dbo.table1 t1 on t1.id = t2.id

and i get this error....

I can access the same table with select from query but when i try to create indexed view it gives me error for remote server.

but with simple views it works...

thanks for the respose.

I have this pacakge which process excel fiel and after it processed it moves file to archive. i have about 5 variables like sourcefolder, filepath, filename, archfolder,...

i used command based on the stp and it wored fine.

also it is for each file enumerator.

it's a for each look container in SSIS package. and i passed variable (fn) for filename to property of varaible mapping. and in general i passed the locatoin of the...