|
I am trying to use a SQL Server 2008 Ranking Function on a query sorted by a derived column. Here's an example
SELECT table.FirstName, table.LastName, CalculatedValue(table.number) As Points, ROW_NUMBER() OVER (ORDER BY points) AS 'Row Number' FROM table...
Started by wrburgess on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
How about using a derived table (sub query)? I think something like the following should work.
|
|
Hello,
What the best way to check the column (in DerivedColum component) is NULL. If NULL => log error else continue with data flow.
Regards
Started by Nev_Rahd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Or you could try flowing into another derived column that uses values in the row to form an output to some log....
Flowing the derived column control into a condional split control elegant though.
This might help you partially.
|
|
I have an id column which is a primary key with AUTO_INCREMENT. I need the value that is generated to be inserted into the id column, as well as another column (which isn't set to AUTO_INCREMENT, and isnt unique.
Currently I use the mysqld_isnert_id()...
Started by Yegor on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
That contains the NEXT insert id.
Is generated, but you could try the following, since if it works it'll save you an update (If the column you 'tables', there you access the column auto_increment.
|
Ask your Facebook Friends
|
I have a table with a 'Wav' column that is of type 'VARBINARY(max)' (storing a wav file) and would like to be able to check if there is a wav from Linq to SQL.
My first approach was to do the following in Linq:
var result = from row in dc.Table select...
Started by bounav on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Somewhere else on stackoverflow: http://stackoverflow.com/questions/441869/create-a-computed-column [Wav] Is Null Then (1) Else (0) End)
Now I'll update my DBML to reflect that computed column.
|
|
This code using an OLEDB source will populate the OutputColumnCollection below it, the code using a flatfile source will not populate the OutputColumnCollection.
Why not? Microsoft.SqlServer.Dts.Runtime.Application a = new Microsoft.SqlServer.Dts.Runtime...
Started by Steve Schlichter on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Also you didn't include very much information in your post about what is going wrong... .
Check to make sure its not something simple like this first .
I have had issues using SSIS with flat files for input and sql output because the data types didn't match .
|
|
Is there a way in TSQL to do something like this:
select a,b,c, case when a=1 then 5 when a=2 then 6 end as d from some_table where d=6
The actual case statement is really complex, so I'm trying to avoid repeating it in the where clause? Are there any...
Started by Greg on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Another option is to implement your case.
This is a good place to use CTEs, there's no point in being able to reference a derived column.
There is no way to reference a derived column in the same query.
|
|
MySQL source
SQL Destination.
The source has some datetime values set to 0000-00-00 00:00:00 So I use a Derived Column to change them to Null.
I modify the same field, with this expression (DT_DBTIMESTAMP)(DAY(FechaHoraCorteAgente) == 0 ? NULL(DT_DBTIMESTAMP...
Answer Snippets (Read the full thread at microsoft):
You show the image of the inside of your derived column block? If you are using a replace column, you instead so an expression like this in the Derived Column Transformation must do the trick:
(DT_WSTR,50 at Data Flow....
|
|
I have a date column in csv file which has few empty rows and few rows like / /
i have written a derived colum expression to check for these and return null
but its not working
FINDSTRING(LTRIM(BuyerBirthDate)," / ",1) == 0 ? BuyerBirthDate : (DT_STR,...
Answer Snippets (Read the full thread at microsoft):
The expression was not valid....
Error at Data Flow Task [Derived Column [1101]]: Cannot parse the expression "FINDSTRING"]".
Studio
Error at Data Flow Task [Derived Column [1101]]: Attempt to parse the expression "FINDSTRING.
|
|
Hello,
I have a class that derives from ActiveRecord::Base. This class has a subclass that is differentiated in the database by a type id column. How do I make sure that all the inherited active record functions in the derived classes append the type_...
Started by Mattew on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That's why what Radar said about your column being.
What you are doing is called Single Table Inheritance (STI) .
If your column was called "type", ActiveRecord would do this automatically for you.
|
|
Can someone please guide on how to convert the excel formula =reporteddate/3600/24+DATE(1970,1,1) to a ssis 2008r2 derived column formula.
An example value for reporteddate would be 1328192834
Thanks in advance.
Answer Snippets (Read the full thread at microsoft):
Hi,
The reportdate you are having is unixtimestamp.use following expression in derived column.
|
