No announcements
Found 706190 threads
-
0 VotesComparing Years
WITH cte AS (SELECT YEAR(inceptionDate) AS y_i ,* FROM tbl WHERE ISDATE(inceptionDate)=1) SELECT * FROM cte WHERE ...Answered | 8 Replies | 6362 Views | Created by vineesh1 - Monday, January 24, 2011 7:34 AM | Last reply by Hugo Kornelis - Monday, January 24, 2011 9:42 AM
-
0 Votes
Comparing arrays
Q1: Is any way to get that the two arrays are the same, without comparing them by elements?  Answered | 3 Replies | 1384 Views | Created by Vilmos Foltenyi - Thursday, January 10, 2013 7:58 AM | Last reply by Vilmos Foltenyi - Thursday, January 10, 2013 8:25 PM -
2 Votes
comparing HashTables
;} $hash2 = @{"test1"="123";"test2"="cdey";"test3"="xyz";"test4"="pdqy"} Using your command you're ...Answered | 7 Replies | 18595 Views | Created by Semperfi4000 - Thursday, March 27, 2014 5:00 PM | Last reply by jrv - Monday, October 2, 2017 12:12 PM -
1 Votes
Question on comparing lists
We still need you to clarify your question. What is it that you are comparing and post the code that is offensive along with the complete error message.\\_(ツ)_/Answered | 6 Replies | 498 Views | Created by JimNasium14 - Friday, February 5, 2016 2:43 AM | Last reply by daniel.s.potter - Friday, February 5, 2016 3:05 PM -
1 Votes
Problems Comparing Dates
attached to a SCSM ticket within the last 5 minutes so I could have a notification sent to the who was Assigned the work that it was updated. Comparing strings wouldn't ...Answered | 4 Replies | 1366 Views | Created by Foothill1 - Wednesday, January 29, 2014 5:23 PM | Last reply by louisjenema - Friday, January 31, 2014 11:57 AM -
0 Votes
comparing Dates
Hi, can anyone please tell me how can I search date and time field against a datetime managed property. Eg,. SELECT ...Answered | 12 Replies | 9149 Views | Created by vik5689 - Thursday, May 29, 2008 3:06 PM | Last reply by k a u s h i - Tuesday, January 13, 2009 7:52 AM -
3 Votes
Comparing queries
each execution. But if you expect data to be cached at run-time, it's better to run the queries several times, and discard the first executions. But beware! If the queries uses ...Answered | 4 Replies | 3774 Views | Created by Leonardo A L Ferreira - Tuesday, September 21, 2010 7:46 PM | Last reply by Erland Sommarskog - Tuesday, September 21, 2010 9:03 PM -
1 Votes
Comparing dates
The DATE system type is new in SQL Server 2008. Prior to SQL Server 2008, you would do the following: SET ...Answered | 6 Replies | 3942 Views | Created by dwpeter - Thursday, March 5, 2009 12:46 AM | Last reply by dwpeter - Thursday, March 5, 2009 9:31 PM -
6 Votes
Tools for comparing GPO
Hello, I am looking for an unexpensive tool that allows comparing two GPO policies and finds differences. I know about Advanced Group Policy Management ...Answered | 6 Replies | 66479 Views | Created by guest45 - Saturday, November 17, 2012 4:21 AM | Last reply by Sujaniano - Friday, August 31, 2018 12:28 PM -
0 Votes
comparing period
Hello Komi, The following link leads to an article that has a month/same month prior year MDX sample and discusses time dynamic MDX in detail:Answered | 1 Replies | 5356 Views | Created by xpatel - Tuesday, October 30, 2007 12:47 AM | Last reply by Bob Rainey - Tuesday, October 30, 2007 2:08 PM -
1 Votes
problems comparing distribution groups
between the two would work and it did. The only difference this time that I can tell is that the group I'm comparing is a great deal larger.Answered | 6 Replies | 2184 Views | Created by Chris Jandt - Friday, October 12, 2012 7:23 PM | Last reply by Chris Jandt - Tuesday, October 30, 2012 1:05 AM -
1 Votes
Comparing 2 multidimensional arrays
$x=compare $a $b -PassThru PS >$x[1] J ¯\_(ツ)_/¯Answered | 23 Replies | 1245 Views | Created by FRacine - Wednesday, January 7, 2015 1:10 PM | Last reply by jrv - Thursday, January 8, 2015 3:57 AM -
3 Votes
Comparing Datetime
> I need to compare the following date/times. Basically I need to select from a table where the date range is between '12/15/2013' and '12/21/2013' and time is BETWEEN 5:00PM and 8:00AM. IAnswered | 9 Replies | 1421 Views | Created by DaveDB - Monday, December 30, 2013 6:57 PM | Last reply by --CELKO-- - Monday, December 30, 2013 11:07 PM -
1 Votes
Comparing two SSIS Packages?
I don't know if there is a clever way of comparing packages. Perhaps you should open a suggestion in SQL Server connect siteAnswered | 10 Replies | 14533 Views | Created by MatthewRoche - Thursday, May 24, 2007 7:57 PM | Last reply by Tamas TI Post - Wednesday, May 31, 2017 8:30 AM -
0 Votes
comparing business days..
@PrevDateTimeASChr = convert(varchar,@PrevDateTime,101) but I just realized that when comparing monday data to friday data...its not ...Answered | 2 Replies | 4386 Views | Created by SQLGeek1 - Wednesday, November 12, 2008 3:39 PM | Last reply by Mangal Pardeshi - Wednesday, November 12, 2008 4:10 PM -
0 Votes
Problems comparing distribution groups
What is the problem with comparing?Grant Ward, a.k.a. BigteddyAnswered | 5 Replies | 1505 Views | Created by King0kai - Monday, October 29, 2012 9:50 AM | Last reply by Bill_Stewart - Friday, November 2, 2012 2:25 PM -
0 Votes
Comparing two PSCustomObject objects
The tricky part is that I don't know the properties :( I'm thinking (and need to check it first) about converting both to CliXml and comparing ...Answered | 4 Replies | 6402 Views | Created by Martin_Zugec - Friday, April 26, 2013 9:19 AM | Last reply by d'AJBR - Friday, April 26, 2013 4:14 PM -
0 Votes
Comparing months
-13):[Time].[Financial Calendar].[FY2009].[P12 FY2009]) ;Answered | 4 Replies | 2649 Views | Created by Bidgeir - Friday, August 1, 2008 8:27 AM | Last reply by Bidgeir - Tuesday, August 5, 2008 8:22 AM -
0 Votes
Comparing epoch dates
past 2038 in the set... Which there maybe since the colunm was bigint. In any case, as long as it's only matter of comparing, there is no need to convert to datetime at ...Answered | 6 Replies | 769 Views | Created by Duane Stead - Wednesday, August 12, 2015 3:25 PM | Last reply by Patrick Hurst - Thursday, August 13, 2015 1:54 PM -
0 Votes
OnPublish in PS Online
Hi good afternoon, my question is, this option is avaiable in PS online?, i need modify this event but in PS onpremise the file is copy in to the gac, how to this action in ...Answered | 1 Replies | 777 Views | Created by cearde - Tuesday, July 28, 2015 7:40 PM | Last reply by PWMather - Tuesday, July 28, 2015 10:35 PM
No announcements
