Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,886 through 3,900 (of 59,087 total)

Reply To: When divide missing values from two tables it not display ?
Thank you for the readily consumable data. This should do it for you and it contains some protection from "Divide by Zero" issues...
```
 SELECT   companyid...
```
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
February 21, 2022 at 10:43 pm

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

yrstruly wrote:
I would like to match this source table: CREATE TABLE [dbo].['TMI Sites $']( [Advertiser] [nvarchar](255) NULL, [Designated Market Area (DMA)] [nvarchar](255) NULL, [DV360 Site] [nvarchar](255) NULL, [Impressions] [float] NULL,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 10:14 pm

#3986594
Reply To: Lots of data + HierarchyId performanceproblems

Can you post the CREATE TABLE statement for the table, please? I might have a time-saving idea for you if the structure is right for it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 10:11 pm

#3986591
Reply To: Performing String Split on items which have been String Split
[EDIT] I just noticed that this is almost identical to @kaj's good code.
This should help and it will also help prevent mistakes with spaces (like ratbak also helped prevent in...
- This reply was modified 4 years, 6 months ago by Jeff Moden. Reason: I just noticed that this is almost identical to @kaj's good code
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
February 21, 2022 at 9:05 pm

#3986590
Reply To: lead and lag records

Shree23 wrote:
Attached excel sheet
See above.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 8:23 pm

#3986572
Reply To: lead and lag records

Shree23 wrote:
Table is attached in excel sheet due to format issue
Please see the article at the first link in my signature line below for how to post "readily consumable" data...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 8:15 pm

#3986571
Reply To: show percentage between 2 fileds

Bruin wrote:
Can you elaborate?
Thx.
Sure. Do a search for SQL Injection and try some of the methods for the way you're using @Table2 and @ColName. @Table1 may not have the same...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 8:07 pm

#3986567
Reply To: SQL Files open in a new SSMS instance

In my case, I had to right click the icon in the actual windows menu, then click on "More", and then click on "Open File Location" and that took me...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 8:01 pm

#3986566
Reply To: List 4 row into 4 column with same ID

Please see the following article if you want to know more about CROSSTAB queries and how they work.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 9:30 am

#3986286
Reply To: How to shrink LOB data in sql server 2017

@olegserdia
Check the page density on the Clustered Index for your big table that you deleted images from. Because you used the IMAGE datatype, they should have gone "out-of-row" but it's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 9:26 am

#3986284
Reply To: SQL Files open in a new SSMS instance

evans911 wrote:
This is a recurring pain for many regardless of the version of SSMS! After struggling with this inconvenience for too long and striking out in Google, I found a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 1:19 am

#3986161
Reply To: show percentage between 2 fileds

Please consider the possibility of SQL Injection, especially on @Table2.

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 21, 2022 at 1:03 am

#3986160
Reply To: When update table small number of rows it take too too much time how to handle ?

It looks to me like you're forming a ton of accidental cross joins in the form of many-to-many joins because of the insufficient join criteria of partid = partid.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 18, 2022 at 7:34 pm

#3985573
Reply To: Need some example or answer for this doc

Michael L John wrote:
Oh, great. So you found someone else's work to turn in as your own for a school assignment.
Heh... he's late. The document says that it was due in October...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2022 at 9:20 pm

#3985114
Reply To: IoT Pros and Cons

Ed Wagner wrote:
I think what concerns me most about the IoT is security. They have lightbulbs and thermostats that connect to your wireless network. They call to their home server and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 17, 2022 at 9:10 pm

#3985112

Viewing 15 posts - 3,886 through 3,900 (of 59,087 total)