Not really, you can load the results from the DelimitedSplit8K function into a temp table, can be beneficial, especially if you...

My 2Cents and a workable workaround, always preview! Had few embarrassments in the past:blush:

😎

Quick question if StorePurchaseDate is not null is the OnlinePurchaseDate null and vice versa? Or do you have an OnlinePurchase flag?

😎

Quick solution, not perfect but it works most of the time

😎

SELECT

P.Name_Section

,T.Name_Section AS Matched_row

FROM @T T

OUTER APPLY @P P

WHERE CHARINDEX(';' + P.Name_Section,';' + T.Name_Section +...

Just being a "little" pedantic and of course way off topic, for ad hoc sequence generation, sys.syscolumns is not the best choice, consider these three queries

😎

/* Query one, relative cost...

Quick thought, although source control systems are fine and in fact should always be in place, they are not holistic/comprehensive change management/monitoring/control systems. For those purposes they rely on...

TomThomson (9/25/2014)

---

Good question, but two small flaws:

1: the explanation is misleading. It says "The RAND function only produces one value for all calls in a specific connection with a...

Good stuff!

Out of curiosity, what is the output of

select @@version

after the fix?

😎

Nicely put!

😎

Thank you for the question Steve

😎

Here is a simple solution using CTE to build the full month-account set first and then join the balance table to it.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH ACCOUNT_LIST AS

(

...

Quick question, is the database in SIMPLE recovery mode?

😎

Quick thought to rule out some problems, have you checked the logs for error messages or the output of DBCC CHECKDB?

😎

goldstone.david (9/24/2014)

---

So basically I dont need to enter all the red.. I just enter... the below? It will be impossible to enter all the values in red.

SELECT * FROM...

busraker (9/24/2014)

---

I would expect that given the large variation of lats/longs. All of my data points will be within 1 degree latitude and longitude so I think i can...