there are three tabs in the spreadsheet....all have data

pls can you clarify further.

snap 🙂

Maxer (1/30/2012)

---

That will just return zero rows from the table.

So in SSMS I would see column headers, but I couldn't actually copy/paste that result into say notepad.

I thought there was...

WHERE 1 = 0

..so what solution are you using?

/// edit .....still thinking 🙂

just an idea...not sure how efficient this would be on large data sets

select 201.83 - 201.83 % 0.05

select 159.98 - 159.98 % 0.05

any chance that you might provide some set up script and sample data for your two tables pls...we can then easily cut and paste into SSMS to give you a...

here's a current thread that you may have an interest in

http://www.sqlservercentral.com/Forums/Topic890290-148-1.aspx

assuming these files are all to be imported into the same SQL table...then I would agree that a standard format would make your life much easier...:-)

what was the response to...

for those of you who may be interested......formatted code ...(to the best of my ability!)

maybe the OP would care to check if anything has been missed.

WITH TNT

...

Hi

I dont know what SQL knowledge you already have....but from your question it would appear that you are not too sure about indexes and how/where to use them.

here is a...

does this help you..??

No doubt there are other methods.

use [tempdb]

Go

IF OBJECT_ID('tempdb..Tally', 'U') IS NOT NULL DROP TABLE tempdb..Tally ;

IF OBJECT_ID('tempdb..TableA', 'U') IS NOT NULL...

jbhatt2 (1/27/2012)

---

Thanks for the replies all..

But I'm not quite getting round to what I require.. basically I have a Table A, Table B as example below and Table C should...

any good...??

USE [tempdb]

GO

--- Look up "Tally Table.....http://www.sqlservercentral.com/articles/T-SQL/62867/ by Jeff Moden

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestData]') AND type in (N'U'))

DROP TABLE [dbo].[TestData]

GO

CREATE TABLE [dbo].[TestData](

[ID] [int]...