Viewing 15 posts - 46 through 60 (of 246 total)
try joining the two tables on the field companycode.
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick...
July 9, 2009 at 1:03 am
Can you give the error that occurs when try to connect the server.
If you cant connect using instance name try using IP address.
See to that remote is enabled and tcp/ip...
July 9, 2009 at 12:51 am
SET @bcpCommand = 'bcp " select '''+ @expFile +'''" queryout "'
SET @bcpCommand = @bcpCommand + @exptionFile + '" -T -c'
EXEC master..xp_cmdshell @bcpCommand
i don't think you can use '+' along...
July 8, 2009 at 12:44 am
You should use
Provider : Microsoft.Jet.OLEDB.4.0
Provider String : excel 8.0
July 7, 2009 at 11:55 pm
I think there many limitations for using DECLARE @variable TABLE command in sql server 2000 and since mine is an 2000 server many people say its not advisable to use...
July 7, 2009 at 11:18 pm
Thanks for the reply
arun.sas (7/7/2009)
replace it to the declare tables in the procedures/Reports.ARUN SAS
can you give more details.........
July 7, 2009 at 10:33 pm
Hi
Is there any similar script that can be used in SQl server 2000.
July 7, 2009 at 8:32 pm
What is difference between Union all and merge in sql server?
Well both of them essentially takes outputs from more than one sources and combines them into a single result set...
July 3, 2009 at 4:41 am
Yes you have to add the "MYSERVER\INSTANCE2" as linked server to "MYSERVER\INSTANCE1"
SELECT * FROM [MYSERVER\INSTANCE2].Database.owner.tablename
July 3, 2009 at 4:22 am
Eswin (7/2/2009)
Why are you pulling my leg........Sorry Lynn had made a mistake............Thanks a lot for the help
Sorry Lynn , I had made a mistake........
Didn't mean to offend you.
Thanks a lot...
July 3, 2009 at 12:08 am
Viewing 15 posts - 46 through 60 (of 246 total)