Questions tagged [rowcount]
405 questions
4
votes
1 answer
Unable to use rowcount and conditional split in same data flow task
In SSIS,I want to split the data after lookup based on whether any no match record is found or not .IF no match record has atleast 1 row or count it should process certain action. I used row count and then conditional split for the same i..e used…
cheers519
- 445
- 6
- 18
4
votes
1 answer
Why PRINT affects @@rowcount
I recently noticed that while trying to loop through the rows of a table my loop wouldn't run based on if I had a PRINT statement before the the loop condition involving @@ROWCOUNT.
declare @s int;
select top 1 @s=sequence from myTable order by…
Archmede
- 1,592
- 2
- 20
- 37
4
votes
1 answer
execute query on sqlserver using spark sql
I am trying to get the row count and column count of all the tables in a schema in sql server using spark sql.
when I execute below query using sqoop, it's giving me the correct results.
sqoop eval --connect…
Mounika
- 43
- 1
- 5
4
votes
1 answer
SSRS Report Table Add Column Expression Record x of y?
I have an SSRS, which is compiled of report tables, each tied to a stored procedure, all keying off the same ID. I pass the ID automatically, through the UI.
Because there is so much information in the report, For each section, I wanted to add a…
missscripty
- 529
- 2
- 11
- 30
4
votes
2 answers
Row count MySQL with three tables
My MySQL DB looks like this
**table_schools**
id | name
1 | school_1
2 | school_2
**table_classes**
id | class | school_id
1 | a | 1
2 | b | 1
3 | c | 2
4 | d | 2
5 | e | 2
**table_students**
id | name | class_id
1 |…
Bundy
- 311
- 7
- 25
4
votes
2 answers
Getting the ROWCOUNT value (not @@ROWCOUNT) in SQL
Is there a way to see what ROWCOUNT is set to?
The component that is used to call my stored procedure has an option to limit how many rows are returned, but it apparently does that by setting ROWCOUNT. One stored procedure only returns a single…
user165502
- 41
- 1
- 2
4
votes
2 answers
How to get source file rowcount in data flow task SSIS?
I have a data flow task which contain excel file as the source and script component as the destination.
Is there a way to get the number of rows in my excel file and pass it my script component?
I already tried with Row count component but its value…
Santosh
- 101
- 1
- 2
- 10
4
votes
2 answers
How can I define the number of rows on cfspreadsheet object?
I am in the process of learning ColdFusion and I am trying to work with spreadsheets using spreadsheetFormatRows(spreadsheetObject, dataFormat, rangeOfRowsFormated)
How can I set the range to include all of the rows, except the header row, which is…
DoArNa
- 491
- 2
- 9
- 29
4
votes
1 answer
How to get the count of rows
I want to get the count of rows from last query.
I have used size() and numRowsAffected() functions, but none of them work.
I have written the following code:
int counter = 0;
QStringList TableHeader;
QSqlQuery qry;
qry.prepare("SELECT *,…
Lion King
- 32,851
- 25
- 81
- 143
4
votes
5 answers
Measuring Progress of SSIS Data Flow
I am running a SSIS package to load say a million rows from a flat file, which uses a script task for complex transformations and a SQL Server table destination. I am trying to figure out the best way (well, ANY way at this stage) to write out to a…
Glenn M
- 455
- 2
- 8
- 16
4
votes
3 answers
Count updated records in a "complex" t-SQL statement
I have the following SQL Server 2008 table:
CREATE TABLE tbl (ID INT, dtIn DATETIME2, dtOut DATETIME2, Type INT, nID INT)
INSERT tbl VALUES
(1, '05:00', '10:00', 1, 1), --will be changed
(2, '08:00', '16:00', 2, 1),
(3, '02:00', '08:00', 1, 1), …
ahmd0
- 16,633
- 33
- 137
- 233
4
votes
2 answers
PHP PDO bug when trying to parameterize SQL LIMIT :offset, :display?
This query returns 5 results in phpMyAdmin:
SELECT * FROM tbl_product WHERE 1 ORDER BY last_update DESC LIMIT 0,5
And this returns count=12 in phpMyAdmin (which is fine, because there are 12 records):
SELECT COUNT(*) AS count FROM tbl_product WHERE…
Ozzy
- 8,244
- 7
- 55
- 95
3
votes
2 answers
Dynamic Visible Row Count In JList
I have JList that grows in size along with the JFrame. I have the following code:
defaultListModel = new DefaultListModel();
for (String string: listOfStrings) {
defaultListModel.addElement(string);
}
jList = new…
Ahamed
- 39,245
- 13
- 40
- 68
3
votes
2 answers
Get Row Count in MultiPage Gridview?
when i try to do the following:
lblTotal.text = gwGrid.rows.count()
i always get 50, which is the size of my page. how can i get the count of ALL records returned, not just the ones displayed on that one page?
i also tried the Selected event on my…
Madam Zu Zu
- 6,437
- 19
- 83
- 129
3
votes
2 answers
How to get number of rows affected by a statement when inside that statement's trigger
I have a statement level trigger that fires whenever INSERT UPDATE or DELETE operations are performed on a table (called customers). I want to display a message (to DBMS_OUTPUT) containing the number of rows that were inserted/updated/deleted.
I…
dav83
- 312
- 1
- 2
- 15