Viewing 15 posts - 4,156 through 4,170 (of 59,067 total)
Hi Jeff
How the below code works
Sampl11=SUM(IIF(Sampl11='Y',1,0))
Thanks
With the idea of teaching a man to fish, if you want to become successful in SQL Server and T-SQL, documentation...
December 19, 2021 at 5:32 pm
Please read: Forum Etiquette: How to post data/code on a forum to get the best help
You can script table creation and inserts and copy them to the clipboard...
December 19, 2021 at 4:00 am
Hi Jeff
Below is the data
CREATE TABLE Persons (LastName varchar(255),FirstName varchar(255),Sampl11 varchar(255),Sample2 varchar(255)); Insert Into Persons values('1','A','Y','N')Insert Into Persons values('1','A','Y','Y')Insert Into Persons values('1','A','N','Y')Insert Into Persons values('1','A','Y','Y')Thanks
In the...
December 19, 2021 at 3:40 am
Maybe the best thing is to leave out the filter part of the index to avoid this whole situation.
Unfortunately, I have to agree with that.
December 19, 2021 at 3:23 am
This is pretty simple but you've been asked to provide readily consumable data before and it would mighty nice if you'd start to help us help you.
Without such readily consumable...
December 19, 2021 at 3:01 am
The EOMONTH() function returns the last day of the month of a specified date, with an optional offset. The EOMONTH() function accepts two arguments: start_date is a date expression that evaluates to a date. The EOMONTH() function returns the last day...
December 18, 2021 at 7:43 pm
we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error,...
December 18, 2021 at 7:38 pm
How's everybody? Wishing a good 2022
Same to you and everyone here 🙂
For me, 2022 brings change, after 38 years in this job, it officially ends 31st March 2022...
December 17, 2021 at 7:43 pm
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
December 17, 2021 at 4:36 pm
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
December 17, 2021 at 4:35 pm
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
December 17, 2021 at 4:35 pm
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
December 17, 2021 at 4:35 pm
See the following where Wayne Sheffield teaches the ropes on how to do this prior to having String_Agg() available.
https://www.sqlservercentral.com/articles/creating-a-comma-separated-list-sql-spackle
December 17, 2021 at 4:31 pm
Go look at the code itself. It getting hungup on something of yours might be an indication of something you've done seriously wrong to begin with.
December 17, 2021 at 4:27 pm
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
December 17, 2021 at 4:21 pm
Viewing 15 posts - 4,156 through 4,170 (of 59,067 total)