logo
down
shadow

How to link the output of teradata sql query to an excel sheet?


How to link the output of teradata sql query to an excel sheet?

Content Index :


Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Unable to connect to Teradata from excel using VBA code - Teradata Server can't be reached over the network


Tag : vba , By : Schmidt
Date : March 29 2020, 07:55 AM
Any of those help What if you change the Connection object's Open method:
conn.Open "DSN=dsnname;Databasename=dbname;Uid=Userid;Pwd=****;"

Tag : excel , By : Tamizhvendan
Date : March 29 2020, 07:55 AM
To fix the issue you can do You can simply read the dates from the spreadsheet into variables and format them. Then concatenate those variables with the URL.
Assuming your beginning date is in cell "A1" and your end date is in cell "A2".
Dim fromDate As String
Dim toDate As String

fromDate = Format(Range("a1").Value, "dd/mm/yyyy")
toDate = Format(Range("a2").Value, "dd/mm/yyyy")


Workbooks.Open Filename:= _
"http://Serverlink/ReportServer?%2fFinance%2fReportname&rs:Command=Render&FromDate=" & fromDate & "&ToDate=" & toDate & "&rs:Format=Excel"

Use Perl to select multiple query output data from SQL database and place into single Excel sheet


Tag : database , By : hellboy32
Date : March 29 2020, 07:55 AM
I wish did fix the issue. If that is your code, then it will be throwing errors complaining about $col1 and $col2 needing an "explicit package name".
This means that you haven't declared the variables correctly. You declare variables using the keyword my. But my declares the variables within a block of code. So when you write this:
foreach my $ln (@$sth1) {
  my($col1, $col2) = @$ln;
  print "$col1 $col2\n";
}
$worksheet->write( "A1", "$col1" );
$worksheet->write( "A2", "$col2" );
my ($col1, $col2);
foreach my $ln (@$sth1) {
  ($col1, $col2) = @$ln;
  print "$col1 $col2\n";
}

export result into excel sheet from teradata sql assistant


Tag : development , By : billputer
Date : March 29 2020, 07:55 AM

Carriage return issues when export the results into excel sheet by running the query in Teradata SQL Assistant


Tag : development , By : Pierre LeBoo
Date : March 29 2020, 07:55 AM
To fix the issue you can do In SQL Assistant Options there is an Flag where you can instruct SQL Assistant to remove all CR/LF from Exports. I think it's easier than RegExp in SQL. ;)
(SQL Assistant) -> Tools -> Options -> Export -> "Replace Carriage Returns in column data with blanks"
Related Posts Related QUESTIONS :
  • Oracle Unique Indexes
  • Spooling data to CSV truncates
  • How do views reduce code duplication?
  • SQL: Gather right hand values from a join
  • SQL Agent Logon - What is going on?
  • How do I combine two rows of same part, but add quantities?
  • How to optimize this SQL query for a rectangular region?
  • Pass data from ssrs subreport to parent
  • how to enter values in rowguid column?
  • Read multiple tables from dataset in Powershell
  • In SQL how to I exclude a record if there are more than 3 characters after a dash
  • What is the difference between check and foreign key?
  • How to return a record from function, executed by INSERT/UPDATE rule (trigger)?
  • SQL order by oldest from Unix Timestamps
  • How to convert decode function in oracle to standard big query
  • Postgresql: An alternative to subqueries to make the query more efficient?
  • Use returned values from a query in the same procedure
  • Sum all numeric columns in database and log results
  • Release item in current year
  • Conditional function not working as intended postgresql
  • SQL trigger, results not Grouped by
  • getting more records than expected with simple query in postgresql
  • get first occurrence of a certain combination of columns
  • Converting string timestamp to local-time zone in Oracle
  • Redshift - Filter out rows that are blank to left or right of a character
  • Teradata - Know the load volume by times of a table
  • How do I replace duplicate data with random data of same length in SQL
  • How to group by using pivot table
  • How can I achieve a Join for merging two tables FULL OUTER JOIN and avoid duplicates?
  • Multi Keyword search on multi-column sql
  • Computing the median of salaries under each manager in BigQuery SQL
  • How can insert value by selecting from another
  • Retrieving only the latest item for a set of data
  • update column with concatenating for that group only
  • SQL `SELECT 'some string value' AS fieldname` equivalent in Powershell?
  • How to determine the AVERAGE number of associated records
  • In Django, how can I build a set of criteria from a list?
  • Using replace() inside a loop
  • select user on create view
  • Calculate and aggregate column depending on a value in another colum (SQL)
  • Trigger to track all the insert or update on Oracle Table
  • Update column - remove first and last characters
  • T-SQL - Adding FK to table, make it do drop/null/efault automagically?
  • Get constraints and indexes on materialized views
  • SQL perform AVG after MAX
  • How do you join two tables A and B in order to get a non join column in A with data not in B?
  • Move Non-NULL Values Up Within Partition
  • Selecting rows based on two many-to-many relations
  • I have a table on which i want to do some advance calculation and get the table in a new shape
  • How to convert decimal to time in Oracle SQL?
  • Combine numbers to 1 row
  • Error: column does not exist when in fact it does? why?
  • How to fix: "Operation must use an updateable query" on update statement in Access VBA
  • Does information passes to a new table via CREATE TABLE update itself?
  • How to write a SQL statement which filters between two dates/times, with the date and time in separate columns
  • MS-Access-2016 Query Language 'ORDER BY' Clause
  • How to get totals for each age category?
  • get the first n characters of getdate()
  • Query to handle the dates
  • SQL grouping/counting on a string split function
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com