No announcements
Found 738622 threads
-
0 Votesdiff between Two columns
Use SQL DATEDIFF() Function, but you need to store the difference between two date time columns as integer.Answered | 2 Replies | 4702 Views | Created by chandra2ravi - Wednesday, March 25, 2009 1:43 PM | Last reply by Yum64147 - Wednesday, March 25, 2009 1:52 PM
-
2 Votes
Send a Daily Email with Item Links Based on Condition in Item Field
kelly, 1. create two date columns for today and due date 2. third calculated column to find diff between above two ...Answered | 3 Replies | 1701 Views | Created by Kelly Rob - Monday, August 12, 2013 2:15 PM | Last reply by karimSP - Tuesday, August 13, 2013 7:36 PM -
1 Votes
How to do a datediff on two columns
two columns I'm interested in is START_DATE_TIME and FINISH_DATE_TIME. The format for both of these columns is YYYY-MM-DD HH-MM-SS.MS for example: ...Answered | 3 Replies | 1390 Views | Created by mgpspr - Monday, February 8, 2016 8:57 PM | Last reply by Visakh16 - Tuesday, February 9, 2016 6:20 AM -
0 Votes
Difference between two dates using SP 2010 Lists
Hi, I am using SP 2010 custom List to calculate the no of months between two dates. The two columns are "Start Date" ...Answered | 5 Replies | 7768 Views | Created by VinodKumar Pottal - Tuesday, February 8, 2011 4:49 AM | Last reply by Clayton Cobb - Wednesday, February 9, 2011 3:09 AM -
0 Votes
MDX for records between date range where start and end date being separate columns
Hi .. need help in this Is it possible to write in MDX to extract records between two dates …. where start and end date are 2 diff ...Answered | 1 Replies | 4134 Views | Created by Nishikant Naveen - Friday, November 9, 2012 4:56 PM | Last reply by Andrew Sears - T4G - Friday, November 9, 2012 6:40 PM -
2 Votes
Value out of range index error while accessing list item in application page
Only diff between these 2 column here is "Name" is site column added to list and "Column1" is directly added to ...Answered | 7 Replies | 4173 Views | Created by SPGeek003 - Sunday, July 29, 2012 5:25 PM | Last reply by Nicolas Castel - Monday, July 30, 2012 7:02 AM -
0 Votes
Diff between two labels not working
Hi, I'm trying to use the tf diff to get the difference between two labels. The syntax is: tf diff ...Answered | 1 Replies | 4326 Views | Created by shmulik_segal - Monday, July 17, 2006 2:06 PM | Last reply by Michal Malecki - MSFT - Monday, July 17, 2006 3:03 PM -
0 Votes
Find/Rank "Similar Matches" by Multiple Columns
table with the following columns, all ...Answered | 3 Replies | 5306 Views | Created by TomABC - Wednesday, June 1, 2011 6:01 PM | Last reply by TomABC - Monday, June 6, 2011 10:16 PM -
0 Votes
Inserting Unprotected Columns between two protected columns
Is it possible to insert an unprotected column in between two protected columns.Answered | 2 Replies | 1515 Views | Created by UserNet123 - Monday, August 6, 2012 8:26 PM | Last reply by Asadulla Javed - Tuesday, August 7, 2012 6:15 AM -
4 Votes
Difference between two columns
GO This query returns empty (which is not correct). however, I ran the script in two different columns (contain data type INT ) and that ...Answered | 5 Replies | 1554 Views | Created by sebi500 - Monday, May 20, 2013 4:55 AM | Last reply by Richard Bragado - Wednesday, May 22, 2013 11:28 AM -
0 Votes
Difference between a measure on two dimensions
; http://ask.sqlservercentral.com/questions/72968/difference-between-a-measure-on-two-date-dimensions thanks for the ...Answered | 3 Replies | 5188 Views | Created by JaySeeAre - Tuesday, May 24, 2011 1:12 PM | Last reply by JaySeeAre - Wednesday, May 25, 2011 2:06 PM -
2 Votes
Columns Diff
Hi Is there a way, given two table names, to get a list of columns in table 1 that are not in table ...Answered | 3 Replies | 417 Views | Created by Y a h y a - Sunday, May 28, 2017 3:19 AM | Last reply by Sam Zha - Monday, May 29, 2017 4:56 AM -
1 Votes
Difference between two columns
I am looking for difference between two tables not the difference in one table. ex:- Table A ===== Testing ...Answered | 10 Replies | 6025 Views | Created by Venugopal Saride - Monday, August 20, 2012 7:55 PM | Last reply by ank hit - Tuesday, August 21, 2012 6:03 PM -
0 Votes
Diff between Logins & Users
Hi , What is the diff between Logins & Users in SQL Server? thanks BabuAnswered | 2 Replies | 6701 Views | Created by Sridhar Babu B - Thursday, January 25, 2007 10:01 AM | Last reply by Geert Verhoeven - Thursday, January 25, 2007 11:18 AM -
0 Votes
Sync Data Between Two Diff SQL Servers
I have two SQL servers that I need to have identical. Sync should occur maybe a couple times per day, automatically. The one server which holds the main SQL DB is on a domain and the other ...Answered | 1 Replies | 3415 Views | Created by rustynails28 - Friday, December 7, 2012 2:55 PM | Last reply by Hilary Cotter - Friday, December 7, 2012 4:44 PM -
0 Votes
Date Diff VarChar Columns
Hi, I have two columns VOID_START_SQL and LET_DATE_SQL which are varchar(10) and record dates. I'm trying to calculate the datediff between ...Answered | 10 Replies | 4220 Views | Created by jaggy99 - Wednesday, March 18, 2015 6:25 AM | Last reply by Dia.Agha - Saturday, March 21, 2015 12:46 AM -
0 Votes
Comparison between two date columns
Hello everyone, I am trying to compare two date columns in my task list using SPD 2010. Is it possible to do so? Currently i get options only to ...Answered | 5 Replies | 6885 Views | Created by GaurYogesh - Tuesday, June 14, 2011 4:13 AM | Last reply by romeo donca - Tuesday, June 21, 2011 7:00 PM -
0 Votes
Records Between two date columns
Hi All, I am having a problem getting records between two date columns. My table is shown below. SAP_ID ...Answered | 2 Replies | 5925 Views | Created by Rajesh_M - Wednesday, May 2, 2007 5:51 PM | Last reply by TravelMan - Wednesday, May 2, 2007 6:52 PM -
0 Votes
CHECKING DIFFERENCE BETWEEN TWO COLUMNS
You can use a CASE Expression to check whether the two columns are equal in a SELECT statement or you can UPDATE your table similarly. You may need to consider ...Answered | 5 Replies | 1980 Views | Created by KODI_KODI - Friday, November 30, 2012 9:32 PM | Last reply by KODI_KODI - Friday, November 30, 2012 9:50 PM -
0 Votes
Moving data between two columns
for the site.You can create two lists to achieve the car reservation. List1 with columns Title and Car Status: Available, NotAvailable.Set the Car Status ...Answered | 1 Replies | 1153 Views | Created by ShajiManj - Wednesday, April 24, 2013 8:51 AM | Last reply by Entan Ming - Thursday, April 25, 2013 6:18 AM - Items 1 to 20 of 738622 Next ›
No announcements
