There's already a far easier way to do this with EXEC.

EXEC('PRINT 4+5*6-3' )

or

EXEC('SELECT 4+5*6-3' )

Nice little eye opener Jeff, thanks.

I particularly like :

Can I quote that the next time I see another question like:

"How...

Your problem may be this bit of the where clause

(@Service = '<No Selection>')

Now that @Service is multi-value, I think you will need to do something different here.

(sorry can't work out...

samehzagloul (12/9/2010)

[font="Courier New"]Did you try the...

samehzagloul (12/9/2010)

[font="Courier New"]Did you try the...

No they're not columns, they're types, user defined types.

In the Object Explorer window in SSMS.

Open Programmability->Types->User Defined Types

and you'll see them.

The problem is that the join in the query is...

Try this http://sqlfool.com/2010/04/index-defrag-script-v4-0/[/url]

Good question, thanks.

Further info on size limits can be found here

Nice Jeff, very nice indeed.

Now, all I need is to find somewhere I can use this 🙂

No, because it will also return tables called '#testvm_something' etc. as was explained earlier

Not quite.

It was mentioned in an earlier post that using LIKE and wildcards may return more than one record...

As Lynn implied, SQL is not the place to to this.

The correct way to format the data is to do it in your PHP page, and there should be no...

Indeed there are 🙂

This is my way:

select crdate,[Name] from sys.sysdatabases where name = 'tempdb'

Why does this work?

Well... every time you MSSQL Starts,...

Alternatively:

SELECT TOP 1 login_time FROM master..sysprocesses (NOLOCK)

ORDER BY login_time

Since I've noticed that on some of our SQL servers spid 1 is not the longest running process!

How, I don't know!...

The casts may be the cause, but can't tell without smple data.

What are the values for MonthPop in each of the tables?