Do you have SQLCMD mode open for new querries?

I solved the intellisense issue by unticking the box in Tools--Options--Query Execution

Hi Gail,

Thanks for your suggestions. Checkdb is running OK now!!!!!! Without taking the instance down!!!!

Check these results:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'

I've run DBCC...

Update:

I've restored last nights backup of master as a userdatabase and run DBCC CHECKDB ALLOW_DATA_LOSS.

This solves the consistency errors.(REPAIR_FAST and REPAIR_REBUILD didn't solve anything)

I can also reindex.

What's the best...

Hi thanks for your reply,

The master has already been restored from backup. Restoring an older backup (older than 2 weeks) is not an option, because of all the changes that...

The substring functio should be:

SUBSTRING(name,1,2) = "ab"

In a more general way the FINDSTRING function might be usefull:

FINDSTRING(name, "ab", 1) == 0

You can also use the LEFT function in this case.

Hi,

Try the following expression for the visibilty property of your "values" textbox:

=(NOT Inscope("NameOfRowGroup") AND NOT Inscope("NameOfColumnGroup"))

Change NameOfRowGroup and NameOfColumnGroup to the group names of your matrix.

Try the following expression:

=iif(Fields!Stat_Qty.Value = nothing, "-", iif(Fields!Stat_Qty.Value = 0, "-", Fields!Stat_Qty.Value))

Use the Merge transformation:

make sure both inputs are sored and the metadata (datatypes of the columns) should be the same.

You're welcome

Sorry that's 1 quote too many:

select replace(Starttime, '.', ':')

Rajesh,

You've said it! Use the "replace"-function:

select replace(Starttime', '.', ':')

Hans,

Drop the single quotes and use square brackets ([]) for the "file" column ( or use them for all columns)

Having a true datetime column would indeed be much easier. However assuming that shifts don't last more than 24 hours, you could calculate the working minutes using the following expression:

WorkingMinutes:...

Have a look at the following article:

http://msdn.microsoft.com/en-us/library/ms159215.aspx

Hi Lee,

Have a look at Chris Hayes' Blog:

http://blogs.msdn.com/ChrisHays/