Viewing 15 posts - 6,541 through 6,555 (of 59,070 total)
Male mosquitoes do not suck blood anyways, so that statement means nothing. Why don’t they just experiment in the UK?
Hope it gets blocked. If something goes wrong, or horribly...
August 20, 2020 at 10:13 pm
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS forum. Thanks...
August 20, 2020 at 10:07 pm
You won't find many folks that will click on a link on this site. Also, if that other site drops off the face of the planet, then the answer is...
August 20, 2020 at 10:04 pm
Lordy... absolutely nothing could go wrong with this little test, right?
https://www.yahoo.com/news/jurassic-park-experiment-750-million-132816442.html
Apparently they didn't watch the part in the original movie where "nature found a way".
August 20, 2020 at 7:54 pm
Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?
Personally, I've found that people's opinion of what the...
August 20, 2020 at 6:00 pm
SELECT StartDate = DATEADD(wk,-11,DATEADD(dd,DATEDIFF(dd,0,GETDATE())/7*7,0)) --Monday, 11 Weeks ago
,EndDate = DATEADD(wk, 1,DATEADD(dd,DATEDIFF(dd,6,GETDATE())/7*7,6)) --This coming Sunday
;
The...
August 20, 2020 at 2:22 pm
There are SSIS packages for other purpose of this project, but not for this process.
Heh... there's no way that I'm even coming close to suggesting SSIS for this or...
August 20, 2020 at 2:04 pm
I'll start off by saying that, once you've eliminated the double spacing, the first 463 lines of code are all a part of the dbo.sp_send_dbmail stored procedure, which is a...
August 20, 2020 at 1:13 am
Getting back to the original question, the reason why it's not using so much CPU is because it seems to be IO bound (IMHO) due to the RBAR nature of...
August 19, 2020 at 11:36 pm
Speaking of pork chop cannons... here's one that needs about a 9 course dinner. I'll never understand such requests.
August 19, 2020 at 7:30 pm
Amazing!
Is there a guide for in flight cooking? Frozen, thawed, and properly cooked would be good to know.
The rules for in flight cooking are simple... Frozen only... it makes...
August 19, 2020 at 7:27 pm
I don't believe that these replies are accurate.
That's a part of the problem. It's not up to analysts to decide who gets access to company owned data. 😉 That's...
August 19, 2020 at 7:21 pm
My situation: we have a team of analysts who create reports from a couple of databases. Analysts have sufficient access to read reports and write to tables. They create...
August 19, 2020 at 6:10 pm
Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?
The news ignores...
August 19, 2020 at 5:34 pm
For system objects, you won't get the system columns for system objects using INFORMATION_SCHEMA or sys.columns. You need to use the following...
sys.all_objects
sys.all_columns
sys.types (to get the datatypes of the columns)
August 19, 2020 at 11:38 am
Viewing 15 posts - 6,541 through 6,555 (of 59,070 total)