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...
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...
I've two tables
Item5Item ETable -B
Item AItem aa...
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...
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
Separate names with a comma.