#DateForumTypeThreadPost
626 Aug 2015 @ 07:58 PDTDatabaseTopicIs it possible to fine tune the following query that displays hourly count?Hi all, My apologies for asking someting like this. I have formed a query that goes back exact 7 days (referring column CRT_DTTM) and take count(*) for each hour for that day. As I have done i...
525 Aug 2015 @ 07:06 PDTDatabaseTopicIs it possible to improve Terada query to get min, max and avg from result?I have composed a Teradata (V 14.10.3.09) query with help from the forum and modified it a bit to get count(*) of past six weeks, for present hour and same day of week. For eaxample if current_tim...
424 Aug 2015 @ 09:17 PDTDatabaseReplyIs it possible to convert query written for SQL server to be run on Teradata?Final update: I finally found what I was missing. For syntax error, I had to define column list between "params" and "as" so something like  WITH params (w0s,w0e,w...
319 Aug 2015 @ 12:55 PDTDatabaseReplyIs it possible to convert query written for SQL server to be run on Teradata?I think I missed a syntax error earlier with the query and first qury had some error (as this was second query on screen of Teradata Studio, it didn't show error in this query). The error is&n...
219 Aug 2015 @ 08:45 PDTDatabaseReplyIs it possible to convert query written for SQL server to be run on Teradata?Hi dnoeth, Thank you for your response which will help me a lot. I think the query is working fine (as I don't see syntax error in Teradata Studio) but on running the query I get "No mor...
117 Aug 2015 @ 03:22 PDTDatabaseTopicIs it possible to convert query written for SQL server to be run on Teradata?Hi all, I had written a DB query to be run on SQL Server and the table structure was like: pkey Home_Telephone ID EDU_ID City State Zip Menu_Selection Account_Number Billing_System Prin FTA Nod...