Forum Replies Created
Viewing 15 posts - 136 through 150 (of 5,109 total)
-
Reply To: Need to rearrange order of names from a fullname column to LAST, SUFFIX, FIRST
So how do you tell what parts of the name are what? If you can't tell, then SQL Server has no chance. Honestly, if you need names to be in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: DTExec: The package execution returned DTSER_FAILURE (1)
-
Reply To: ISNULL function
Why not refer to documentation for what is does? As for what is a good reason to use it in a
VIEW, I'm not sure what you really mean....Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Update variable inside foreach loop
Why are you using a loop at all would be my first question. Also, please don't put your content in a code block (unless it's code of course); it makes...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: convert column
Sounds like the value is also in some kind of "time format" in your CSV file then, as is the column is a
varchar, presumably the value in the text ...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: how to call a scalar function without schema in sqlserver 2019
The problem appears to be you8 are relying on the default schema of a user to change the behaviour of your objects; that is the real problem here. You should...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: pull data every 3 hrs
Some sample data (for the table you've provided DDL for), and expected results (for your different scenarios) will really help here. I wouldn't want to guess the wrong thing.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: pull data every 3 hrs
So what row, in that 3 hour window, do you want? the "first" row, that being the one with the lowest time that "bucket"? The last row, a arbitrary row,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: how to call a scalar function without schema in sqlserver 2019
So are these objects in the 2 different schemas identical? I suppose the question then it why do you have the same objects in 2 different schemas? Sounds like you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Calendar table in SQL
pedroccamara wrote:Or....is there any chance of getting the holidays from Portugal for a specific year (2019-2022).
Most internet calendars have details of public holidays now a days, so I would expect...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Run report error
Hmm, that's that idea out the window then. I was expecting you to say Express, which only supports data sources to the localhost; trying to connect an Oracle Instance on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Remove 6 digits and 8 digits from texts
Seems you could use
PATINDEXhere, to find the pattern, and theSTUFFthe remove the characters. Assuming you want the 2 hyphens (and whitespace) left in situ, it would...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Azure Pricing, SQL Server seems pretty high?
This is a copy paste of this post, which is also a copy paste of this reddit post. I suggest looking at the responses there.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Under General Configuration Properties in visual studio to target your version of SQL Server . you can find the sql server...Viewing 15 posts - 136 through 150 (of 5,109 total)