Jeff Moden

Forum Replies Created

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

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
RE: Problem with Dates !!!!!!!!!!!!

Shadab Shah (12/25/2013)
I am trying to store the value return by the select in variable. I took that variable as varchar as well as date but nohing seems to work.....
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)

January 1, 2014 at 11:57 am

#1676745
RE: Flat File validation of 20+ fields

tom.sage 70179 (1/1/2014)
...into a Table with ALL fields set to varchar(255) so there will be no validation errors during loading
THAT would be the primary problem. From the sounds 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 11:23 am

#1676741
RE: will i be able to extract the year stamp from these strings?

polkadot (12/31/2013)
Hi folks, I need to know if it's possible, with T-SQL, to extract the year stamp from strings as variable as the following:
iMac (21.5-inch, Late 2013)
iMac (27-inch, Late 2013)
20-inch/17-inch...
--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 11:16 am

#1676740

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