Search Results | SQL Server Performance Forums

Connecting to excel from x64 SQL 2005

Thread by: srik316, Sep 29, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

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...

Parallelism (Gather Streams)

Post by: srik316, Aug 6, 2008 in forum: SQL Server 2005 General DBA Questions

Thanks for the reply... just after posting the msg I noticed that I noticed that I missed the group by clause. BTW what does Parallelism(gather...

Parallelism (Gather Streams)

Thread by: srik316, Aug 6, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

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...

Connecting to oracle from SQL Server...

Post by: srik316, Aug 5, 2008 in forum: SQL Server 2005 General DBA Questions

This problem is fixed... Oracle 10.2 is backward compatible to Oracle 8. We used a 64 bit Oracle 10.2 client and configured the tnsnames.ora to point...

Parent - child datas...

Post by: srik316, Aug 3, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks everyone for your help... am going with CTE...

Connecting to oracle from SQL Server...

Post by: srik316, Aug 3, 2008 in forum: SQL Server 2005 General DBA Questions

hi moh_hasan, I've passed your fix to my DBA. I'm yet to get any updates from him. I'll defly keep you all posted once he gets back (hopefully next...

Parent - child datas...

Post by: srik316, Jul 29, 2008 in forum: SQL Server 2005 General Developer Questions

Looping means usage of cursors? or using a table variable with an identity colum. Am still confsed with the logic with which I can acheive this.

Parent - child datas...

Post by: srik316, Jul 29, 2008 in forum: SQL Server 2005 General Developer Questions

Hi Adriaan, Thanks a lot fot your prompt response. But this wont give the result which I'm expecting. The parent-child data relationship might go on...

Parent - child datas...

Thread by: srik316, Jul 29, 2008, 7 replies, in forum: SQL Server 2005 General Developer Questions

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...

Connecting to oracle from SQL Server...

Post by: srik316, Jul 20, 2008 in forum: SQL Server 2005 General DBA Questions

Yes... He installed the oracle client. But it didnt work

Connecting to oracle from SQL Server...

Post by: srik316, Jul 20, 2008 in forum: SQL Server 2005 General DBA Questions

Any other way? I doubt if we will be able to use third party drivers...

Connecting to oracle from SQL Server...

Thread by: srik316, Jul 20, 2008, 9 replies, in forum: SQL Server 2005 General DBA Questions

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...

Max of a decimal string

Post by: srik316, Jul 20, 2008 in forum: SQL Server 2005 General DBA Questions

Thanks a lot!!!

Max of a decimal string

Post by: srik316, Jul 18, 2008 in forum: SQL Server 2005 General DBA Questions

It should be 2.20

Max of a decimal string

Post by: srik316, Jul 17, 2008 in forum: SQL Server 2005 General DBA Questions

This should not be considered as a normal decimal value... The value after the '.' should also be considered as a number. Out of the values i've...

Max of a decimal string

Post by: srik316, Jul 17, 2008 in forum: SQL Server 2005 General DBA Questions

Hi Dinakar, Thanks for the reply... But are you sure if this will work? Consider the table test with column 'issue' of varchar and having the...

Max of a decimal string

Thread by: srik316, Jul 17, 2008, 10 replies, in forum: SQL Server 2005 General DBA Questions

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,...

Max of a decimal string

Thread by: srik316, Jul 17, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

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,...