Viewing 15 posts - 121 through 135 (of 197 total)
Hi Thom
This is a database which was provided by a vendor of ours and this is their database
I am just creating the queries based on the fields...
November 13, 2017 at 2:24 am
I tried getting sample data but the rows are too long
November 12, 2017 at 11:50 pm
Hi Guys
Here are the DDLs for the 3 tables
Badge
SET ANSI_NULLS ON
November 12, 2017 at 11:44 pm
Give me until tomorrow and I’ll send you the ddl for all 3 tables
Kal
November 12, 2017 at 6:00 am
Hi Eirikur
I was able to use to the same table and get the case statement to work there however the CASE statement if not satisfied yields a NULL...
November 12, 2017 at 5:11 am
Dear Thom
My apologies for the incomplete information and yes i tried using CTEs and it works great
Thank you Paulo and Thom
Have a lovely remainder...
November 1, 2017 at 5:23 am
Dear Thom
Terminal is the column x_term_name in my table and the DDL for my table which is called xaction :
CREATE
November 1, 2017 at 5:00 am
The full query is
SELECT distinct x_term_name,Direction = ...
November 1, 2017 at 4:51 am
Yes i updated the query but the issue isnt there its with this
Msg 207, Level 16, State 1, Line 12
Invalid column name 'Terminal'.
November 1, 2017 at 4:46 am
Hi Thom
I already tried and here is my query but its not working
SELECT distinct x_term_name
November 1, 2017 at 4:40 am
Hi Brandie
First of all thanks for the reply
For the reply below:
Replicas and instances are two different things. The instance is the base SQL Server install. It...
August 9, 2017 at 11:23 pm
Hi Perry
I am reading your article and i have 3 questions.
1. On page 1 it mentions "A single database may only belong to one AlwaysOn Availability Group...
August 9, 2017 at 6:36 am
Thanks guys
I do apologize for my confusion but the final setup according to business is one WSFC spanning 2 locations using the OS as 2012 R2 and sql server 2016...
August 2, 2017 at 11:53 am
Hi Ed
So to summarize what you said:
A clustered node uses FCI correct or is the cluster using AGs? I'm still learning about clustering in sql server
If we use...
August 1, 2017 at 12:42 pm
No
1 WSFC spanning two locations with one sql server node in each location. Is this doable?
August 1, 2017 at 10:18 am
Viewing 15 posts - 121 through 135 (of 197 total)