Phil Parkin

Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 13,838 total)

Reply To: LAST MAX 2 DATES

Shree23 wrote:
when i have added 2 rows and max 2 rows is giving '2021-02-19' only one record
('577', '-1', '0', '2021-02-19');
('577', '-1', '1', '2021-02-20');
For me it gives 2 rows.
As you have...

February 28, 2022 at 9:57 am

#3990113
Reply To: SQL Logic for time dependent role mapping

Based on your sample data, this works, I think. I suspect that more refinement will be required to make it work with actual data. Please post sample data in consumable...

February 26, 2022 at 5:48 pm

#3989614
Reply To: Summary Report

Which reporting tool are you using?
If you want a code solution, please provide sample data and desired results in a consumable format.

February 26, 2022 at 10:57 am

#3989425
Reply To: LAST MAX 2 DATES
Shree23 wrote:
Here is required output
('577', '-1','1','2021-02-14');
('563', '-1','1','2021-02-13')
```
DROP TABLE IF EXISTS #Table_1;

CREATE TABLE #Table_1
(
    div_id NCHAR(10) NULL
   ,customerid NCHAR(10) NULL
   ,div_status...
```
February 24, 2022 at 8:25 pm

#3988508
Reply To: LAST MAX 2 DATES

I don't need to see your query. What we need to see are your desired results, based on the sample data provided. You seem unwilling to do this.

February 24, 2022 at 8:10 pm

#3988506
Reply To: LAST MAX 2 DATES

Shree23 wrote:
can not select top2 logdate along with other columns when really not required
That is confusing.
Based on your sample data, please provide a screenshot of the results you would like...

February 24, 2022 at 3:59 pm

#3988369
Reply To: LAST MAX 2 DATES

Shree23 wrote:
Please do not use top(2) . i can not use in my existing query ..help me with alternatives
Please explain why TOP (2) is not to be used.

February 24, 2022 at 2:53 pm

#3988305
Reply To: Match and No Match(Gives same output)

Can you show us a screenshot of the Lookup configuration?

February 23, 2022 at 1:06 pm

#3987438
Reply To: Match and No Match(Gives same output)

yrstruly wrote:
My data source is an excel file which i imported to sql server.
So what? The advice provided by Ed B is sound. Perhaps...

February 23, 2022 at 11:28 am

#3987403
Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY

Well, there is something that you can do. Whether it helps you at all is a different matter, but I'll mention it just in case.
If you do the following, your...

February 21, 2022 at 4:07 pm

#3986473
Reply To: show percentage between 2 fileds

I ended up with something like this. Do you see any issues I would run into?
As I have completely failed to grasp what it is you are going to be...

February 21, 2022 at 3:54 pm

#3986465
Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY

I believe that most people structure their table definitions with key columns first, which may explain why I have never seen this behaviour before.

February 21, 2022 at 2:09 pm

#3986425

Reply To: Parse data from notes field

That means you have some data which does not follow the convention. You can avoid the error by filtering out the rows which do not match, like this:

February 21, 2022 at 2:06 pm

#3986423

Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY

darius.england wrote:

Hi Phil.

Many thanks for coming back on this. It drives me crazy...

It happens at least in VS 2019 and 2020, which I've checked. I have several tables with such...

February 21, 2022 at 1:28 pm

#3986380
Reply To: Parse data from notes field
If the data really is as well structured as your examples suggest, the following should work. If not, something more refined will be required.
```
DROP TABLE IF EXISTS...
```
February 21, 2022 at 1:03 pm

#3986377

Viewing 15 posts - 1,546 through 1,560 (of 13,838 total)