Viewing 15 posts - 2,821 through 2,835 (of 8,761 total)
quinn.jay (11/9/2016)
November 9, 2016 at 10:35 pm
Jeff Moden (11/8/2016)
drew.allen (11/8/2016)
November 9, 2016 at 10:31 pm
Newbi (11/9/2016)
November 9, 2016 at 10:17 pm
A CASE statements needs to be terminated with the END keyword
😎
-- Syntax for SQL Server and Azure SQL Database
Simple CASE expression:
CASE input_expression ...
November 9, 2016 at 10:13 pm
User7766 (11/9/2016)
I've 4 decimal(15,6) columns in my table and based on the condition i am updating one of the four columns in sql server database which also includes summing...
November 9, 2016 at 10:04 pm
Benki Chendu (11/9/2016)
Friends,What sort of offerings could be created using PowerBI . They could even be small time consulting - Build and implementation projects
The question is very broad, somewhat like...
November 9, 2016 at 10:00 pm
s0da9 (11/9/2016)
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Logon
Event ID:17187
Date:11/10/2016
Time:10:54:59 AM
User:N/A
Computer:TSERVER
Description:
SQL Server is not ready to accept new client connections.
Wait a few minutes before trying again.
If...
November 9, 2016 at 9:48 pm
RonKyle (11/9/2016)
Word of caution, a single instance of a dimension table used many times in a model will most likely result in an empty result set.
Not sure if I'm...
November 9, 2016 at 11:56 am
Phil Parkin (11/9/2016)
Matt.Altman (11/9/2016)
haha wow. Thank you for catching that.NP. Sometimes a fresh pair of eyes is all that's needed.
This is were sys.dm_exec_describe_first_result_set comes in handy, just generate the...
November 9, 2016 at 11:44 am
Eric M Russell (11/9/2016)
November 9, 2016 at 11:39 am
kevin.obrien 66193 (11/9/2016)
Think of an order with an order data and a delivery date, most likely those will not be the same. If you use a single instance of a...
November 9, 2016 at 11:38 am
No offence Jeff, just thought this was funny
😎
November 9, 2016 at 11:37 am
Jeff, have you been thinking about this for the last 7 years?
😎
November 9, 2016 at 11:34 am
Grant Fritchey (11/9/2016)
Eirikur Eiriksson (11/9/2016)
Grant Fritchey (11/9/2016)
Beatrix Kiddo (11/9/2016)
There is absolutely nothing when working on an SQL Server that requires RDP to the server
Not quite true- if you work in...
November 9, 2016 at 11:32 am
Grant Fritchey (11/9/2016)
Beatrix Kiddo (11/9/2016)
There is absolutely nothing when working on an SQL Server that requires RDP to the server
Not quite true- if you work in a bank or other...
November 9, 2016 at 10:34 am
Viewing 15 posts - 2,821 through 2,835 (of 8,761 total)