Viewing 15 posts - 2,986 through 3,000 (of 10,144 total)
Welsh Corgi (8/28/2014)
The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.Any ideas would be greatly appreciated.
Remove...
August 28, 2014 at 7:12 am
Ed Wagner (8/28/2014)
ChrisM@Work (8/28/2014)
TomThomson (8/28/2014)
Ed Wagner (8/28/2014)
BWFC (8/28/2014)
TomThomson (8/27/2014)
Ed Wagner (8/27/2014)
crookj (8/27/2014)
Ed Wagner (8/27/2014)
BWFC (8/27/2014)
Punched tapeCards (remember the stack that got dropped?)
Chad
Election
Florida
Keys
Alligators
Everglades
Aviator shades
Fighter Pilot
Pitot tube
August 28, 2014 at 6:13 am
TomThomson (8/28/2014)
Ed Wagner (8/28/2014)
BWFC (8/28/2014)
TomThomson (8/27/2014)
Ed Wagner (8/27/2014)
crookj (8/27/2014)
Ed Wagner (8/27/2014)
BWFC (8/27/2014)
Punched tapeCards (remember the stack that got dropped?)
Chad
Election
Florida
Keys
Alligators
Everglades
Aviator shades
August 28, 2014 at 6:11 am
sqlenforcer (8/27/2014)
If there is fragmentation in some of the indexes being used in a multi-table join query, would that cause TEMPDB to grow?
You're experiencing heavy tempdb usage during...
August 28, 2014 at 4:35 am
ronan.healy (8/27/2014)
sorry I ment the text before the date.that's the text I want to take
so its like this now BNY Mellon - 07/01/2014
and I want it like this BNY Mellon
DECLARE...
August 27, 2014 at 6:39 am
There are a few alternatives, such as this:
SELECT MyStuff
FROM TableList t
OUTER APPLY (
SELECT TOP 1 item, customer, delnote, deldate
FROM #tmpdelnotes d
WHERE d.Item = t.Item
ORDER BY deldate DESC
) ou
Can you...
August 27, 2014 at 5:53 am
twin.devil (8/27/2014)
Following is the example have been made to...
August 27, 2014 at 2:04 am
tony28 (8/26/2014)
ChrisM@Work (8/26/2014)
tony28 (8/25/2014)
I added second sql plan with query with condition before update statistics..is this so big different between before and after ?
here looks almost ok
Query 2 works...
August 27, 2014 at 2:02 am
Finally, here's one of several alternative ways to write essentially the same query:
SELECT
vs.PipeSystemID,
vs.PipelineID,
vs.OrionStationSeries,
vs.ValveSectionBegin,
Builder = ISNULL(u1.FirstName + ' ', '') + ISNULL(u1.LastName,''),
QC = ISNULL(u2.FirstName + '...
August 27, 2014 at 1:50 am
In this version, I've made each table reference completely unambiguous and also included TOP to eliminate dupes in the subqueries. This is one of those very few cases where TOP...
August 27, 2014 at 1:47 am
Here's one of those subqueries from the output list. Run it and see what it returns.
SELECT [Final Engineer] = (COALESCE(FirstName, '') + ' ' + COALESCE(LastName,''))
FROM Users
INNER JOIN...
August 27, 2014 at 1:40 am
Here's your query reformatted to make it easier to understand what you are trying to do:
SELECT
ValveSections.PipeSystemID,
ValveSections.PipelineID,
ValveSections.OrionStationSeries,
ValveSections.ValveSectionBegin,
Builder = (SELECT (COALESCE(FirstName, '') + ' ' + COALESCE(LastName,''))
FROM...
August 27, 2014 at 1:28 am
David Burrows (8/26/2014)
pwalter83 (8/26/2014)
Actually this worked superbly well for the OP ! I had been stuck on this for a long time now and had given up all hope
You're welcome...
August 26, 2014 at 10:00 am
winston Smith (8/26/2014)
Finally, if it doesn't return what you expect, can you provide an online source which shows that what you are expecting to see isn't just a wish.
if i...
August 26, 2014 at 7:58 am
winston Smith (8/26/2014)
ChrisM@Work (8/26/2014)
winston Smith (8/26/2014)
i have changed to british english in the server settings, and my user also has british...
August 26, 2014 at 7:38 am
Viewing 15 posts - 2,986 through 3,000 (of 10,144 total)