Viewing 15 posts - 42,001 through 42,015 (of 59,067 total)
Perhaps you should also 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 9:01 am
budi.bong (9/9/2009)
How can I perform SQL SELECT FROM or given a SqlXml object?
Just a suggestion to get the right kind of help... rather than posting this on a thread having...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 8:52 am
Heh... oh, be careful, David. While it's true that sometimes the "Squeaky wheel gets the grease", it's also true that sometimes the "Squeaky wheel gets greased" if you understand...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 8:41 am
jonathan allen (9/8/2009)
Buck Woody's blog is quoted as saying 'the best' depends on circumstances. Some of us are in that predicament when it comes to training, knowledge, time and resources.
Thanks...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 1:31 am
Heh... of course, the proper way to fix this would be to correctly normalize the data with a separate company name column. But, I suspect that's not currently an...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 1:05 am
David Lester (9/8/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 1:03 am
Jack Corbett (9/8/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 12:44 am
Clint (9/8/2009)
However, the stored procedure that moves them from the staging to the main tables is always the point of deadlock.
Post that code right away...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 12:30 am
Oh my, no....
You don't need the slothfulness nor resource usage of a cursor here. I don't have access to an SQL Server this week but consider the following code...
DECLARE...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2009 at 12:17 am
PaulB (9/8/2009)
newbieuser (9/8/2009)
I do 'select rownum from table' in oracle to select rows ordered by rownum.
:w00t: No, you don't.
In the Oracle world rownum is a pseudo-column, Oracle assigns -to rownum-...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 11:48 pm
It'll take quite a while, Fraggle. I won't even be near a computer with SQL Server on it for another week.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 9:27 pm
Silverfox (9/8/2009)
Roy Ernest (9/8/2009)
Hey Fox, That was a low blow...:hehe:😛 Go jeff 😛
It's ok... you can stand up now. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 9:24 pm
Tim Peters (9/3/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 9:08 pm
Silverfox (9/8/2009)
Do you know that your surname also spells Demon, not trying to say anything here. but your comment gives me cause for worry...
Damn... I've been found out... let that...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 2:11 pm
nick (9/8/2009)
Thanks for the example, but I think you have missed the point that my date isnt one standard datetime field, its actually made upof two columns, date and time.
Add...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2009 at 1:47 pm
Viewing 15 posts - 42,001 through 42,015 (of 59,067 total)