thanks

let me know if you find a work around that one

hi pradeep

thanks for the quick response, no i haven't, the servers reside in our main office how do i go about creating linkservers

hi grkanth81

did you get a the work around with this issue? i also have a similar situation where i have to develop a report which will display data from different...

thanks Luke

i'm going to try that and i think it's gonna work.

thanks for the response

data is coming from different databases and the tables i'm calling are all the same in the DB but with different data ofcause, i'll have to...

thanks for quick response;

i was looking at something like this:

DateTimeVar StartDate:= CurrentDate;

DateTimeVar EndDate := {vw_wrkWorkOrders.RequiredByDate};

//Find out the difference in days and subtract the weekends

NumberVar DaysDiff := DateDiff("d",StartDate,EndDate) - DateDiff("ww",StartDate,EndDate,crsaturday)...

thanks for the response.

do i put the command before -o"C:\Myfolder\MyOutput.txt"? and if the command you gave me delete the file how's gonna get output file.

hi guys

thanks for the responses, and yes you were right, i got rid of the cursor and used a normal update query and it worked a bit faster..

thanks again

i used "[ON_KEY_42R5_UDM2]..astAssets.ID" etc. in the select then i removed the last inner join cause i was getting an error " The multi-part identifier "ON_KEY_42R5_UDM2..dbo.fn_astTypeGetSecondHighestAssetTypeBelowRoot(astAssets.AssetTypeID)" could not be...

hi Lowell

thanks for the prompt response but i tried that and still getting the same error: "The multi-part identifier could not be bound."

the two databases are in the same...

hi, thanks for prompt response.. here's the database structure:

ComplDate O/T1 O/T2 StaffName ...

what i did was i went few steps back in my installation and i unselected Management Tools from the selection tree and the installation was successful but the thing now...

thanks for a prompt response....

where do i find that SSMS Express installed

hi

i've done the installation and changed the named instance to a different name but on the Installation Rules window i'm getting an error saying i have to remove SQL Server...

thanks Steve

i'm still waiting for the installation CD, i'll see what happens then