Viewing 15 posts - 33,331 through 33,345 (of 59,102 total)
Deee -Daah! (7/7/2011)
Directory of C:\temp\test1\test2
and then followed by...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2011 at 7:41 am
Greg,
Did you change ALL the variables to DECIMAL??? Even the "period" related INTs?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2011 at 7:22 am
Greg Snidow (7/6/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2011 at 7:16 am
thundersplash845 (7/7/2011)
Jeff, Only name column will not hold any NULL value....date may have...Thanks!!
Then there's a possibility that this could be done rather "auto-magically" using dynamic SQL. Does the name...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2011 at 7:08 am
ringovski (7/7/2011)
Jeff Moden (7/7/2011)
ringovski (7/6/2011)
Not sure you mean by DDL & DML, but here are the table specs.
Take a look at the first link in my signature line below... it'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2011 at 7:05 am
For what it's worth, here's my rendition of how this problem might be solved. It doesn't preserve dupes and it sorts the HobbyNames on each row alphabetically. As...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 11:41 pm
I decided to build a large amount of test data that more closely matches the OP's given conditions. I'll be back with a possible solution soon. Not to...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 11:17 pm
I agree with Seth with some minor changes.
1. Use UNION ALL... the code will be faster because it doesn't do an implicit DISTINCT like UNION would.
2. Second, you'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 9:46 pm
thundersplash845 (7/7/2011)
row 1 - fax column is null ,row 2&5 - e-mail and row 4 -mbl.
Here i want to eliminate all these rows...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 9:42 pm
ken_wenze (7/7/2011)
Yes - I can use the cmdshell but C:\ in that command would be the servers C:...the directory i need to gather from is on my local desktop.
Not a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 9:59 am
Craig Farrell (7/6/2011)
... anytime I dread going to a specific job (not work in general, that's an unavoidable annoyance) consistently, I...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 7:06 am
jasonwi1202 (7/6/2011)
Isn't the MAXDOP option reliant on the number of processors that the server has? Does your test server have only 1 processor?
Yes and no. MAXDOP will not magically...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 6:54 am
Jayanth_Kurup (7/7/2011)
Clustered index work better on tables which have a column that can be used to uniquely identify each row.
Non Clustered...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 6:33 am
ringovski (7/6/2011)
Not sure you mean by DDL & DML, but here are the table specs.
Take a look at the first link in my signature line below... it'll help you get...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 6:01 am
ALZDBA (7/3/2011)
It's great to see many of SSC addicts have been granted MVP once more.Congratulations to you all.
Dang... I missed this one on the first pass. Thank you, Sir....
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 5:55 am
Viewing 15 posts - 33,331 through 33,345 (of 59,102 total)