Same .xlsx format only in both operation

Dinors,

When i select the excel file  the excel version is automatically changed to "Microsoft Excel 2007-2010"

Using Username and Password like SQL authentication..

Thanks for your reply... Additionally i want to know some information. Both Index will take some memory right? It will cause any performance issue?

Thanks Roshan...

Now i have found how it is created after discussing with development team... They have created table and index like below code....

CREATE TABLE...

Hi John,

I'm connecting SQL Server instance using IP(10.AA.AA.AA). But we don't have access for Node2 IP(10.YY.YY.YY).

When we ping using Node2 IP its throws "Request timed out" error.

Thanks lot Luis Cazares... Its working..

Thank you so much!!!

Thank u...

Hi Ed,

Thanks for your reply. In output sheet i'm not getting the first 4 digit zeros from Item_code. I need output with zeros.

i want output like below:

select name from sys.columns where object_ID=3 /* Query something like this */

Output :

ABCD

Hi Chetan,

Thank u. But Total_price and DatePurchased date showing wrong.

Hi This part shows error.

/*------------------------

SELECT *, SUM( Price ) OVER( Partition BY Customer_Name ORDER BY DatePurchased) AS Total_Till_Date

FROM #sample where Customer_Name='A'

------------------------*/

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'order'.

Hi,

Pls find the below details

Create table #sample(Customer_Name varchar(50),Goods varchar(50),

Price float,DatePurchased datetime)

insert into #sample

select 'A','Bat',250,'1/31/2014'

select 'A','Ball',250,'1/31/2014'

select 'B','Carrom',850,'2/2/2014'

select 'C','TennisBall',250,'2/1/2014'

select 'A','Bat',250,'2/2/2014'

select 'D','Bat',250,'1/31/2014'

select 'B','Bat',250,'1/31/2014'

select 'A','Bat',250,'2/4/2014'

select 'C','Chess',250,'2/4/2014'

select 'A','Bat',250,'2/4/2014'

select 'C','Chess',250,'2/4/2014'

Output Format:

Customer_Name Total_Price DatePurchased

A 1000 2/4/2014

B 1100 1/31/2014