Viewing 15 posts - 1,276 through 1,290 (of 2,452 total)
glad to hear you have solved the problem,,,care to share so that others may learn?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2014 at 9:23 am
for clarification...based on your sample data provided....can you please post your expected results.
thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2014 at 2:48 am
G-Force (9/16/2014)
Hi JeffStill trying to find the dummies guide 🙂 . Is there anywhere you can point me to on how to do it in TSQL ?
Any help gratefully received.
Thanks
G
hi...these...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2014 at 10:14 am
whats the relationship between "Trade" table and "Platoon" table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2014 at 11:06 am
http://www.apexsql.com/sql_tools_refactor.aspx
see above link...its free, but requires you to set up your preferences....can be a bit awkward for fine tuning
I prefer Red Gate...but as freelance cant justify the cost
maybe be helpful....and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 4, 2014 at 1:02 pm
Smash125 (9/3/2014)
guys I searched in Teradata forums I did not get any concrete answers. Any sql pundits can tell me how it can be done
as I am sure...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2014 at 5:54 am
maybe something along these lines will get you started
SELECT
ACCT_ID
, ORD_DT
FROM yourtable
WHERE (DATEPART(q , ORD_DT) = DATEPART(q , GETDATE()))
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2014 at 3:03 am
phingers (9/2/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2014 at 2:47 pm
phingers (9/2/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2014 at 8:59 am
take a look at the windowing functions in 2012
something along these line may help you get started
SELECT
Month
, Year
, TotalRevenue
, Company
, Descr
, SUM(totalrevenue) OVER (PARTITION BY company ORDER BY...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2014 at 8:16 am
-- similar solution but with page numbers...may give you some ideas
-- test data
SELECT TOP 1000000
CodeID = 1 + CAST(Rand(Checksum(Newid())) * 100 AS INT)
INTO ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2014 at 7:04 am
Hi..how do you propose to determine the latest data for CaseID 542345...you show two rows with same opening date?
your spreadsheet displays an order that cannot be determined without another level...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 29, 2014 at 8:47 am
JackTimber (8/28/2014)
If i come up with a solution would...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2014 at 12:20 pm
JackTimber (8/28/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2014 at 11:28 am
JackTimber (8/28/2014)
I tried figuring out that , but 🙁
reading the previous thread...it seems that you have 20 million rows....
what solution did you finally decide upon...pls post that here ....and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2014 at 10:30 am
Viewing 15 posts - 1,276 through 1,290 (of 2,452 total)