Viewing 15 posts - 4,336 through 4,350 (of 8,731 total)
spaghettidba (8/24/2015)
Long time no see... I've been away from the forums lately and I have 650 unread posts on The Thread (which I won't even try to catch...
August 24, 2015 at 8:28 am
DuncEduardo (8/24/2015)
you can use SQL string functions (Left, Right, Substring) to split out "date" parts.Then can concatenate and apply a "cast ... as datetime" clause.
Always worked for me.
That might not...
August 24, 2015 at 8:21 am
And if you don't need the time, just use the date datatype instead of a datetime.
August 24, 2015 at 8:06 am
whereisSQL? (8/21/2015)
Ed Wagner (8/21/2015)
djj (8/21/2015)
Ed Wagner (8/21/2015)
djj (8/21/2015)
Eirikur Eiriksson (8/21/2015)
TomThomson (8/20/2015)
whereisSQL? (8/20/2015)
Luis Cazares (8/20/2015)
DonlSimpson (8/20/2015)
CurvesLines
Parallel
Euclid
Relation
Commitment
Honor
Offer
Counter
Reject
Eject
August 21, 2015 at 1:31 pm
Are you looking in the server or your personal computer? Are they the same or different machines?
Remember that those are local paths for the server but might not be local...
August 21, 2015 at 9:56 am
Hi and welcome to the forums.
As J Livingston mentioned, we need some sample data to give a good and tested advice. It's important that this sample data is posted as...
August 21, 2015 at 8:43 am
Ed Wagner (8/21/2015)
Luis Cazares (8/21/2015)
Ed Wagner (8/21/2015)
Brandie Tarvin (8/21/2015)
Phil Parkin (8/21/2015)
and sjh.run_date >= (year(getdate() - 1) * 10000 +...
August 21, 2015 at 7:21 am
Not a big deal, but you can change this:
cross apply (select * from dbo.[DelimitedSplit8K](value1,',') )temp
To this:
cross apply dbo.[DelimitedSplit8K](value1,',') temp
With the exact same results.
August 21, 2015 at 7:01 am
Ed Wagner (8/21/2015)
Brandie Tarvin (8/21/2015)
Phil Parkin (8/21/2015)
and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) *...
August 21, 2015 at 6:55 am
DonlSimpson (8/20/2015)
Revenant (8/20/2015)
djj (8/20/2015)
whereisSQL? (8/20/2015)
Ray K (8/20/2015)
Ed Wagner (8/20/2015)
whereisSQL? (8/20/2015)
BL0B_EATER (8/20/2015)
Eirikur Eiriksson (8/20/2015)
Ed Wagner (8/20/2015)
djj (8/20/2015)
DonlSimpson (8/19/2015)
Ed Wagner (8/19/2015)
Luis Cazares (8/19/2015)
Revenant (8/19/2015)
ZZartin (8/19/2015)
whereisSQL? (8/19/2015)
BL0B_EATER (8/19/2015)
WaterConservation
Fire
Alarm
Clock
Time
Fades
Grave
Dead
Terminal
airport
Security
Breach
Beach
Volleyball
Cloths
Bikini
Curves
Lines
August 20, 2015 at 1:47 pm
This should do the trick. Feel free to ask any questions that you might have.
WITH cteCounts AS(
SELECT trip, loads, COUNT(*) counts
FROM test6
...
August 20, 2015 at 12:51 pm
You can do it easily with the help of the DelimitedSplit8k. It's explained in here and you can find the code to create it in your system. http://www.sqlservercentral.com/articles/Tally+Table/72993/
Once having it,...
August 20, 2015 at 12:15 pm
Lynn Pettis (8/19/2015)
Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a different career.
I was really...
August 20, 2015 at 12:01 pm
Other that removing the * and include only the needed columns, there's not much advice I could give with the information provided.
For further assistance, please read the following article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 20, 2015 at 11:36 am
Note that UNION will remove any duplicates. To avoid this problem and receive a possible performance improvement, use UNION ALL.
August 20, 2015 at 11:32 am
Viewing 15 posts - 4,336 through 4,350 (of 8,731 total)