Viewing 15 posts - 421 through 435 (of 1,473 total)
It will, a cursor doesn't change anything.
Example:
CREATE TABLE #a(id int IDENTITY(1,1), a char(1))
INSERT INTO #a(a)
SELECT 'a' UNION ALL
SELECT 'a' UNION ALL
SELECT 'a' UNION ALL
SELECT 'a'
GO
DECLARE @id int
BEGIN TRAN
DECLARE Test CURSOR...
November 19, 2009 at 9:53 am
How about adding a
CASE WHEN PATINDEX('%[0-9]%',VERISIONVAL) = 0 THEN 1 ELSE 0 END,
In fron
t of the other ORDER BY criteria (Order by anything that has a number first,...
November 19, 2009 at 8:21 am
Also, the table gives you a couple other benefits:
If you don't have any rhyme or reason for a time that is not work time (The building catches on fire and...
November 18, 2009 at 7:53 pm
Here's how I would approach it. Note that I didn't do the math on the numbers CTE, I could have overblown the number I needed, but it's a one...
November 18, 2009 at 7:45 pm
Excellent tip John, thank you. That has already led to me finding one of the many many things that need to be adjusted with this 'process'.
November 4, 2009 at 6:47 am
So far, the best I've come up with is to run a profile on the SPID and include the SHOWPLANSTAT events with the binary data, save the trace to a...
November 3, 2009 at 2:35 pm
Did you read through the blog posts that Gail linked? They explain why cached plans are not always a benefit for things like this.
November 3, 2009 at 9:11 am
Dynamic SQL would stop you fro having to update the SP. If you're unaware of the dangers of SQL injection, make sure you do some research on it before...
November 3, 2009 at 7:14 am
roelofsleroux (10/30/2009)
THANKS diamondgmYour solution works the best.
Problem is guys we are getting source safe next year so for now i need an easy and uncomplicated solution.
A couple things. Were...
November 2, 2009 at 7:24 am
I find the argument to remove options and functionality in an effort to cater to ignorant/lazy people to be remarkably silly. (No offense intended) Extend that argument to...
October 30, 2009 at 3:07 pm
I would personally look into the new DDL triggers available in 2005. You should be able to create triggers on create/alter/update for relevant objects to script out whenever they're...
October 30, 2009 at 10:04 am
I just re-installed notepad++ this morning with the intention of using it instead of notepad for all of my quick ad hoc notes to myself and possibly more. Does...
October 30, 2009 at 9:55 am
Several things about SSMS bugged me when I finally made the transition from QA. One thing that has saved it from being an unused icon again is that with...
October 30, 2009 at 9:38 am
Dave Ballantyne (10/30/2009)
Personally, i would calculate the number of seconds from 01jan1970 you are interested in andselect * from tblTest where time between X and Y
OP,
If taking this...
October 30, 2009 at 9:27 am
There's really not enough information here for us to do anything with. Take a look at this article that Gail wrote:
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 30, 2009 at 9:22 am
Viewing 15 posts - 421 through 435 (of 1,473 total)