I can really appreciate the fact that a company has the guts to admit to their user community/clients that a mistake has been made and, even more important, will be...

I appreciate the effort the author has made to install and test the utility and write an article to inform his fellow Sql Server professionals.

But showing that the utility presents...

Hi Tudor,

I agree with the answers of both Steves, but I'll elaborate a little on them:

- it makes no difference if you join the "many column tabel of which you...

You could also consider the use of triggers with code like (I'll assume you know what to do once you've got the number of rows inserted,updated or deleted):

select @numberOfRowsInserted =...

This is an alternative solution to Sean's, I did a little digging around (look in BOL under the subject CONVERT):

select * from MyTable

where convert( datetime, convert( varchar, MyDate, 106...

Ok, then maybe this is - or at least looks like - what you need,

this is VBScript code (not tested(!), I used hyphens to show code indenting, these should be...

Maybe this is what you're looking for?:

declare @whatToDo varchar(30)

select @whatToDo = [type]

from buttype

if @whatToDo = 'full'

begin

/* backup code here */

end

else if @whatToDo = 'incremental'

begin

...

Yep,

I did get a point for a wrong answer, but I noticed it was incorrect when I tried to see what happened if the temporary table was created with dynamic...

Hi Adam,

I don't have a use case for a very large document, but is was the use of the text type that triggered the idea of very large content. I...

Hi,

What I like about this "Ultimate Substring Occurrence Counting" solution (follow link in article) is the @noisepattern option and the "set oriented" as opposed to procedural angle. I do have,...

Ok, it may be a bit exaggerated, but I would like to extend Kelvin's quote to "We do not all use the gregorian calendar"

I've personally never encountered the need for...

I think that what Neil is referring to is that the question assumes that de date format on the database server is mm/dd/yyyy. I noticed this too.

This question concerns...

Hi Russ,

I think this should do the trick. If not I must have misunderstood you, so please clarify.

select a.raccount, b.classification

-- count the number of visits

--...

Hi Markus,

I think I've found a way to get the results you're looking for in a single query. If you like you can substitue the first view in the second...

Hi yaip,

I discovered a minor flaw in the previous code when new records contain sequence numbers that are greater than the existsing numbers (if a gap in the DisplaySeq values...