No announcements
Found 3836079 threads
-
6 VotesFind Row Count in Table
how to find Row count of a table in sql server ? Check outAnswered | 6 Replies | 1482 Views | Created by CarlosVelaZen - Wednesday, December 24, 2014 1:50 AM | Last reply by Ahsan Kabir - Wednesday, December 24, 2014 11:00 PM
-
0 Votes
Get records count from table and store in Different table
below link and I just made some changes and it worked as ...Answered | 2 Replies | 512 Views | Created by -kit - Thursday, March 30, 2017 3:29 PM | Last reply by -kit - Thursday, March 30, 2017 4:59 PM -
0 Votes
Find partitions, row count of each partition of a partition table
Hi, We have a partition table in a database. The partition table name is 'STORE'. Can anyone provide me a query by which I can ...Answered | 2 Replies | 9997 Views | Created by arifulhaq - Thursday, January 12, 2017 7:06 AM | Last reply by Uri Dimant - Thursday, January 12, 2017 7:29 AM -
0 Votes
Data compression
In an already page compressed (or row compressed) table can I find out the not compressed data size? I looked into the function sys.dm_db_index_physical_stats ...Answered | 1 Replies | 3320 Views | Created by GV1973 - Friday, December 9, 2011 3:34 AM | Last reply by JRStern - Friday, December 9, 2011 6:38 AM -
3 Votes
Find first empty row in table?
count can grow. The column count is always fixed) Starting with row 1 of the table, I would like to search all rows in the ...Answered | 2 Replies | 9026 Views | Created by Robert Crandal - Sunday, March 6, 2011 4:12 AM | Last reply by Graham Mayor - Sunday, March 6, 2011 3:23 PM -
2 Votes
chance like finding
Hi, Check this ...Answered | 5 Replies | 2679 Views | Created by srinivas_oracle - Wednesday, September 21, 2011 10:29 AM | Last reply by Shkumar - Wednesday, September 21, 2011 11:51 AM -
0 Votes
Using CALCULATE() in exactly the same way I would use a COUNTIFS in Excel
]) and the date (SalesHeader[ShortDate]). What I am trying to do is count the number of times that customer has performed a transaction where the date is less than the one ...Answered | 3 Replies | 5099 Views | Created by barnettjacob - Thursday, December 29, 2011 4:43 AM | Last reply by Alberto Ferrari [SQLBI] - Friday, December 30, 2011 7:55 AM -
0 Votes
Display Table Row Count
being input to my table is being filtered in an IIF statment. So for example, if twelve rows are being returned in the dataset that is the input to my table I ...Answered | 3 Replies | 5813 Views | Created by Retired_Account - Sunday, August 17, 2008 5:23 PM | Last reply by Retired_Account - Monday, November 10, 2008 11:23 PM -
0 Votes
SQL 2014 AlwaysOn Group state Synchronized but table row count not equal
2 of them. The problem is that all the nodes are healthy and in "Syncrhonized" state but when i make a select count from one table, the primary node ...Answered | 3 Replies | 800 Views | Created by JustThatGuyFromIT - Wednesday, January 28, 2015 5:53 PM | Last reply by JustThatGuyFromIT - Thursday, February 5, 2015 12:55 PM -
0 Votes
SQL 2005 Transactional Replication without Primary Key...
(distinct ['+name from sys.columns where object_id=object_id(@tablename) and user_type_id not in (34,35,99) select @str='select '+ substring(@str,5,8000)+ ']), ...Answered | 2 Replies | 7550 Views | Created by Rajnish R Sharma - Wednesday, September 22, 2010 4:12 PM | Last reply by Rajnish R Sharma - Wednesday, September 22, 2010 5:41 PM -
0 Votes
Row Count Table Var
Hello, I have a table var in an sp (SQL 2005) that I need the row count from. I don't think I can goto the system as it is a table ...Answered | 3 Replies | 2269 Views | Created by zzpluralza - Friday, December 30, 2011 1:45 PM | Last reply by Naomi N - Friday, December 30, 2011 4:12 PM -
0 Votes
multi count from sql table
coloumns in the table, and im tryin to find some code / solution NOT TO USE primitive code like sending 10 times SELECT COUNT query to the server. How can i get 10 ...Answered | 2 Replies | 4 Views | Created by Anonymous - Friday, September 2, 2011 1:12 PM | Last reply by Anonymous - Tuesday, September 6, 2011 4:25 AM -
0 Votes
Table row count
Hi, In one of my SSRS 2008 reports I have a table called "table1" I want to do a row count and desplay it ...Answered | 3 Replies | 1421 Views | Created by runnerpaul - Tuesday, August 20, 2013 2:30 PM | Last reply by Alisa Tang - Wednesday, August 21, 2013 1:07 PM -
0 Votes
in this code add button is not working in first click after i click on the remove button in previous row or above row. but after that when i clicked on the add button in next row it doesnt work.next row is not creating ..what to do.whats the problem
); row.Cells.Add(cell2); table.Rows.Add(row); } SetPreviousData(rowsCount, colsCount, pass); ...Answered | 1 Replies | 12 Views | Created by Anonymous - Thursday, March 2, 2017 4:10 AM | Last reply by Anonymous - Monday, March 6, 2017 8:33 AM -
0 Votes
Row count from another table?
Is it possible to directly get the row count of a different table in a RS2005 report? I'd like to use this row count ...Answered | 1 Replies | 5165 Views | Created by carl__s - Thursday, March 15, 2007 2:46 PM | Last reply by carl__s - Friday, March 16, 2007 5:25 PM -
1 Votes
Tabular Metadata - DMV or .NET AnalysisServices.Tabular
} } } In SSMS, one can find the partition row count easily by right clicking on a ...Answered | 2 Replies | 901 Views | Created by DeuceOfAllTrades - Friday, August 30, 2019 3:15 PM | Last reply by DeuceOfAllTrades - Saturday, August 31, 2019 6:46 PM -
5 Votes
DAX expression to count values within a table
current row appears in the entire table. Basically what I am looking for is the PowerPivot equivalent to a COUNTIF ...Answered | 3 Replies | 36243 Views | Created by Barbara Raney - Friday, February 25, 2011 11:10 PM | Last reply by Barbara Raney - Monday, February 28, 2011 4:02 PM -
1 Votes
How to handle Insert/Delete Table Row user action in excel vsto?
I don't find event which handle insert/delete row of a table. I also recommend you use Worksheet.Change. You could use a global variable to record the table's cells ...Answered | 3 Replies | 1704 Views | Created by Suresh700 - Tuesday, June 6, 2017 10:31 AM | Last reply by Terry Xu - MSFT - Friday, June 9, 2017 5:55 AM -
0 Votes
dataset table row count
Newbie question! I have opened a dataset.table to step through the rows, to search for information on each row. What is the equivalent of dataset count to ...Answered | 3 Replies | 4187 Views | Created by GavinTrev - Friday, August 29, 2008 3:26 PM | Last reply by GavinTrev - Saturday, August 30, 2008 7:32 AM -
2 Votes
finding number of records in a table without count *
row number in each table without using count(*) from table, which table can help you to find count without using ...Answered | 6 Replies | 2790 Views | Created by cameron10001 - Saturday, March 22, 2014 11:09 AM | Last reply by CarnegieJ - Sunday, March 23, 2014 12:15 AM - Items 1 to 20 of 3836079 Next ›
No announcements
