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...

I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram,...

Under General Configuration Properties in visual studio to target your version of SQL Server . you can find the sql server...

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....

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...

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 ...

So what's wrong with putting your subtraction expression in your outer query? Subtraction in T-SQL works like any other language: {Expression} - {Expression}.

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...

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.

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,...

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...

Most internet calendars have details of public holidays now a days, so I would expect...

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...

That's the version, I'm asking what Edition. Express, Standard, Enterprise, Web, Developer, Evaluation?

Seems you could use PATINDEX here, to find the pattern, and the STUFF the remove the characters. Assuming you want the 2 hyphens (and whitespace) left in situ, it would...