From the conversation it sounds like the OP has a string field that is actually holding multuiple pieces of information.  The issue here is actually one of poor database design. ...

With great power comes great responsibiity!

Yes it is techincally possible but I would strongly dicourage it as a design pattern.  Much better to create a properly structured set of tables...

I have resorted to setting the DATEFIRST in the SQL Agent job, but I still want to know WHY SQL agent and Query window behave differently.

• This reply was modified 8 months, 1 week ago by  aaron.reese.

Interesting idea.

The HASH would effectively act as a proxy for the DirectoryFullPath.ID and DirectoryNameOfFile.ID and apart from the fact that they are calculated on the base data rather then added...

As with other GPT coding experiences, both brilliant and stupid at the same time. The players table should not have the team in it. Firstly team name is unlikely to...

Although the original question wasn't clear, I think what the OP wants to know is the number of books in each status at the end of each day so a...

I am actually trying to write a data quality trap becasue I need to report the date to a government agency. If the date eists in the correct format it...

I love answering my own questions.   The syntax is:

SELECT @MapRules.query('/root/collections/collection[groupby = "RoomNumber"]')

This give you the inner XML  for the collection which I can convert to a SQL table and iterate...

CSS support is still patchy, but a lot of that is because CSS is moving so quickly now and the parsing engine does not exist when viewing on older email...

+1 for stairways.

EdEx and Udemy will have plenty of courese for free (or cheap for Udemy) but they may be focussed on mySQL or postgress rather than t-SQL but the...

I have only scan -read the conversation and not opened the workbook, but it sounds like you want to move the day number to 3 columns and populate those columns...

You might find it easier to reason about with EXCEPT and INTERCECT.

SELECT DISTINCT KEY FROM myTable WHERE type = 'COLL' and subtype = 'MOD'

EXCEPT

SELECT DISTINCT KEY FROM...

You also need to consider licencing costs for MSSQL and they can be very complicated.  From memory the minumum licence is 4 cores and then in multiples of 2 up...

Would STUFF...FOR XML be faster that STRING_AGG? I think they both will be doing ReBAR under the hood.

Can you pre-calculate the string contatenation and persist it?  You could then index...

I'm not aware of anything that would allow you to do that, but if it helps:

VLOOKUP is the equivalent of a JOIN

MATCH is the equivalent of a WHERE

SUM and MAX...