Questions tagged [getlatest]
39 questions
0
votes
1 answer
TFS check as default - overwrite writeable files and overwrite all files for get specific version
How can TFS be configured to select by default the two checkboxes "Overwrite writeable files that are not checked out" and "Overwrite all files even if the local version matches the specified version" when doing a Get Specific Version?
I am using…
rguy
- 125
- 1
- 7
0
votes
2 answers
SQL Select latest row by date
I have a large amount of data that updates every 10 minutes or so.
There are 128 unique ID's that need to be returned but with only there latest values
CURRENT CODE
SELECT DISTINCT
id,
MAX(extractdate) AS…
Matt
- 14,906
- 27
- 99
- 149
0
votes
0 answers
MySQL: GROUP BY Latest record - not showing some records
I have a mysql table with the following structure:
id | fuid | tuid | msg | time | new
-- -- -- -- -- -- -- - -- -- -- -- -- - -- --
1 | 58 | 6 | test msg |2014-07-29 12:06:45 | 1
2 | 18 | 6 | test msg |2014-07-29 11:38:00 | 1
3 | 58 | 6 | test msg…
Tanase Butcaru
- 962
- 1
- 10
- 23
0
votes
0 answers
Getting latest value from joined table
I have 2 tables joined by a mapping table
I want to get the the intensity from the last Tap.
With IssuesCTE AS
(
Select * from Issues
),
TapsCTE AS
(
SELECT
MapIssueTaps.IssueId,
SD.Id,
SD.Intensity,
…
0
votes
1 answer
SQL - how to let sql auto set the next id
how can I let sql/mysql set the next id, that I have no problems with posts at the same time?
user2693017
- 1,750
- 6
- 24
- 50
0
votes
2 answers
sas import latest csv file in folder
I have a folder that that has a file added to it each day as below
Z:\old\stock110813.csv
Z:\old\stock120813.csv
Z:\old\stock130813.csv
Z:\old\stock140813.csv
I would like to import the latest file into SAS dynamically ie. searches the folder for…
John
- 1
- 1
- 1
0
votes
2 answers
SQL: How do I get the last updated row to use in a trigger
So I got this trigger that looks like this
CREATE TRIGGER trLoadingOvertime
ON trailerScheme
FOR UPDATE AS
IF (SELECT COUNT(*) FROM trailerScheme
WHERE DATEDIFF(mi, trailerScheme.expectedFinishTime, trailerScheme.finishTime) > 15) > 0
BEGIN
INSERT…
Eksperiment626
- 985
- 3
- 16
- 30
0
votes
1 answer
How to get the latest version of an app programmatically?
I want to check programmatically if my app's version is the latest existing. With iOS, I would use this HTTP request :
http://itunes.apple.com/fr/lookup?bundleId=com.EC.EmploiCollectivites
Then, parse the JSON stream to get the version.
How can I…
Rob
- 15,732
- 22
- 69
- 107
0
votes
0 answers
Getting latest version from Source Control Explorer VS Solution Explorer (Visual Studio and TFS)
How different is it from getting latest version from Source Control Explorer and Solution Explorer in Visual Studio. Some times when i get latest version through Solution explorer it does not get the exactly latest version for all the files. Any…
Praveen Mitta
- 1,408
- 2
- 27
- 48