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...

In addition, you can use the long data type in case you experience any issues there. Also you can give your variable inside the task a more friendly name

INSERT INTO...

An advantage of a for each loop is being able to count how many files you imported from with a script task in the same loop. I didn't see that...

Hi - Maybe I misunderstood but I read you need all five variables set to 1 before the next task in question should execute. In your code I see all...

In regard to operators, just quickly concerning negating operations, ie... someColumn <> 'string' ,

don't forget that rows with a null in that column will not be returned. I just use...

If you want to transfer data from server 1 to server 2, you can create a linked server connection object on server 2 that point back to 1. From there...