Viewing 15 posts - 976 through 990 (of 9,707 total)
It was that extra file reason why I went with the CASE statement instead of just adding the plus 1. But then, I had forgotten about CEILING since I never...
May 18, 2017 at 5:03 am
jonathan.crawford - Wednesday, May 17, 2017 9:09 PMEmail server's down, I sent you an email about it.
I actually once had someone tell...
May 18, 2017 at 4:25 am
FridayNightGiant - Wednesday, May 17, 2017 12:47 PMI'd do it like this
SELECT CEILING(COUNT(*)/750000.00) AS FileCount
FROM dbo.Mytable
Ah. Forgot about that...
May 17, 2017 at 12:50 pm
SELECT COUNT(*)/750000 AS FileCount
FROM dbo.MyTableMay 17, 2017 at 12:40 pm
So here's how I got it to work.
I created two variables, @FileCount (set at 0) and @LoopCounter (set at 1). Using a T-SQL task with the below code,...
May 17, 2017 at 11:24 am
Yes, we could set the reply to but we don't want out of office messages and such hitting our inboxes. So we make them forward the email to us.
May 17, 2017 at 5:21 am
Sorta technical question that is more of the curious variety.
When you have to set up an automated email from a SQL server job to either a business unit customer...
May 17, 2017 at 4:47 am
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
May 16, 2017 at 11:02 am
<headdesk>
Feeling really stupid now.
I've done this before. Back in 2005 or 2006. This fact finally dawned on me after staying away from this project for a...
May 16, 2017 at 10:55 am
May 16, 2017 at 10:40 am
Is it just me or does it seem orcas are getting in on the black market organ market?
May 16, 2017 at 7:04 am
May 15, 2017 at 8:10 am
May 12, 2017 at 12:06 pm
May 12, 2017 at 12:01 pm
May 12, 2017 at 12:00 pm
Viewing 15 posts - 976 through 990 (of 9,707 total)