Viewing 15 posts - 3,631 through 3,645 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 26, 2017 at 3:39 am
The screenshot of your query has part blanked out, but I assume that that is a declaration of a database, so you are using 3 part naming convention, rather than...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 26, 2017 at 2:49 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 26, 2017 at 2:16 am
There's a work-around for this although it won't help the very poor color-mix...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 9:06 am
That does seem to be similar to the structure i provided above. Does that not give you something to start off on?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 8:35 am
My guess would be that the error you got was "XML parsing: line 9, character 13, unexpected end of input"? This is because your xml is malformed.
Your xml...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 8:28 am
Is anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 6:52 am
We really need a bit more in depth detail on your set up, however, I would hazard a guess that a hotel can be used in many tours, and also,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 6:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 5:47 am
Do you mean you're looking for SP's on your database/Server where they use the WAITFOR command? You could use something like Redgate's SQL Search add on (which is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 5:45 am
Do you have the query plans. Those are the really important part here, if you're estimates are off.
How often do you run these delete statements? Do you also...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 4:29 am
Having the estimated rows being off can be a problem yes, as it'll often mean that not enough resources are allocated to run the statement. This normally then means that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 3:11 am
You have mssql for Visual Studio code as not Cross Platform, but I can confirm that it very much works on Ubuntu 16.04 (and I imagine Mac/Docker as well).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 2:35 am
You could use the Delimited8KSplit. Then it becomes as trivial as:
SELECT DS.Item
FROM YourTable YT
CROSS APPLY dbo.Delimited8KSplit (YT.YourColumn, '/') DS
WHERE DS.ItemNumber...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2017 at 9:30 am
If you want to set the values of multiple variables in a single statement, you can use the SELECT statement:SELECT @ItemName = item_name,
@Category = category
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2017 at 8:46 am
Viewing 15 posts - 3,631 through 3,645 (of 5,109 total)