thanks for the help

its not mentioned directly on BOL but its takin int value of 4 bytes so is ir safe to assume that it will take

data from -2^31 (-2,147,483,648) through 2^31 -...

hi

thanks for reply

the above query will give orderid and productid but its not telling that orderid is mapped as "new orderId" in alias

there is no mapping between columns in...

hi

thanks for reply

the above query will give orderid and productid but its not telling that orderid is mapped as "new orderId" in alias

there is no mapping between columns in...

this is the actual view used

create view Invoices AS

SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,

Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City,

Customers.Region, Customers.PostalCode, Customers.Country,

(FirstName + ' ' + LastName)...

yes 'sa' works , my question is y i need a sql login to access a text file .

also the example i gave was for sp_addlinkedserver

books online suggested for adding a linked server to text file

--Create a linked server

EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',

   'Microsoft.Jet.OLEDB.4.0',

   'c:\data\distqry',

   NULL,

   'Text'

GO

--Set up login mappings

EXEC sp_addlinkedsrvlogin txtsrv, FALSE,...

this statement is working

EXEC sp_addlinkedsrvlogin txtsrv1, FALSE,null,'admin', NULL

but can anybody point me to the difference between them ??

thnx a lot

that was really fast

jus one thing , can somebody explain me the diff between 2 queries , mine was...

thnx for the reply

we are using the query to find data from lefttable thats not available on right side table.

is there a better way of performing it

amrita

thanks for the reply Noel

that syntax problem is my copig wrong query

apart from that , we cant create a view because we...

ya that makes sense , thnx for all the help

thnx for the answers

another question here, which one is better in terms of performance

ie subquery or left outer join

i have read subqueries are slow but in this case left...

thanks for the query , this one seems to work nicely

i like the idea , but isnt it same as the corelated subqueries ??

we cannot use the views as we are not dealing directly with the data and jus makin...