No announcements
Found 3895853 threads
-
3 Voteshow to delete duplicate records in sql server?
It ranks the columns by name and gives them a row number, so the first John get number 1 and others get greater.Answered | 4 Replies | 1357 Views | Created by programmer on .net - Friday, January 25, 2013 7:36 AM | Last reply by MasaSam - Friday, January 25, 2013 12:29 PM
-
3 Votes
distict values in calculated column
How did you create the "Row Number" column?Answered | 6 Replies | 1413 Views | Created by Penny.Bell - Tuesday, March 5, 2013 4:34 AM | Last reply by undergrads1 - Tuesday, November 19, 2013 5:04 PM -
1 Votes
How to sort a varchar column that contains numbers and letters in SQL Server?
Large scale of database and data cleansing Remote DBA Services: Improves MS SQL Database Performance SQL Server ...Answered | 3 Replies | 340 Views | Created by dchencm - Saturday, August 23, 2014 9:32 PM | Last reply by Uri Dimant - Sunday, August 24, 2014 6:41 AM -
5 Votes
Detecting Column Dependency (columns used on column calculation) in Sql Server
In other words, we humans will become obsolete.Answered | 4 Replies | 6972 Views | Created by Freddy Angarita - Thursday, December 27, 2012 10:52 PM | Last reply by Kalman Toth - Friday, December 28, 2012 3:21 PM -
0 Votes
Calculate New Column in sql server
Unless you give accurate requirements, how can anyone help you?Answered | 20 Replies | 810 Views | Created by Asmasm11 - Tuesday, May 20, 2014 10:48 AM | Last reply by Asmasm11 - Wednesday, May 21, 2014 9:50 AM -
0 Votes
duplicate field entries
We decided to base the criteria off the shipping reference number and serial number instead of the shipment date and serial number.Answered | 13 Replies | 1830 Views | Created by taking - Friday, April 6, 2012 7:47 PM | Last reply by taking - Tuesday, April 10, 2012 8:16 PM -
0 Votes
Duplicate row entries in SQL database
; DROP TABLE #temp; COMMIT; GO DROP TABLE dbo.t; --Answered | 2 Replies | 6059 Views | Created by Bryan24 - Tuesday, March 23, 2010 2:14 AM | Last reply by Bryan24 - Wednesday, March 24, 2010 11:09 AM -
0 Votes
Passing Calculated Columns from Sharepoint into Word Document Library Template
So maybe you can shed some light on it for me...Answered | 8 Replies | 9206 Views | Created by MaxPowers1974 - Monday, November 8, 2010 7:24 PM | Last reply by Anadmin - Friday, July 1, 2011 3:06 PM -
2 Votes
SharePoint Calculated Column - IF a number column is blank
As a side note, there is a good article on the MSDN site that goes through a lot of formula examples when using calculated columns or validation.Answered | 3 Replies | 7034 Views | Created by Millard1 - Friday, September 27, 2013 10:10 AM | Last reply by Millard1 - Friday, September 27, 2013 12:21 PM -
3 Votes
Some Calculating problems
, ive got some stuff to work with, i think my bad english is the biggest problem. =) ill post some update tomorrowAnswered | 16 Replies | 557 Views | Created by JustOrange - Friday, December 20, 2013 11:30 PM | Last reply by JustOrange - Sunday, December 22, 2013 5:59 PM -
1 Votes
Need advice on preventing duplicate entries in People table
Second issue is "potential" duplicates where there are some variations in the name e.g.Answered | 13 Replies | 838 Views | Created by imsam67 - Sunday, January 19, 2014 5:09 AM | Last reply by HimanshuSharma - Monday, January 20, 2014 8:30 AM -
0 Votes
Mark Duplicate entry
Shouldn't it only be one of them that is a duplicate?Answered | 4 Replies | 713 Views | Created by PrajapatiNeha - Monday, July 8, 2013 7:28 AM | Last reply by Ch. Rajen Singh - Monday, July 8, 2013 11:55 AM -
5 Votes
how to change numbers to words?
This demonstrates some of the overhead in the framework associated with working with strings, as well as some of the methodologies in place for dealing with these string-related ...Answered | 24 Replies | 2002 Views | Created by config2002 - Monday, August 29, 2011 5:42 PM | Last reply by Dig-Boy - Wednesday, August 31, 2011 12:45 AM -
0 Votes
how to find the duplicate entries in vb.net command
1 For Each item In q Console.WriteLine(item.value.ToString) For Each item2 In item.Group Console.WriteLine(" ...Answered | 1 Replies | 3476 Views | Created by HC Lee - Wednesday, February 8, 2012 12:07 PM | Last reply by Kevininstructor - Wednesday, February 8, 2012 4:25 PM -
0 Votes
To Add a auto number column to a table in SQL server
Use SQL Server Management Studio Import / Export wizard to transfer data 3.Answered | 3 Replies | 10413 Views | Created by teja765 - Tuesday, June 14, 2011 1:57 PM | Last reply by Arunraj.C - Tuesday, June 14, 2011 10:37 PM -
0 Votes
Duplicates on SQL server replication
looking for a book on SQL Server 2008 Administration?Answered | 2 Replies | 367 Views | Created by PraveenKumar_Chels - Wednesday, August 27, 2014 2:32 AM | Last reply by Hilary Cotter - Friday, August 29, 2014 4:30 PM -
1 Votes
Sharepoint Calculated column with [Today]
Are you either using the fake column trick (that doesn't update) or using a default value instead of a *calculated column*?Answered | 11 Replies | 38456 Views | Created by US- - Thursday, October 21, 2010 2:47 PM | Last reply by Eduardo1.G.Flores - Tuesday, October 28, 2014 4:30 PM -
4 Votes
Calculated column with difference from previous values?
The only problem is the column's values for the first entries that don't have previous rows.Answered | 5 Replies | 1449 Views | Created by michael.greenwald - Monday, March 25, 2013 7:39 AM | Last reply by Jacob Barnett - Tuesday, March 26, 2013 12:48 AM -
0 Votes
How to let know the use of Ignore duplicates from SQL Server
However, due to the business flow, there are some columns that could have the same value and it will be OK.Answered | 3 Replies | 2676 Views | Created by Lesthad - Thursday, April 19, 2012 10:12 PM | Last reply by Lesthad - Monday, April 23, 2012 3:24 PM -
4 Votes
Are calculated columns compressed in a PowerPivot model?
My suggestion would be to perform all the transformations and calculated column calculations on your database server, creating physical tables ...Answered | 5 Replies | 236 Views | Created by Ben_m1 - Tuesday, October 14, 2014 8:19 AM | Last reply by Greg2178 - Thursday, October 16, 2014 3:12 PM - Items 1 to 20 of 3895853 Next ›
No announcements
