Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,116 through 11,130 (of 59,099 total)

RE: insert the records in Table 2 whenever the records delete in Table 1.

That'll work but, if you ever need to disable that particular functionality (especially temporarily), you'll need to do a code change rather than just disabling (or dropping) a trigger.
--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)

October 1, 2018 at 8:04 am

#2007506
RE: Can i sort a cross tab horizontally?

More seriously, if you want some coded help, you need to provide a bit more information and it would really be nice if you could help us help you by...
--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)

October 1, 2018 at 8:00 am

#2007503
RE: Can i sort a cross tab horizontally?

jeffshelix - Monday, October 1, 2018 7:17 AM
i have a report that shows top 20 sales each month for the past 12...
--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)

October 1, 2018 at 7:59 am

#2007500
RE: insert the records in Table 2 whenever the records delete in Table 1.

adisql - Monday, October 1, 2018 7:46 AM
Hi,
I would like to insert the records in Table 2 whenever the records delete in Table...
--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)

October 1, 2018 at 7:56 am

#2007499
RE: Need help in writing Query

Prakash-485822 - Sunday, September 30, 2018 6:25 AM
Need help in writing query. I table Requestdetails which contain the below data.
Pkey RequestId StateName ResolverGroup DateCreated
1 123 Resolved 29 9/27/18 15:16
2 123 Acknowledge 29 9/27/18 15:16
3 123 Assign...
--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)

October 1, 2018 at 7:09 am

#2007493
RE: Give Up on Natural Primary Keys

I've been through several bank acquisitions by other banks and how it affects our data. I WISH that people had been smart enough to use only the surrogate keys that...
--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)

October 1, 2018 at 6:55 am

#2007491
RE: Are the posted questions getting worse?

It was an absolute pleasure to meet you in person, Eirikur! Thanks for making the trip!
Sorry about my pictures... I actually was smiling! 😀
--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)

September 30, 2018 at 10:38 pm

#2007450
RE: Fitting Into RAM

christopher.ivens - Wednesday, September 26, 2018 10:17 AM
djackson 22568 - Wednesday, September 26, 2018 7:25 AM
--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)

September 26, 2018 at 6:28 pm

#2007176
RE: Fitting Into RAM

Steve Jones - SSC Editor - Wednesday, September 26, 2018 2:29 PM
christopher.ivens - Wednesday, September 26, 2018...
--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)

September 26, 2018 at 6:19 pm

#2007175
RE: How to use HASHBYTES function in sql server for multiple columns

vikasjagadale8 - Wednesday, September 26, 2018 12:38 PM
I appreciate the information about which algorithm to use. But any help on the actual...
--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)

September 26, 2018 at 1:10 pm

#2007147
RE: How to use HASHBYTES function in sql server for multiple columns

DesNorton - Wednesday, September 26, 2018 12:23 PM
Sorry for butting in, but the deprication is documented.
According to HASHBYTES (Transact-SQL)
Beginning...
--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)

September 26, 2018 at 12:54 pm

#2007146
RE: Renaming a Schema in SQL Server

Steve Jones - SSC Editor - Tuesday, September 25, 2018 11:29 AM
That's true. I didn't cover dependent objects. I assume if...
--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)

September 26, 2018 at 7:27 am

#2007075
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

jkramprakash - Wednesday, September 26, 2018 4:50 AM
i made some changes in the query.actually i created clustered index for three columns for...
--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)

September 26, 2018 at 5:56 am

#2007059
RE: Database email functionality

nimmagaddakrupanandh - Wednesday, September 26, 2018 1:40 AM
But if i gave my mail ID in reply email also ,that failled items table...
--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)

September 26, 2018 at 5:28 am

#2007053
RE: Fitting Into RAM

christopher.ivens - Tuesday, September 25, 2018 12:57 PM
We've been discussing REDUCING our RAM on a test box and leveraging the flash drives...
--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)

September 25, 2018 at 2:54 pm

#2007014

Pkey	RequestId	StateName	ResolverGroup	DateCreated
1	123	Resolved	29	9/27/18 15:16
2	123	Acknowledge	29	9/27/18 15:16
3	123	Assign...

Viewing 15 posts - 11,116 through 11,130 (of 59,099 total)