The measure example does NOT meet the specified customer requirement - that the ratio cell where Internet Promo sales are blank should read "NA" rather than blank. This in turn...

Hi, Steve,

I'm not sure if this is exactly on-topic - but it sort of fits in between "running SQL on in-house servers" and "running SQL in the clouds". Is it...

Brad,

The SQL Server Users Group in Atlanta is pretty active, and provides a lot of the things you mention in your post. I think one of the best features is...

UPDATE2: Doh! Just a typo in one of the variable names.

Still, is there any way to put the script in a script task into debug mode when executing the package,...

Have you been successful at attaching these files to your database server? If not, what problems are you having now?

-ef

Here's a powershell script that might be of use (I'm a novice at Powershell, but this is what it's good at...)

$a=get-date

$t=new-timespan -hours 1

$a=$a-$t

get-childitem -path t:\|where-object -filterScript{$_.LastWriteTime -le...

Senthil,

Is your question:

1) How do I set up the data model (tables, fields, relationships) to efficiently store (and retrieve) the incoming data? or

2) How do I handle the incoming data...

Here's the VBA to add the validation rule (with a little help from MSDN)

-Eric

Sub addValidationRule()

Dim strTblName As String, strFldName As String

Dim strValidRule As String

Dim strValidText As String,...

Here's a Subroutine that will create your 2 tables, the primary keys, and foreign key relationships. I don't see how you can add the Validation Rule in the Create Table...

I think it's interesting that, with nearly 1000 responses, the answers are nearly split 50/50. In general, this community does get the QotD right more often than not, so 50/50...

Here is the c# code from a .net solution I wrote to solve the problem - the pseudo code is:

Open 2 connections to the server

...

Sandhya,

Implied in Jeff's response is the SQL "truism" that the order of rows DOES NOT MATTER. In fact, this is a fundamental principle of relational database design. So your question...

What platform are you using to build the website? With ASP.Net 2.0 or later, there are login and membership providers built-in that let you provide access control and member profiles...

You could do what you want programmatically from an application platform (eg., .net, classic asp, vb, c) as long as it has the ability to access SQL Server data -...

I think you should be looking at a SQL Server Agent job for scheduling your proc. In SSMS, you should see the SQL Server Agent node at the very bottom...