Viewing 15 posts - 3,571 through 3,585 (of 7,614 total)
Great, thanks! See if something like this is a good start to what you need.
Btw, if the call table is clustered first on StartTime (as it almost certainly should...
January 30, 2018 at 11:38 am
If you'd provide some usable sample data -- CREATE TABLE and INSERT statements -- for QueueCallItems, I (and others) can code something up. Sorry, but I just don't have additional...
January 30, 2018 at 10:39 am
SELECT SCHEMA_NAME(t.schema_id) AS schema_name,
t.name AS table_name,
c.name AS column_name,
c.max_length,
c.is_nullable,
c.is_computed
FROM sys.columns c
INNER...
January 30, 2018 at 10:09 am
January 27, 2018 at 5:45 am
Sergiy - Friday, January 26, 2018 8:41 AMWasn't it answering your question?https://www.sqlservercentral.com/Forums/FindPost1920045.aspx
No. You need to put some thought into the actual...
January 26, 2018 at 4:58 pm
But if only the start date is in the row, how do you handle "changes in interval"? And especially a variable interval, say, where some rows apply for 2 weeks...
January 26, 2018 at 8:31 am
You seem fixed to the idea that "every view must be schema bound." That's...
January 25, 2018 at 10:09 am
You seem fixed to the idea that "every view must be schema bound." That's just not true, and probably not even optimal.
January 25, 2018 at 8:52 am
January 25, 2018 at 8:48 am
I simply offered an alternative: rather than searching for errors yourself, let SQL find them for using sp_refreshview. Probably on your qa/test system, as the views are likely identical or...
January 25, 2018 at 8:04 am
January 25, 2018 at 7:25 am
Say we have your table with only beginning dates. Now I want to join to...
January 25, 2018 at 7:01 am
January 25, 2018 at 6:56 am
Sometimes when joining, it's easier if the ending value is in the row itself. It's...
January 24, 2018 at 3:51 pm
January 24, 2018 at 12:46 pm
Viewing 15 posts - 3,571 through 3,585 (of 7,614 total)