No announcements
Found 2154496 threads
-
0 VotesTrigger to compare record counts in 2 tables
If ( (select count(*) from dbo.sales)<> (select count(*) from dbo.sales2) ) Begin print 'not equal' End else Begin print ' ...Answered | 3 Replies | 802 Views | Created by DanHaf - Wednesday, November 12, 2014 3:04 PM | Last reply by DanHaf - Wednesday, November 12, 2014 4:38 PM
-
0 Votes
sql count record problem
Please clarify: it sounds like you are asking how to optimize a Sybase query on a SQL Server forum.Answered | 7 Replies | 7399 Views | Created by --_-- - Tuesday, October 5, 2010 2:21 AM | Last reply by Dan Benediktson - Friday, October 8, 2010 4:43 PM -
0 Votes
Getting 2 Variables divided
Hi, Like Bryan Shaw suggested , try like below code example to avoid divide by zero error : DECLARE @Insert_Satellite TABLE (p_InfoRate FLOAT,p_FecCode ...Answered | 4 Replies | 1139 Views | Created by ThomasYaris30 - Thursday, August 15, 2013 10:51 AM | Last reply by SathyanarrayananS - Thursday, August 15, 2013 4:23 PM -
1 Votes
count(records)
If we do count on this it wont give correct results.Answered | 5 Replies | 2746 Views | Created by Sandra VO - Wednesday, June 20, 2012 10:55 PM | Last reply by Eshani Rao - Friday, June 22, 2012 2:07 AM -
0 Votes
Divide Count totals from two queries
You either need to include the MemberNo column in the outer query's SELECT clause if you want the results per member, or you need to remove the MemberNo column and GROUP BY clause ...Answered | 2 Replies | 699 Views | Created by John Reddrick - Wednesday, December 30, 2015 6:56 PM | Last reply by Ken Sheridan - Thursday, December 31, 2015 12:16 AM -
1 Votes
record count from flat file
Seems like it is not reading records from flat file.Answered | 8 Replies | 18031 Views | Created by Shalin83 - Friday, July 29, 2011 3:30 AM | Last reply by SSISJoost - Monday, August 1, 2011 7:10 PM -
1 Votes
Compare record to record in a large very large table after dividing the table to a large number of bins
Sounds like the count is just a group by bin, value, unless there is some additional qualification between adjacent records.Answered | 2 Replies | 2674 Views | Created by izzahmu - Friday, July 27, 2012 5:41 PM | Last reply by JRStern - Friday, July 27, 2012 6:51 PM -
0 Votes
SQL - Dividing the Count of 2 records
User-818134166 posted Try this: Select tot1/tot2 from (Select Count([1]) ...Answered | 3 Replies | 3512 Views | Created by Anonymous - Tuesday, August 24, 2010 9:30 AM | Last reply by Anonymous - Wednesday, August 25, 2010 1:39 AM -
1 Votes
sql server record count in visual basic
For example by issuing a SQL COUNT(*) statement against the database and use the SqlCommand.ExecuteScalar method as described on MSDN here:Answered | 1 Replies | 3342 Views | Created by sirMilt - Wednesday, December 17, 2014 4:29 PM | Last reply by Magnus (MM8) - Wednesday, December 17, 2014 4:37 PM -
3 Votes
count similar records
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: ...Answered | 3 Replies | 1010 Views | Created by zak_kapoor - Thursday, October 1, 2015 1:57 PM | Last reply by Itz Shailesh - Thursday, October 1, 2015 2:49 PM -
0 Votes
SSIS logging - recording record count from SQL task?
You can use the @@ROWCOUNT to check how many records where updated/deleted/inserted in an Execute SQL Task.Answered | 5 Replies | 12949 Views | Created by shiftbit - Monday, October 14, 2013 4:35 PM | Last reply by SSISJoost - Monday, October 21, 2013 2:34 PM -
0 Votes
How to count same record in a table
2 or just > 1 ?Answered | 5 Replies | 1026 Views | Created by thanh phan 33 - Friday, October 24, 2014 6:57 AM | Last reply by cnk_gr - Friday, October 24, 2014 8:51 AM -
3 Votes
GROUP BY Based On Record Count
All I see is a grouping by type and changing the one record to have the count of rows.Answered | 6 Replies | 950 Views | Created by KuzeyI - Tuesday, November 7, 2017 10:34 PM | Last reply by KuzeyI - Wednesday, November 8, 2017 1:59 PM -
0 Votes
SQL Statement / Count & Percentage
SQL Server Compact has limited support for subqueries.Answered | 4 Replies | 3281 Views | Created by tropicwhisper - Wednesday, April 15, 2015 1:24 PM | Last reply by tropicwhisper - Friday, May 29, 2015 4:57 PM -
0 Votes
Record Count
You could use SELECT COUNT(*) AS TotalFROM code WHERE codeid = 'IMPORTDATA' AND code = 'SNMSA5'"; It will return just a count and it is ...Answered | 2 Replies | 3622 Views | Created by mark1110 - Tuesday, January 9, 2007 7:33 PM | Last reply by VMazur - Wednesday, January 10, 2007 11:26 AM -
0 Votes
SQL divide by zero error
The blog mentioned above is not accurate to this case, and there is nothing related to implicit convert while doing the actual dividing action.Answered | 3 Replies | 1212 Views | Created by jhowe1 - Sunday, October 25, 2015 6:55 PM | Last reply by pituach - Sunday, October 25, 2015 10:37 PM -
0 Votes
Count Duplicate Records
Have you tried to save your summary query in your database and run the DCount function against the saved summary query (not just the SQL)?Answered | 2 Replies | 4708 Views | Created by WoodyBZippin - Tuesday, January 18, 2011 9:00 PM | Last reply by Wolfgang Kais - Wednesday, January 19, 2011 1:10 AM -
1 Votes
Count Records
TotalCount; returns a page of records...Answered | 2 Replies | 3370 Views | Created by Andy Sid - Saturday, February 23, 2013 11:48 PM | Last reply by Venetasoft - Sunday, March 24, 2013 4:13 PM -
0 Votes
Record Count at multiple instances
Using built-in tooling, your options are: Use multiple Row Count components to "collect" the row counts inside each Data ...Answered | 2 Replies | 3447 Views | Created by gk1393 - Friday, August 26, 2011 2:34 PM | Last reply by Todd McDermid - Friday, August 26, 2011 5:39 PM -
0 Votes
Unmatch Records Count
select count(*) from Table1 where not exists (select 1 from Table2 where Table2.ID = Table1.ID) This query will give you a count of non-matching ...Answered | 3 Replies | 5204 Views | Created by Dileep sankar - Saturday, September 3, 2011 7:03 AM | Last reply by Naomi N - Sunday, September 4, 2011 6:11 AM - Items 1 to 20 of 2154496 Next ›
No announcements
