A client has moved to SQL Server 2019 on Windows Server 2022. Earlier they had SQL Server 2012 on W…
1 hour, 25 minutes ago
By: Jo Pattyn
I want some help with a code to count the number of unique months that appears in list (us…
20 hours, 25 minutes ago
what are the best books to become a SQL developer?
1 day, 4 hours ago
I've got a table here with more than 60 million rows and I want to extract data based on date (WHER…
1 day, 22 hours ago
By: Jeff Moden
At my last place of work the DBA used a code "beautifier" to format his SQL and he insisted that th…
6 days, 16 hours ago
This is a simplified version of the actual tables and query I'm working with.
I feel like it should…
1 week, 1 day ago
By: jmadsen 98862
What would be the best approach when establishing the distance between points.
By that I mean I hav…
I have a problem to fill a new column from a previous column where the values are calculate.…
1 week, 2 days ago
I am dealing with a Fact Table which has multiple row entries for each customer in respect of t…
1 week, 5 days ago
To compare if a value is null in an IF condition in SQL, you can use the IS NULL operator.
My table have a xml column so how to select the data from xml column my data is:
I would like to build a Microsoft-based Application to use SQL Server Tables, and with this …
By: Grant Fritchey
I keep hitting road blocks on this, I'm pretty new so I feel like this could be a really obvious on…
1 week, 6 days ago
By: Michael L John
Is there a way to "timeout" a query? Assume I'm coding a long sql-query. A part of the query, I don…
2 weeks ago
I have not been on here for a while, I've been in hospital a lot recently and now I've got Canc…
2 weeks, 6 days ago
By: Steve Collins
Viewing 15 topics - 1 through 15 (of 30 total)
You must be logged in to create new topics.