Viewing 15 posts - 1,321 through 1,335 (of 8,731 total)
I have an OrgChart table that looks something like this:
PositionCode PositionName ...
May 3, 2017 at 6:03 am
@Tyson
Don't use the first code you've got. Use the best. That doesn't mean that mine is the best. That only means that you need to test both to know...
May 2, 2017 at 4:34 pm
May 2, 2017 at 1:40 pm
Here's a different option that doesn't require to pivot and unpivot. I'm using a temp table but it could be written as a CTE or derived table, although I'm not...
May 2, 2017 at 12:27 pm
This only happens when using only literals. If you're using literals, there's no need to have complex logic. So, here are some examples on how to avoid errors or how...
May 2, 2017 at 11:19 am
select coalesce(convert(varchar(10),[Days Since Account Logon]),'Unknown') as [Days Since...
May 2, 2017 at 6:22 am
We run a shared application in IIS on .net. I am looking for a...
May 2, 2017 at 6:16 am
May 1, 2017 at 7:13 am
<rant>
Have you ever encountered a situation where your company defines certain authorized software and you need to change what you've been using for so long that it's an essential...
April 28, 2017 at 11:55 am
ChrisM@home - Friday, April 28, 2017 10:22 AMROW_NUMBER() OVER(PARTITION BY Name ORDER BY Date)
Exactly, the simplest way is the best. It's...
April 28, 2017 at 10:48 am
April 28, 2017 at 7:57 am
April 27, 2017 at 1:50 pm
Here's another alternative. IMO it's more flexible as it would allow multiple columns in a single unpivot and work with the column names.
It's explained on the following article:
April 27, 2017 at 1:29 pm
Viewing 15 posts - 1,321 through 1,335 (of 8,731 total)