I believe that will only be the BIDS version (only useful for SQLServer Business Intelligence projects, such as SSIS).

So you'd need to upgrade that to the full version if you...

If you really need your results in columns rather than rows, you can either use the PIVOT command or emulate a PIVOT using CASE statements (useful in pre-2005 versions of...

I always used to handle the EndOfLastMonth problem by stripping the Month and Year out of the date as strings and using them to build the FirstOfNextMonth date, then using...

Thanks for the correction, Gail. I meant to use OUTER APPLY in my query but didn't double-check my post carefully enough.

I have the luxury of a database with most table...

Just for diversity's sake you can also use CROSS APPLY to accomplish this. It may just be a Coke vs Pepsi thing but I find this way a bit more...

In the spirit of full disclosure I should point out that there are developers out there who see Winforms as a dying breed and would only recommend Web development (platform...

Here's my 2 cents:

Access: With Access you are relying on the Jet db engine, which in my experience is inferior to the engine supplied in SQL Server; I find the...

You can set the default policy to restrict each user to only one session on the TS box. The setting is called "Restrict Terminal Services users to a single remote...

In line with what I've been reading from many of the posters in this thread, my experience with outsourcing has been largely negative. In my case, the main objective behind...

I'm happy to help, Richard.

And I see your point about the division managers wanting to take care of those above; the reluctance to fight for the right way to do...

Rather than focus your argument on why Spreadsheets Are Bad you may want to focus on the advantages gained by using a RDBMS:

Organization can share a common data structure that...

Oooh, I want to play;

Going Through the Code Feeling Bad – Grateful Dead

I Can Run Queries Now (The Blocks Are Gone) – Johnny Nash

Got My GIGO Working – Muddy Waters

Index...

I'm lucky in that I'm at a shop that's small enough for me to be both a manager and a developer/admin. If I could only do one or the other...

Just an observation:

The SELECT has LIKE in the WHERE clause which implies that the @Page_name has a wildcard (%).

But when INSERTing the page @Page_name is sent in intact (which seems...

Slight variation on the last post:

DECLARE @STR nvarchar(100)

SET

@STR = 'c:\test\backuptest\test\test.mdf'

SET

@STR = REVERSE(@str)

SELECT

REVERSE(LEFT(@str, CHARINDEX('\', @STR) - 1))