Viewing 15 posts - 2,041 through 2,055 (of 2,452 total)
there are three tabs in the spreadsheet....all have data
pls can you clarify further.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 9:56 am
snap 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 8:41 am
Maxer (1/30/2012)
So in SSMS I would see column headers, but I couldn't actually copy/paste that result into say notepad.
I thought there was...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 7:50 am
WHERE 1 = 0
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 7:42 am
andre-394971 (1/29/2012)
Yep..158.94 should give me 158.90
158.95 should give me 158.95
158.96 should give me 158.95
158.97 should give me 158.95 etc
Thanks
..so what solution are you using?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 29, 2012 at 1:53 pm
/// edit .....still thinking 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 29, 2012 at 1:29 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 29, 2012 at 1:21 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 29, 2012 at 12:43 pm
here's a current thread that you may have an interest in
http://www.sqlservercentral.com/Forums/Topic890290-148-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 28, 2012 at 9:28 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 28, 2012 at 8:57 am
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
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 28, 2012 at 6:20 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 28, 2012 at 1:17 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2012 at 3:34 pm
jbhatt2 (1/27/2012)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2012 at 10:16 am
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]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2012 at 7:50 am
Viewing 15 posts - 2,041 through 2,055 (of 2,452 total)