![]() |
|
![]() |
|
![]() |
Hai, i want to insert value to identity column, is there syntax like SET IDENTITY_INSERT ON | OFF ------- SQL SERVER This is for migrating data from table1 to table2, both of tables have identity column ? Thanks.
22 Feb 2016
| 1 comment
,
|
![]() |
Hi guys,
18 Nov 2015
| 1 comment
,
|
![]() |
Hi All,
08 Nov 2015
,
|
![]() |
My data looks something like this:
14 Oct 2015
| 7 comments
,
|
![]() |
Hi.
06 Oct 2015
| 2 comments
,
|
![]() |
There is "poetic query" that takes forever to run
16 Sep 2015
| 2 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.11.
10 Sep 2015
| 5 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.10.
30 Mar 2015
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.01.
27 Jan 2015
,
|
![]() |
Hi,
28 Dec 2014
| 3 comments
,
|
![]() |
Hello there,
19 Dec 2014
,
|
![]() |
Hello,
04 Dec 2014
| 3 comments
,
|
![]() |
Hello All !
17 Nov 2014
| 28 comments
,
|
![]() |
Hi,
17 Jul 2014
| 3 comments
,
|
![]() |
Hi Guys,
09 Jul 2014
| 2 comments
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 15.0.
14 Apr 2014
| 67 comments
,
|
![]() |
I have a small database to keep track of weekly scores. Each participant can have 2 or more scores each week. Some players don't play every week and have no scores for those weeks. I have the following tables:
10 Feb 2014
| 5 comments
,
|
![]() |
We have several queries that sometimes get stuck in response mode. Is there a way to real time see what the queryid is of a query that is currently in response mode? Using the following:
06 Nov 2013
| 2 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio.
13 Sep 2013
| 3 comments
,
|
![]() |
How do I combine multiple Select queries? I have 7 queries run separately. Each query return 2 columns. Count(of something), (date) Date Range is Fixed for each query Set to 1 Week only.
15 Aug 2013
| 10 comments
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 14.10, and highlight some existing but lesser known features. This article assumes that you are already familiar with the features in SQL Assistant 14.01. If not, you may wish to read the following articles first:
09 Aug 2013
| 15 comments
,
|
![]() |
Hello,
03 Jun 2013
,
|
![]() |
I am building a query to show VendorID, Check#, and CheckDate
13 May 2013
| 1 comment
,
|
![]() |
I've run into an issue with a rollup I am trying to do and was wondering if anyone has any ideas on how to do it in as few steps as possible.
24 Jan 2013
,
|
![]() |
Hi, can anyone tell me how to check the progress of my SQL Query? I've looked around on viewpoint but the best I get to is to check wheter or not is running or if there is a CPU skew. The hep told me to click on session in the query monitor, but that's not doing anything. Anyone?
27 Sep 2012
,
|
![]() |
Hello,
I have to analyze some really complex queries. I would like to have a general overview of the whole process which contains about 15 sql scripts. It would be a tremendeous help if I could find some software that could helm me do that.
26 Jul 2012
,
|
![]() |
Hello,
I have to analyze some really complex queries. I would like to have a general overview of the whole process which contains about 15 sql scripts. It would be a tremendeous help if I could find some software that could helm me do that.
26 Jul 2012
,
|
![]() |
dear all, below is my query and the explain. any suggestion on how to tune the query..thx for your time. -----------------------------------------------------------------------------------------
18 Jul 2012
| 3 comments
,
|
![]() |
09 Jul 2012
| 8 comments
,
|
![]() |
I want to Update and Insert when a condition in the case was true. However, it seems that Teradata doesn't accept it. My question is, is there a way for that to happen? Like
CASE WHEN SEL Table1.Column return TRUE THEN UPDATE Table2 AND INSERT Table3 ELSE INSERT Table2 AND INSERT Table3 END
15 Feb 2012
| 6 comments
,
|
![]() |
Hello Masters, I am dealing following case right now. When a query is run 4 times in matter of 'half a minute' I got four different elapsed times, variation between these times are ranging from 2 sec to 6 sec. And I do not think there is any change in amount of load being put on the box during that half a minute.
03 Feb 2012
| 2 comments
,
|
![]() |
It was a complex Business Objects report with some > 30 joins and instead of coming up with some sort of Join Index recommendation I Wiz is asking me to drop a bunch of NUSI's that are'nt getting used and says it will improve the system performance 15%.
06 Nov 2011
| 3 comments
,
|
![]() |
Teradata is pleased to announce the official release of Teradata Viewpoint 13.12 effective August 26th, 2011.
26 Aug 2011
| 9 comments
,
|
![]() |
Hello, I have an issue regarding a group by for my query: Error 3540 I understand what it means on a basic level and I believe the issue revolves around this particular column CAST((COALESCE(price, 0.000000)) AS DECIMAL(18,6)) * quantity amount
14 Jul 2011
| 1 comment
,
|
![]() |
I have a table that is a list of users that I need get as a heirachal answer set. This table has people from 1st level, 2nd level, and 3rd level in the organizations heirarchy all built the same way..i.e. user_id first_name last_name supervisor_id My problem is that supervisors are built the same way, where the supervisor_id is actually a 2nd line manager. What I need to do is retrieve users by specifying the 3rd level (second line manager) , and list it as such: user_id first_name last_name supervisor_id second_line_manager
12 May 2011
| 1 comment
,
|
![]() |
Hi, I was running a complicated query using Teradata installed on my local laptop. But my laptop went to stand-by mode as it was closed. So, I had to re-boot my laptop. I have been running the teradata query for the last 8 hours and feel frustrated. Is there a way to recover whatever was done by the query and re-start from where it crashed?
05 May 2011
| 3 comments
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 13.11. The focus of this release is on usability and Section 508 conformance. This article assumes that you are already familiar with the features in SQL Assistant 13.10 Edition 2. If not, you may wish to read the following articles first:
18 Mar 2011
| 11 comments
,
|
![]() |
I have data in Apps Table as: (app_id,store_id,mail_id) How could I obtain the output in this format: (app_id,store_id,mail_id)
07 Feb 2011
| 1 comment
,
|
![]() |
Hi I have a few Decimal, Character and Integer columns in my table. How may I write a query in Teradata to get the maximum permissible characters/digits in each of those columns? Please help this newbie. Thanks and regards
28 Dec 2010
| 2 comments
,
|
![]() |
I am using Teradata SQL Assistant 12. I have an sql query consisting of 26 steps - 13 create table select statements with a drop table statement before each. Sometimes, but not always, when I execute the query it will run the first 3 steps and stop. It does not error, nor does it tell me it did not execute the entire code.
17 Dec 2010
| 2 comments
,
|
![]() |
Teradata is pleased to announce the official release of Teradata Viewpoint 13.11 effective December 17th, 2010. The fourth release of Viewpoint in 2010!
17 Dec 2010
| 83 comments
,
|
![]() |
I need some help with creating a SQL query. I have 3 tables Table1 (ID1, ID2, dataValue1) , Table2 (ID1, ID2, dataValue2), Table3 (ID1, ID2, datavalue3)
22 Sep 2010
| 2 comments
,
|
![]() |
This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10 Edition 2. The focus of this release is on usability and performance. Please see What’s new in Teradata SQL Assistant 13.10 for details of the new features that were added to the original 13.10 release.
28 Jul 2010
| 38 comments
,
|
![]() |
Hi people...i am sorry if i am posting this in the wrong forum, but please bear with me... Thanks in advance!!
20 May 2010
| 2 comments
,
|
![]() |
Hi All, I need to create a teradata query. I have a table name ABC.In that table i have a column student id, course id, course name, assigned date and completion date Eg: IDN STUDENT_ID Course_Id Course_Name Assigned_date Com_date
13 May 2010
| 1 comment
,
|
![]() |
I have a pretty complex query that pulls the following "Insured IDs" from a table specified in the coalesce statement. The problem is that there are duplicate records with the exception of two letters in a string. I want to be able to only bring in the record with the "RT" In the string. I realize i might have to use a substring of sorts to accomplish this as well as a subquery? Perhaps an IF statement? This is what the data looks like: 42078 00561070 610000000 06042129 Smith Joe 00561000000000000EE19470123F
12 May 2010
| 5 comments
,
|
![]() |
This is the second in the series of blogs regarding cool features and tidbits within Teradata Viewpoint. Today's discussion is going to focus on SQL Scratchpad, a new Self Service portlet released with Viewpoint 13.0.1 in June 2009.
09 Oct 2009
,
|