Viewing 15 posts - 26,776 through 26,790 (of 59,102 total)
Phil Parkin (5/27/2013)
Here's a link that should get you started.
The 'asynchronous' part here refers to the fact that...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2013 at 11:33 pm
Create another value somewhere that is a copy of the MAX. Increment and decrement that with the idea that "returns" will never drive the number over the MAX and...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2013 at 11:22 pm
j.a.c (5/27/2013)
Me: Your trigger is not set based. It will only process a single row.
SQL Dev (w/ 6 years exp): OK. I have created a cursor...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2013 at 11:18 pm
Steven Willis (5/24/2013)
Chrissy321 (5/24/2013)
I need help in writing a job description for a senior administrative DBA. Can someone suggest an appropriate forum on SSC.com where I can do this?
How about...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2013 at 6:22 pm
Tyekhan (5/25/2013)
Jeff Moden (5/25/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 7:49 pm
Dammit. I'm sorry. I lost track of this thread and it took me a while to find it again.
Have you found a solution for your problem or do...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 2:43 pm
Just to be clear, it's not so much "points" that people value. It's the reported percentage of correct answers that people value because it's one of those things that...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 2:40 pm
RedBirdOBX (5/20/2013)
Thanks but don't have a choice in particular scenario....
As Sean stated, you actually do and it's not just a matter of you doing a CYA. You can take...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 2:31 pm
Dird (5/20/2013)
hisakimatama (3/21/2013)
The contract could lead to full employment, so I'll give everything I've got and see if I can get hired there.
Don't do that; contractors rake it in!...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 2:16 pm
ryan.blosser (5/18/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 2:14 pm
Tim Walker. (5/21/2013)
Jeff Moden (12/6/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 1:45 pm
Thomas Abraham (5/22/2013)
The elegance of the solution to this problem in SQL is amazing. Got a warm...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2013 at 1:40 pm
Minnu (5/24/2013)
I've a table with 75+ columns and 70000 records, i want to have a backup .sql file.
am trying using SSMS > Rt click Database > Tasks > Generate...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:51 pm
I'd define the column in the table as a PERSISTed Computed column to make life easier for everyone and the formula would simply be the addition of the other columns.
As...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:45 pm
tswapnars 90250 (5/23/2013)
I am trying to add AVG(TotalValue) as AgvSales on the top of...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:35 pm
Viewing 15 posts - 26,776 through 26,790 (of 59,102 total)