Viewing 15 posts - 16 through 30 (of 30 total)
The Dixie Flatline (3/24/2010)
March 24, 2010 at 9:06 pm
The Dixie Flatline (3/24/2010)
March 24, 2010 at 8:54 pm
The Dixie Flatline (3/24/2010)
March 24, 2010 at 7:36 pm
Lowell,
Thanks for the reply, I'd like to better understand why that solution works and the NOT EXISTS doesn't, it seems to me that doing an EXISTS check on the table...
March 24, 2010 at 6:01 pm
I took a look at the insert proc, but it is simply doing a standard insert into (...) values (...) with the values being passed in as variables
Perhaps I was...
March 24, 2010 at 5:52 pm
SELECT CAST((RAND()*1000000000) AS INT)
Let me know if that works for ya
March 24, 2010 at 5:37 pm
But then again, if you wanted really simple, you could just do:
...
select right(field2,1),field1,field2
from x
but I'm guessing that those numbers are made up 😛
August 5, 2009 at 3:48 pm
I was just going to suggest RowNumber as well
CREATE TABLE #tmpdta (Mat VARCHAR(25), num INT)
INSERT INTO #tmpdta (
Mat,
num
) VALUES
('Gold',111 ),
('Silver',222 ),
('Bronze',333 )
SELECT ROW_NUMBER() OVER(ORDER BY NUM DESC...
August 5, 2009 at 3:45 pm
This is a follow up (because I hate forums topics where a bunch of stuff is tried, but you never know what fixed the problem because the primary poster never...
September 24, 2008 at 7:13 am
GilaMonster (9/19/2008)
A kill or severe error should show...
September 19, 2008 at 9:58 am
I changed the time of the dbreindex to be closer to when the import job runs, and it ran successfully. Then this morning was stepping through a new...
September 19, 2008 at 7:39 am
GilaMonster (9/18/2008)
Can you do an integrity check on that DB?
DBCC CheckDB (< Database name > ) WITH NO_INFOMSGS
The command(s) completed successfully.
No errors
September 18, 2008 at 3:06 pm
I can do that, I have done a Check Table, with no errors.
September 18, 2008 at 10:34 am
Thank you to both of you, I have created my own smtp proc, but I will try Ron's suggestion when I get a chance, taking the primary web database down...
March 9, 2007 at 6:29 am
Viewing 15 posts - 16 through 30 (of 30 total)