Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,946 through 24,960 (of 59,102 total)

RE: Triggers for insert,update,delete in MSSQL

navimir (12/5/2013)
Could you plz let me know how to check in trigger for old value and new value so that the result can be added to audit table??
This is 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)

January 1, 2014 at 2:04 pm

#1676766
RE: Insert dates into table in the giving range.

fahey.jonathan (12/12/2013)
If you don't want to create a Tally table, you can use sys.columns instead and create a tally number in memory. According to my research, this is actually...
--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)

January 1, 2014 at 1:15 pm

#1676765
RE: SQL Thousand separator with round

fahey.jonathan (12/12/2013)
+1 for Sean; yes, formatting would better be done in the outputting program. If you have to do it in SQL, here is one option for your consideration....
--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)

January 1, 2014 at 1:08 pm

#1676764
RE: Why we used Aggregate function in pivot and cross tab queries ?

Shadab Shah (12/12/2013)
Why do we used aggregate function in pivot operator and cross tab queries . Any link to blog or video explanning my question can do.
Thanks.
The simple answer is...
--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)

January 1, 2014 at 1:05 pm

#1676763
RE: Search String(s) within a String best practice?

ScottPletcher (12/9/2013)
As long as you have fixed leading values, i.e. 'value1%' and not '%value1%',
an index on myColumn should handle the query fine. If it's a large % of...
--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)

January 1, 2014 at 1:00 pm

#1676762
RE: How to Pass date dynamically ...

sgmunson (12/16/2013)
Yeah, you definitely need to add more details here. For example, you state that you are trying to find the last "validity" situation for each date in...
--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)

January 1, 2014 at 12:53 pm

#1676761
RE: How to Read tables from Inserted table (trigger)

Minnu (12/17/2013)
Hi Team,
am having a table
Table : Test
IDNameDesc
1DDesk
2DDesk1
3XTBT1
4YTXT
having trigger on above table for insert and update, when am update above table.
udpate Test set name='DIT' where name='D'
when i execute 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)

January 1, 2014 at 12:47 pm

#1676760
RE: How to Read tables from Inserted table (trigger)

twin.devil (12/17/2013)
It not a very good idea to print data in Triggers...
Except for troubleshooting, apparently MS agrees because they've deprecated the ability to return output of a trigger to the...
--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)

January 1, 2014 at 12:46 pm

#1676759
RE: Need help to split Data

Ed Wagner (12/19/2013)
+1 +1 +1 This function performs better than any other string splitting function I've seen and performance is very linear as you run it with larger 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)

January 1, 2014 at 12:40 pm

#1676758
RE: Using xp_cmdshell and Zip Genius 6

Analyst2006 (12/27/2013)
I'm having the same issue returnning NULL...
Has this been resolved?
See my post immediately above. That may be your problem.
--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)

January 1, 2014 at 12:38 pm

#1676757
RE: high cpu

pmadhavapeddi22 (12/19/2013)
Hi
I have one stored procedure which in turn executes 3 more sps in it.
All the 4 stored procedures just update the records of two tables. Every column...
--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)

January 1, 2014 at 12:37 pm

#1676756
RE: Using xp_cmdshell and Zip Genius 6

Another possible problem is the "C:" drive.
When YOU run it from a command window, the command is referring to whatever machine you're running the command from, presumably, your desktop.
When you...
--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)

January 1, 2014 at 12:27 pm

#1676754
RE: Using xp_cmdshell and Zip Genius 6

MyDoggieJessie (1/6/2011)
Consider this command:
EXECUTE xp_cmdshell 'c:\ftpfiles\zg\zg.exe -add "C:\FTPFiles\test\butthead.zip" +"C:\FTPFILES\ZG\*.*" C9 R1'
There are no errors, just the "output" is NULL
Take the exact same command above (within the single-quotes) and run 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)

January 1, 2014 at 12:23 pm

#1676752
RE: Need help to split Data

Sean Lange (12/20/2013)
Last name is "Camps" so possessive would be Camps' 😀
Doh!!! Sorry about getting your name wrong. :blush:
Dwain must have been "camping out" just waiting for you to make...
--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)

January 1, 2014 at 12:17 pm

#1676750
RE: Help Making a Query- URGENT

Mr. Kapsicum (12/16/2013)
Hi All,
I have a Table say, 'TABLE_1'. with follwing data (Dummy Data)
RatingIDParameter_Order ProjectKeyComments
792 ...
--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)

January 1, 2014 at 12:12 pm

#1676749

Viewing 15 posts - 24,946 through 24,960 (of 59,102 total)