HiI want to retreive some data from excel. The constraint I've is I cannot use Integration Services. I'm planning to use linked Server/openrowset but...
Hi, I'm joining 2 tables (each with over 400000 records). The join is made on 4 columns. Its returning rows more than what am expecting. Each record...
Hi all, I've two tables Table -A ItemIdSubItem Item1Item A Item2Item B Item3Item C Item4Item D Item5Item ETable -B Parent ItemChildItem Item AItem aa...
Hi all, We are in a precarious situation where in we need to connect to oracle 8 from SQL Server 2005. We can acheive it using Linked server. But the...
Hi, I've a scenario where in I need to get the max of a decimal string Table - Test, column - issue, Datatype varchar(10) Issue has values like 1.0,...
Separate names with a comma.