Viewing 15 posts - 1 through 15 (of 5,094 total)
Seems like you could achieve this with a couple of CTEs. I assume that the value of T_date
could differ, hence why I use window aggregation functions rather than non-windowed....
April 5, 2024 at 10:13 am
Create a calculated variable to hold the SQL statement you need
"Select * from BIG_view where Value_Date = '" + @ValueDate + "'"
Wouldn't it make more sense for the...
February 6, 2024 at 2:27 pm
So is this view using linked server queries? If so, that could well be the real problem, as such queries can often be slow, especially if the server running the...
February 6, 2024 at 12:27 pm
SSDT, which is just database projects (now) is installed via the installer. Open the Visual Studio Installer and then modify your Visual Studio Install to add "Data storage and processing"...
February 5, 2024 at 4:43 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
January 31, 2024 at 5:06 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
January 31, 2024 at 5:00 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
January 31, 2024 at 4:59 pm
You've not provided an error and you've posted enough posts here to know we have some expectations of your post. There's nothing in your post we can use to help you...
January 15, 2024 at 9:05 am
Are these nested views, by any chance?
December 19, 2023 at 9:28 am
It would likely be helpful for you to provide some kind of reproducible example, as that'll help us understand what's going on. Can you perhaps post some DDL for some...
December 12, 2023 at 9:53 am
Dunno... I particularly like road trips for pork chop dinners. 😀
If you can supply the catapult I'm sure I can put the pork chops down as an "expense". 🙂
August 23, 2023 at 3:50 pm
Ok... let's all gather hands in a circle around Thom and repeat the DBA prayer with me...
I'm not sure the strength will help me as it's likely to be...
August 23, 2023 at 3:33 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years). I get the "fun"...
August 23, 2023 at 2:49 pm
This does actually sounds like your data does have line breaks and/or carriage returns at the end of the data but you aren't seeing them. Perhaps you're copying the data...
April 26, 2023 at 7:36 am
Interesting. I hope they replace the original with this, but with full backward compatibility. I hate that -P is removed, though not sure security is changed if you need...
April 21, 2023 at 4:07 pm
Viewing 15 posts - 1 through 15 (of 5,094 total)