You need to be specific about your desired result. Are you looking for a simple decimal value with a unit of...

In your original post the words "concatenate" and "format" implied you were looking for a character result. You...

8:35AM to 8:18PM is over 12 hours? Is there a timezone difference here I'm not aware of?

The time difference is 11 hours 43 minutes. 11 + 43/60 =...

I had assumed you wanted a formatted string, if you just want the decimal value then simply multiply the date difference by 24 (CAST to FLOAT required to allow multiplication)....

The biggest issue I remember when upgrading to Windows 2003 was with linked servers. Windows Server 2003 has tighter security, and it requires Kerberos authentication to allow multiple hops...

Try this:

print 'nv'+replace(@var1,nchar(222),'a') ----- Outputs: nva

print 'v'+replace(@var2,nchar(222),'b')----- Outputs: vb

You are attempting a double-byte character replacement, so it only makes sense with nchar arguments. If either of the arguments is...

DECLARE @in DATETIME, @Out DATETIME, @Span DATETIME

SET @in = '2009-07-13 7:53:00 AM'

SET @Out = '2009-07-13 4:04:45 PM'

-- Full hours and minutes (no rounding)

SET @Span = @Out - @in

PRINT REPLACE(CONVERT(CHAR(5), @Span,...

You need to have separate config files for dev and prod. How you store them is up to you, but one suggestion would be to use _dev and _prod...

If you run bcp via xp_cmdshell, it will be executing on the server and can write a file to your PC only if you have set up a writeable share...

If you implemented the config trigger and history table, it should show you what happened. The only explanation for resetting EnvironmentEnum to 0 it that all the configuration settings...

It is a triangular join, but without knowing more about the data I'm just guessing that there are a relatively small number of notes for each bug. Also, the...

Sorry, I got here through "Active Threads" and didn't notice that it was 2000.

You can use a self-join solution, although depending on your rowcounts and indexes this may be a...

So you're saying you have to count all the notes for an incident, and the sequence number of the one you're looking for is in the Custom_1 field? Sounds...

One option is to add additional files to the primary file group. SQL Server will automatically spread data pages around as they are rewritten, but you have no control...

You don't say what NoteID is the one you want to update. This query assumes it's the largest one, if you have other criteria maybe you can figure out...