Your best bet is probably a CLI function based on .Net's Format function, assuming the format specifications in your application make sense in .Net.

You may have to add a layer...

You could also use PIVOT.

CREATE TABLE dbo.CountryTest (

Countryvarchar(50) NOT NULL,

[Level]int NOT NULL) ;

GO

INSERT INTO dbo.CountryTest

VALUES ('England', 2), ('Ireland', 3), ('Scotland', 1), ('Scotland', 2),

('England', 1), ('England',...

(Sorry for the late response, I've been ignoring my generic email because it's full of junk.)

You can configure the connection for SQL configuration several ways, including environment variables. What's...

The dev and test servers I use have copies of the production databases on separate servers, so when configuring connections the server name is different for each environment but the...

I think the reason for the only-sysadmins-can-edit-unowned-jobs limitiation is fairly well explained. Allowing non-sysadmin, non-owners to modify a job essentially gives them the ability to do anything the job...

Assuming that no other string that looks like a time can appear in your source string, you can find it with PATINDEX.

SELECT SUBSTRING(Source, PATINDEX('%[0-2][0-9]:[0-5][0-9]:[0-5][0-9]%', Source), 8)

FROM (SELECT 'sjdf;kljas;dfkjasf12:29:53jdkjsdf' AS Source)...

Another question would be whether the id_object values are immutable. It sounds like they should be, but if for some crazy reason your system updates them frequently the clustered...

How about this:

SELECT LEFT(ServerName, CHARINDEX('.', ServerName + '.') - 1) FROM Server

There are a lot of experts here who would be happy to help you, but you have to ask a more specific question and give us some idea of what...

The mantissa of a FLOAT is a 53-bit binary fraction, and it can exactly represent only rational numbers whose...

(Assuming we're talking about 64-bit SQL Server 2005 Enterprise, or 2008 Enterprise or Standard)

The "Lock pages in memory" right (granted to the user account that SQL Server runs under) is...

According to the Microsoft engineers that wrote SQLOS (and were available for questioning at the PASS conference), SQL Server responds to memory pressure by recognizing when available physical RAM drops...

Don't confuse the virtual memory system and its paging file with the SQL buffer pages. Virtual memory pages are 4 KB pieces of the memory used by the SQL...

Just to make sure we completely cover the topic:

An IDENTITY column will help you find the most recently-inserted row, unless IDENTITY_INSERT or DBCC CHECKIDENT (RESEED) are used to insert records...

The AWE setting is not required for a 64-bit server to access memory above 4GB, but it does have a slight effect.

Memory acquired through the AWE API is not considered...