Viewing 15 posts - 1,681 through 1,695 (of 5,111 total)
How do you tell if the row already exists? Is there an ID you can use? Otherwise, are you saying that every value had to match? If the latter, you...
September 15, 2018 at 7:29 am
Look, I could care less, but Hugo is quite chuffed about this, so...
September 10, 2018 at 9:14 am
September 10, 2018 at 8:13 am
September 7, 2018 at 9:57 am
September 7, 2018 at 9:44 am
Ahhh!!! You ruined my "beautiful" tally table and introduced an RBAR CTE. Why would you do that... :crying:
You have a TOP 10 in there as well, but...
September 7, 2018 at 9:27 am
September 7, 2018 at 9:10 am
One method is to use a Calendar table: http://www.sqlservercentral.com/articles/calendar/145206/
Alternatively, you can create the table on the fly. The below would generate all of the days, provided the...
September 7, 2018 at 8:50 am
ChrisM@Work - Friday, September 7, 2018 7:06 AMI can spell most of those big words. What's the rate?
Ironically, whoever posted that...
September 7, 2018 at 8:03 am
September 6, 2018 at 2:11 am
September 6, 2018 at 1:56 am
What do you mean my "see" exactly? If you mean know of it's existance, then yes, they will be able to see it. If you mean access the data, then...
September 5, 2018 at 6:05 am
You mean?SET @v_result = cast(DATEDIFF(s, @v_time, @v_date) as bigint);
September 5, 2018 at 4:37 am
September 4, 2018 at 9:32 am
Hey, I've actually had to use code like that in a few instances...
September 4, 2018 at 9:10 am
Viewing 15 posts - 1,681 through 1,695 (of 5,111 total)