I know this is an old post. But with the month extraction, I first check in the formula if the month is greater than 9, else I stuff a "0"...

I am not sure why you would not want to create the CASE statement equivalent in the where clause by using AND, OR, and () operators.

I am not sure how many rows you expect in the tables, but I think a regular int rather than a large unique identifyer will query the data faster when...

From the diagram, the ETL brings in your data from your own operation system(s) and from the outside world. This would be a good place to make sure the data...

I don't think the index is as bad as it sounds. Without a good index a process has to lock the whole table (on a table scan) instead of taking...

This is the type of problem that MDX handles quite well, if the user has an OLAP cube to query from. A date dimension and a fact table is all...

So I understand you want a different record set for every state? You can dump all the data into one table and create a procedure that pulls the data by...

Hi

So from your latest post, I gather you have a synonym to a remote table? That is, it points to a table on another database in the same machine or...

I think you need to spend a little time ensuring you have set up the mail profile and account correctly. You were given a couple of links earlier for setting...

I assume you have turned on database mail in the surface area configuration (or through a script). Have you created a mail profile?

select [name] from msdb..sysmail_profile

HI -

You can build a date hierarchy in a SSAS cube. You need a date dimension table, which is essentially a calendar table, as Jeff mentioned. From there as...

I think the reply from frfernan is your best bet. To add to that:

You need not code an exact date, You can do like

SELECT lr.*

FROM lab_results lr

...

I'd be interested in knowing if there is some activity on the export server that is using up CPU time, like a hung application not related to the database service....

You can also start a Profiler trace to get more information with events on that view object. There are a couple of event categories that may be worthwhile to look...

Quick correction to my prior post. Use the '?' as the place holder when using direct input. But you can still give the parameter a friendly name in the Parameter...