Viewing 15 posts - 421 through 435 (of 587 total)
I have a dirty diaper, will that work? Rolled up it has some good heft, left open it can subdue a crowd... and my supply seems limitless.
(RE: weapons...
March 20, 2009 at 5:47 am
You are more than welcome to The Thread. We all started with little knowledge and we all still have people who know more than we do.
I have to ask...
March 19, 2009 at 7:52 am
Derek Dongray (3/16/2009)
If you look in SSMS Options under Query Execution, you'll find that the GO batch separator can be changed.I wouldn't recommend it though.:D
Yeah - I can see someone...
March 16, 2009 at 11:36 am
When you submit a QOD, you don't get to pick whether radio buttons or check boxes are used. If there is more than one right answer, it puts up...
March 13, 2009 at 5:11 pm
Yes, that is what I would like to do - have it open in the SSMS that is already running. Right now it opens a new SSMS everytime I...
March 6, 2009 at 5:13 pm
webrunner,
.786 isn't a valid millisecond for the datetime datatype...
All datetimes end in either .xx0, .xx3 or .xx7
.xx9, .xx0 and .xx1 are rounded up/down to .xx0
.xx2, .xx3, .xx4 are rounded...
March 4, 2009 at 9:56 am
The result depends on whether or not any rows have been inserted into the table since it was created. If there haven't (like in the first reseed), the next...
March 3, 2009 at 8:35 am
Gaby Abed (2/27/2009)
use AdventureWorks
go
declare @tableA TABLE(col1 int, col2 int)
go
--stmt 1
select name from tempdb.sys.tables where name like '%tableA%'
--stmt 2
select name from...
February 27, 2009 at 8:28 am
That's what I was afraid of. I know if the job is still running when the schedule wants it to start again, it doesn't kick off right after finishing...
February 25, 2009 at 4:47 pm
The job doesn't have to be scheduled. I did something like this with replication where the post-replication script just runs sp_start_job 'JobName'
I thought about that, but was worried about...
February 25, 2009 at 10:00 am
First run I combined the loop and job options, kinda taking a page from the replication notebook. I created a stored procedure with the loop and delay so that...
February 25, 2009 at 9:56 am
Thanks RBarry, Matt, Ramesh and Jeff. This is good stuff, and exactly what I needed.
Chad
January 16, 2009 at 9:12 am
Very nice Ramesh. I think that might work for me. Thank you for your help!
Chad
January 15, 2009 at 9:39 am
use the ISNULL() function to replace the null values with an empty string.
January 15, 2009 at 8:09 am
Viewing 15 posts - 421 through 435 (of 587 total)