Viewing 15 posts - 1,351 through 1,365 (of 8,731 total)
April 24, 2017 at 9:07 am
You definitely spend more time when you touch two keys "Shift + 7" to...
April 24, 2017 at 7:40 am
April 24, 2017 at 6:21 am
Any help on how to update gender = M or F in a table that...
April 20, 2017 at 1:24 pm
sgmunson - Thursday, April 20, 2017 11:37 AMAnd didn't your Bible also state "God helps those who help themselves" ?
Err...No.
https://en.wikipedia.org/wiki/God_helps_those_who_help_themselves
April 20, 2017 at 12:37 pm
I was helping one of my new employees with a script that was being...
April 20, 2017 at 11:28 am
April 20, 2017 at 10:40 am
ParseName function has several limitations. To reduce them, here's an option using DelimitedSplit8K which is explained in here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
CREATE TABLE SampleData(
CateringStaff varchar(8000)
);
April 20, 2017 at 8:32 am
Here's a website with a free sample data generator. It has column types to give relevant data created randomly.
http://www.yandataellan.com/
When I have no access, I just...
April 20, 2017 at 6:28 am
April 19, 2017 at 2:15 pm
April 19, 2017 at 1:05 pm
This might be a slower method, but it will do exactly what you asked in your first post.
SELECT *,
( SELECT CASE WHEN s.Item LIKE...
April 19, 2017 at 11:38 am
Viewing 15 posts - 1,351 through 1,365 (of 8,731 total)