webskater

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 155 total)

RE: Most efficient way of not selecting data

Sergiy - Friday, May 4, 2018 4:26 AM
Have a DistributionList:ContactIdMediaId (lookup for email, post address, phone, messangers, etc.)(?) ExpiryDate
We have hundreds of...

May 4, 2018 at 5:57 am

#1989250
RE: Most efficient way of not selecting data

Thank you all for your answers. I'll try them on the real data tomorrow and see which performs the quickest.
A couple of other questions ... If I stick...

May 2, 2018 at 5:32 pm

#1989010
RE: Checking sort order and fixing it

Jacob Wilkins - Wednesday, March 28, 2018 10:19 AM
Assuming you have something in the table that identifies the task list to which...

March 28, 2018 at 12:38 pm

#1984878
RE: Checking sort order and fixing it

sgmunson - Wednesday, March 28, 2018 9:46 AM
webskater - Wednesday, March 28, 2018 9:33 AM

March 28, 2018 at 10:07 am

#1984847
RE: Checking sort order and fixing it

GilaMonster - Wednesday, March 28, 2018 6:31 AM
The first problem is, the 4th row by what? Tables have no defined order, so...

March 28, 2018 at 9:33 am

#1984837
RE: When updating one row in a table, update trigger creates 3 rows in audit table

TheSQLGuru - Monday, January 15, 2018 4:11 PM
1) Don't declare variables and put stuff into them and then use in SELECT like...

January 16, 2018 at 6:54 am

#1975977
RE: Sorting after records deleted

aaron.reese - Monday, December 4, 2017 7:18 AM
OK. you're not going to like this but that is probably not a good database...

December 5, 2017 at 7:09 am

#1970708
RE: Sorting after records deleted

Luis Cazares - Monday, December 4, 2017 6:26 AM
webskater - Monday, December 4, 2017 6:08 AM

December 4, 2017 at 6:42 am

#1970507
RE: Sorting to keep people and secretaries together

webskater - Wednesday, July 12, 2017 10:04 AM
Thom A - Wednesday, July 12, 2017 9:27 AM

July 12, 2017 at 10:12 am

#1950585
RE: Sorting to keep people and secretaries together

Thom A - Wednesday, July 12, 2017 9:27 AM
A simple change would be:
SELECT Contact, Role, SecretarysExpert
FROM (
SELECT ExpertID, Expert AS...

July 12, 2017 at 10:04 am

#1950584
RE: Sorting to keep people and secretaries together

pietlinden - Wednesday, July 12, 2017 9:18 AM
What are you going to use this for? I'm asking because in SSRS, this is...

July 12, 2017 at 9:24 am

#1950575
RE: Finding related records within the same table

drew.allen (8/5/2016)
sku370870 (8/5/2016)
drew.allen (8/5/2016)
sku370870 (8/5/2016)
Thanks for your reply. But when I am on any particular stage, all I have to hand is the StakeholderID for that stage - so I...

August 8, 2016 at 7:11 am

#1894325
RE: Finding related records within the same table

Jeff Moden (8/5/2016)
sku370870 (8/4/2016)
I do have a couple of questions, though, just to help me with design and setting up of a more substantial test to verify performance...
1. How...

August 8, 2016 at 7:05 am

#1894324
RE: Finding related records within the same table

No, I am afraid it is too late for a proper data structure. The original requirement was that Stakeholders would only be on one stage - and that where displayed...

August 5, 2016 at 11:21 am

#1894115
RE: Finding related records within the same table

drew.allen (8/5/2016)
sku370870 (8/5/2016)
Thanks for your reply. But when I am on any particular stage, all I have to hand is the StakeholderID for that stage - so I can't start...

August 5, 2016 at 10:37 am

#1894096

Viewing 15 posts - 1 through 15 (of 155 total)