No announcements
Found 968188 threads
-
1 Votescounting number of rows satisfying certain conditions
Set up a table of your condition combinations in a two column table, then in the third column use a formula.Answered | 3 Replies | 4892 Views | Created by rjagathe - Thursday, December 9, 2010 5:16 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, December 9, 2010 6:44 PM
-
0 Votes
Conditional Split using row counts
You'll need another task, an SQL task will do, to get the row count of the destination table.Answered | 1 Replies | 1965 Views | Created by rockstar283 - Wednesday, December 11, 2013 11:02 PM | Last reply by Jim Young (Level6 Productions) - Thursday, December 12, 2013 1:26 AM -
0 Votes
SSIS Row Count with Condition
and update each rows on product_id.?Answered | 9 Replies | 6388 Views | Created by myworld343 - Thursday, October 4, 2012 6:00 PM | Last reply by btsbee - Friday, October 5, 2012 3:33 PM -
0 Votes
Counting the number of rows
The query plan won't show any expanding as result of COUNT(*).Answered | 8 Replies | 1526 Views | Created by ctrln - Thursday, May 9, 2013 2:37 PM | Last reply by Gert-Jan Strik - Thursday, May 9, 2013 7:23 PM -
0 Votes
Count the number of rows on a database
ExecuteReader will return a SET of results - for example: a complete row.Answered | 7 Replies | 11143 Views | Created by hjjuuuuuuuu - Tuesday, October 12, 2010 11:13 AM | Last reply by Robab Hosseini Nasab Mehrabani - Sunday, November 28, 2010 10:04 AM -
2 Votes
Count number of rows appended
Thank you Olaf, Yes the logic is correct, Minus after with before will always result in a number greater than 0 therefore I will not need lnRowa = ...Answered | 6 Replies | 1099 Views | Created by mikelvfp - Tuesday, November 25, 2014 6:23 AM | Last reply by mikelvfp - Tuesday, November 25, 2014 11:38 PM -
2 Votes
Measure Count Rows - If Condition - Multiple Tables
The solution I initially came up with was to count the overall total number of calls, then subtract the objectives that were met.Answered | 12 Replies | 2129 Views | Created by bvanscoy678 - Friday, November 7, 2014 7:04 PM | Last reply by Michael Amadi - Wednesday, June 3, 2015 12:37 PM -
0 Votes
Condition failed rows count
I am getting all rows with NULL values.Answered | 8 Replies | 861 Views | Created by AngaraKiran - Friday, July 3, 2015 10:01 AM | Last reply by Manu Kapoor - Monday, July 6, 2015 5:23 AM -
0 Votes
How to count number of rows
CURRENT_TIMESTAMP For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 4 Replies | 2800 Views | Created by suresht - Thursday, February 23, 2012 1:22 AM | Last reply by suresht - Thursday, February 23, 2012 12:54 PM -
0 Votes
Need help to form a table satisfying certain criteria
No need to insert rows into a table: SELECT D1.Lname, D1.EmpID, D1.udds, D1.amount, D1.fund, D1.new_udds FROM Data AS D1 INNER ...Answered | 13 Replies | 526 Views | Created by ExcelUser2507 - Friday, February 13, 2015 7:21 PM | Last reply by QA Guy CommElec - Tuesday, February 17, 2015 2:27 AM -
0 Votes
Counting Conditions
Do you know - can point to some blog explaining why sum(case when Condition then 1 else 0 end) performs worse than count (case when Condition then 1 ...Answered | 8 Replies | 2711 Views | Created by imdandman - Wednesday, October 26, 2011 3:19 AM | Last reply by Naomi N - Wednesday, October 26, 2011 2:43 PM -
1 Votes
how to count number of rows in table ??
Use Count property.Answered | 1 Replies | 2052 Views | Created by SSmadhu - Thursday, August 2, 2012 5:57 AM | Last reply by Adavesh - Thursday, August 2, 2012 6:05 AM -
0 Votes
window function to count number of rows in the previous 24hours?
yes, the problem, we cant do a "conditional" running total like: sum(case when datediff(day,Currentrow.TimeStamp, Parentrow.timestamp)Answered | 6 Replies | 1557 Views | Created by Willgart1 - Monday, November 16, 2015 8:33 PM | Last reply by Willgart1 - Tuesday, November 17, 2015 1:25 PM -
0 Votes
[SOLVED] How do I update the first row that satisfies a condition and then exit?
If anyone knows the PHP to explode the number on it's own and then the string that comes after, I'm all ears.Answered | 3 Replies | 5799 Views | Created by kevin-berry - Tuesday, May 31, 2011 12:09 AM | Last reply by kevin-berry - Thursday, June 2, 2011 7:56 AM -
1 Votes
Count with Condition
0 THEN 1 ELSE 0 END)' gives the number of rows when Invoice_Due>0 for every CustomerID and name.Answered | 4 Replies | 4513 Views | Created by Sumanfbc - Saturday, November 20, 2010 8:21 AM | Last reply by Sumanfbc - Saturday, November 20, 2010 9:51 AM -
0 Votes
Row count
It requires a SSIS integer variable to be created and mapped which will store the count value.Answered | 3 Replies | 967 Views | Created by AmyBI - Tuesday, December 4, 2018 7:35 PM | Last reply by Visakh16 - Wednesday, December 5, 2018 11:02 AM -
0 Votes
Counting number of records with bulk insert and reading the first position in every row
Assuming that each record ends with CRLF, we just need to count number of CRLF in the flat file.Answered | 3 Replies | 4026 Views | Created by srnadimpall - Tuesday, September 27, 2011 5:31 PM | Last reply by Naomi N - Tuesday, October 4, 2011 1:06 AM -
0 Votes
Formula field issue (Trying to count the number of rows using a condition)
Below are a list of fields that make up each row of the report: Process name, Start date, Expected end date, ...Answered | 4 Replies | 3450 Views | Created by Adam859 - Thursday, August 7, 2008 3:35 PM | Last reply by Adam859 - Thursday, August 7, 2008 6:11 PM -
8 Votes
COUNT OF ROWS
I just need one row.Answered | 9 Replies | 1712 Views | Created by susheel1347 - Friday, March 7, 2014 3:55 PM | Last reply by Murali dhar - Monday, March 10, 2014 12:20 AM -
0 Votes
Load estimated row count
Hi Experts, Am trying to find a way to view the estimated row count for an update statement inside of a stored procedure before actual execution.Answered | 3 Replies | 1356 Views | Created by Priya Bange - Sunday, June 16, 2019 6:19 AM | Last reply by pituach - Sunday, June 16, 2019 10:56 AM - Items 1 to 20 of 968188 Next ›
No announcements
