No announcements
Found 3661790 threads
-
0 VotesFinding rows from two tables having a common column
Best option is to join the 2-tables with the common columns and fetch the results, like: SELECT T1.*, T2.Answered | 4 Replies | 1522 Views | Created by Prashant kumar lal - Thursday, May 16, 2013 11:02 AM | Last reply by KiranKumar.Y - Thursday, May 16, 2013 11:23 AM
-
0 Votes
Is there any issue if I have NULL values in most of the columns of a table
For null variable-width columns (varchar, varbinary, etc) values in most part of the cases it stores 2 bytes in the offset array.Answered | 3 Replies | 7351 Views | Created by Brijendra Pandey - Thursday, February 3, 2011 9:10 AM | Last reply by Dmitri Korotkevitch - Thursday, February 3, 2011 2:57 PM -
0 Votes
update a table with values from another table without a common key
In any case since you asked so here is another option: with MyCTE1 as (select top 5 rno, row_number() over (order by rdate desc) rn from t1 order by rdate ...Answered | 2 Replies | 696 Views | Created by ritasql - Sunday, March 22, 2015 9:06 AM | Last reply by pituach - Sunday, March 22, 2015 12:27 PM -
0 Votes
How to find columns having same value more than 10 times?
Mr.Latheesh ,Your First Query is not working while merging to tables can u give example for finding columns having same value more than 10 ...Answered | 4 Replies | 1308 Views | Created by Sasicumaar - Tuesday, November 19, 2013 8:40 AM | Last reply by SQLZealots - Thursday, November 21, 2013 5:19 AM -
0 Votes
How to find 10 most common value (words) from a column table?
User-352524747 posted I get values from a MatchCollection and this doesn't work.Answered | 9 Replies | 885 Views | Created by Anonymous - Thursday, June 29, 2017 2:44 PM | Last reply by Anonymous - Monday, July 3, 2017 1:40 PM -
0 Votes
Joining two tables with no common column
"I am trying to query an application database called Managesoft and don't understand how to link certain tables.Answered | 5 Replies | 1137 Views | Created by KS2909 - Tuesday, February 23, 2016 6:54 PM | Last reply by Tom Phillips - Wednesday, February 24, 2016 12:36 PM -
0 Votes
Finding Values in all Tables
The following blog deals with searching all tables:Answered | 4 Replies | 1327 Views | Created by Ramkaay - Monday, August 19, 2013 7:34 AM | Last reply by Kalman Toth - Monday, August 19, 2013 8:19 AM -
2 Votes
Find third last value of a column of table
Sachin, note that a table is an unordered set of rows so the ORDER BY specification must specify a table column for deterministic results.Answered | 3 Replies | 2177 Views | Created by J_Newbie - Monday, September 17, 2012 3:01 AM | Last reply by Dan Guzman - Monday, September 17, 2012 11:07 AM -
5 Votes
Date filtering with sparse table, getting most recent column value
In one table I have dates and currency values (sparsely distributed).Answered | 7 Replies | 4743 Views | Created by Henry Gabryjelski - MSFT - Thursday, April 18, 2013 7:33 AM | Last reply by Henry Gabryjelski - MSFT - Monday, September 16, 2013 8:55 PM -
0 Votes
How to get Common format for all the values in a column
> Can any one pls help me in getting all the above values of the column in one format "13-03-2008" or "13/03/2008" .Answered | 4 Replies | 659 Views | Created by RamarajuC - Thursday, February 4, 2016 6:11 AM | Last reply by --CELKO-- - Friday, February 5, 2016 12:30 AM -
0 Votes
Find Table and column names from string data
This is how and why application like the SSMS can show us the column names header.Answered | 18 Replies | 1618 Views | Created by coolguy123SQL - Friday, May 29, 2015 4:51 PM | Last reply by coolguy123SQL - Monday, June 1, 2015 6:21 PM -
0 Votes
how to get the most common room type
Take a look at these blogs to know how to solve such problems: Optimizing TOP N per Group Queries - blog by Itzik Ben-Gan explaining various ...Answered | 3 Replies | 1681 Views | Created by ryker1000 - Sunday, February 24, 2013 8:33 AM | Last reply by Naomi N - Sunday, February 24, 2013 7:51 PM -
0 Votes
Count null value from a table for each columns
There is a blog post you may find some helpful ways to solve your problem back to 2012: TSQL - Solve it YOUR Way - Finding the ...Answered | 8 Replies | 3665 Views | Created by HadoopHelp - Monday, February 24, 2020 7:52 AM | Last reply by HadoopHelp - Friday, March 27, 2020 12:16 PM -
0 Votes
Get value of the most bottom value in the column
regards The most important in the answer is the questionAnswered | 8 Replies | 3023 Views | Created by Anakunda v2.0 - Thursday, September 20, 2012 1:52 PM | Last reply by Anakunda v2.0 - Monday, October 1, 2012 4:59 PM -
0 Votes
How to find numerical values for Word charecters
Hi, Use the following code getting the Numeric value(Ascii valu) for each characterlocal and remote machine.Answered | 3 Replies | 2569 Views | Created by almostAlwaysLost - Friday, December 16, 2011 11:09 PM | Last reply by John Anthony Oliver - Sunday, December 18, 2011 2:11 AM -
0 Votes
how to get top most highest value record from multiple duplicate records in same column in a table
1 ) t drop table testAnswered | 6 Replies | 12641 Views | Created by Dhayanand-Kalimidi - Wednesday, October 3, 2012 10:59 AM | Last reply by vinodkumar.kapa - Wednesday, October 3, 2012 2:40 PM -
0 Votes
update column value of table in word doc/dot file using C#
I want to search table in word template(dot/doc file ) and want to update value of specific column of ...Answered | 3 Replies | 2095 Views | Created by Nitin Varshneya - Friday, February 1, 2013 9:53 AM | Last reply by chriga - Monday, February 4, 2013 7:54 PM -
0 Votes
FIND VALUES Based on Columns in Sql
I need to get values based on columns there are more than 50 columns, how can I use select query without writing columns name.Answered | 7 Replies | 689 Views | Created by Satyayadav - Tuesday, January 19, 2016 6:31 AM | Last reply by --CELKO-- - Tuesday, January 19, 2016 5:19 PM -
0 Votes
How to find the table/view name of a column in a query
You know how there is a DB_NAME().Answered | 3 Replies | 528 Views | Created by TheBrenda - Wednesday, March 2, 2016 4:24 PM | Last reply by Naomi N - Wednesday, March 2, 2016 7:13 PM -
0 Votes
Find table column pattern in a variable
Are you want to find out all matched values of column A where column C values are a subset of @a, or find out all matched values of ...Answered | 10 Replies | 1143 Views | Created by John_nn - Friday, August 15, 2014 2:54 PM | Last reply by John_nn - Monday, August 18, 2014 1:04 PM - Items 1 to 20 of 3661790 Next ›
No announcements
