Forum Replies Created
Viewing 15 posts - 1,591 through 1,605 (of 13,874 total)
-
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...
-
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.
-
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... -
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.
-
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...
-
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.
-
Reply To: Match and No Match(Gives same output)
Can you show us a screenshot of the Lookup configuration?
-
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...
-
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...
-
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...
-
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.
-
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:
Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY
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...
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...
Reply To: Parse data from notes field
I need to parse payment data from a notes field. Example of data below. I tried the Len function but got mixed results, Any help or examples would be...
Viewing 15 posts - 1,591 through 1,605 (of 13,874 total)