Have you considered selecting one record via a CTE then selecting from the CTE and unioning to another select statement where eventID and EVentDate do not equal the value from...

Love your tag 🙂

lol! Too true! 😀

Gotcha! The spacing between Select*from doesn't matter but there must be a space after from for the table name.... THanks for the learning!

In testing out the theory (not pasting from the examples which inherently include a space before the table name)... only the second query runs without error:

--WON'T RUN: select*fromUDM.DimDate ...

Awesome! Thanks for posting!

Have you also considered limitingthe dates via a join instead of the where criteria? A join is typically more powerful than a between or in list.

SELECT a.Geography

,a.Product

,a.AsOf

,a.UPC_1

,a.WtdDist_1

,a.Dsales_1

,a.Csales_1

,a.Usales_1

,b.Brand

,CONVERT(DATETIME,(SUBSTRING(CONVERT(CHAR(8),a.AsOf),5,2)+'/'+RIGHT(CONVERT(CHAR(8),a.AsOf),2)+'/'+LEFT(CONVERT(CHAR(8),a.AsOf),2) ))

AS...

Without knowing your output, here's some things that jump out to me as typically costly syntax:

- Replace CURSORS with Set-based logic (as the previous post suggested), or, try a...

Have you considered partitioning this table by date? If that's not a option then you will want either a clustered or non-clustered index on the date field. At...

I really liked this article and it came at a prime time: My team is preparing to give four classes over the next two weeks on Advanced SQL Training....

In this case, I typically add "OPTION (recompile)" ... Yes, it forces the server to come up with a new execution plan (adding time) but the new execution plan is...

I assume that you're getting that error because you're selecting * from both tables in the row_number virtual table. Select only the columns that you need instead of selecting...

I think I'm following you. . . Is this what you mean? (I've posted the original vs. the new)

/* I am looking to extract data from the wce_ilr...

Awesome!! Thank you 🙂

Typically, temp tables only last for the length of the session. My understanding is that when you exec sp_[name] then it's essentially running the SP outside of your current...