Viewing 15 posts - 586 through 600 (of 5,111 total)
Tonight, I'll be having haggis. Pray for me.
Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In Edinburgh...
January 31, 2020 at 9:47 am
personally I prefer ????? . either from Nikka or Suntory
anything really except Jack D
One of my favourites is Monkey Shoulder. I'm also very partial to Aberfeldy. My Whisky...
January 31, 2020 at 9:30 am
Tonight, I'll be having haggis. Pray for me.
Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In Edinburgh for SQL...
January 31, 2020 at 8:55 am
This whole MVP grind can be a serious grind. I love it, but I absolutely see how it can burn you out. Especially on the forums. Some days it...
January 30, 2020 at 3:18 pm
I know this will stir up a hornet's nest, but maybe helping someone with an interview question is not so bad.... you just have to give them a direction...
January 30, 2020 at 10:43 am
Just a thought,
every post I've replied to in the last few weeks has had updates and new info from pretty much the same bunch of people on here.
Grant, Jeff,KTFlash,...
January 30, 2020 at 9:17 am
Thom,
didn't your large value came through as null when using TRY_CAST? It did when I tried in SSMS.
It does with TRY_CONVERT, not with CONVERT; which implies you're using CONVERT...
January 22, 2020 at 4:55 pm
Only way I can recreate this issue is with a value greater than or equal to 9999999999999.995 (or the same negative value); which does implies you have a value like...
January 22, 2020 at 4:33 pm
I assume you're doing something like this:
EXEC dbo.YourProcedure @BatchSize = @BatchSize * 2;
With a Stored Procedure you can't pass expressions as parameters, only variables or literals. If...
January 13, 2020 at 12:37 pm
Actually I just noticed that post is about PL/SQL and Oracle, not SQL Server. What SQL Server and Oracle call Analytic Functions could be different, as same named functions may...
January 8, 2020 at 2:56 pm
maybe this is debatable:
This post treats all Ranking Functions as analytical functions.
Thank you anyway.
That post is from 2004, it's almost 16 years old and based on SQL Server 2000...
January 8, 2020 at 2:49 pm
Importing from Excel using SSIS is almost always a massive pain, so I am going to check this method out.
On this, I couldn't agree more. I honestly despise the...
January 8, 2020 at 2:18 pm
Cross post on Stack Overflow, if anyone interested.
January 8, 2020 at 2:15 pm
Rogue One trailer popped up that first time, I actually teared up and choked out "many bothans died..." ( and then, where were the bothans?)
None for the Death Star;...
January 7, 2020 at 3:57 pm
Viewing 15 posts - 586 through 600 (of 5,111 total)