Viewing 15 posts - 3,211 through 3,225 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 5, 2017 at 4:10 am
Welcome to SSC.
Have a look at Jeff's Article on how to post performance problems. There's little we can do to help you with next to no...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 5, 2017 at 3:33 am
When you want to return data from another table, but retain rows if there are no matching results in the joining table, you would use a LEFT JOIN. You would...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 5, 2017 at 2:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 4, 2017 at 2:50 am
I agree that SQL...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 8:11 am
Without knowing what runs in EXECUTE dbo.sto_GetErrorInfo, then we have no idea what happens inside your CATCH.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 8:02 am
Will there be any data above the rows, or will they simply be blank? If they are truly empty (no data has ever been put in them, and not formatting...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 7:32 am
It's...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 6:45 am
Forgot to mention, the DelimitedSplit8K function can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
(For some reason, editing my above post means i can't use SSC for about 2-3 minutes and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 6:31 am
Normally, at least for a UK address, you split it into 5 parts. Address lines 1-4 and the postcode. If you have anymore, then you'll need to combine some of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 6:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 5:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 4:23 am
Excel isn't a great tool for doing stuff like this, in all honesty. it's great for collecting data from SQL server, but I don't suggest using it the other way. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 4:09 am
There isn't a lot to go on here, but yes, you can join to a Temporary table as part of a query. Of course, it needs to exist first, and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 4:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 1:34 am
Viewing 15 posts - 3,211 through 3,225 (of 5,109 total)