Create...

One way might be something like this... use a CTE to select every nth record, and then graph that.

with Demo as

(

select custID

, OrderMonth

, qty

, ROW_NUMBER() over (partition by CustID order...

What kind of database is the private database? you could probably use SSIS to do it. Or a Linked Server...

Are the two datasets based on the same tables?

If they are, you could create a calculated column in your dataset that groups the "1-4" records together and the "5" records...

What version of SQL Server are you using? If you're using something post-2012(?), you have to download and install SQL Server Data Tools (used to be BIDS)... that enables you...

One option might be to use the bastard child of SQL Server - Access... (bear with me for a minute)....

Create a table in Access of (source column name, destination column...

It seems you are misunderstanding what SQL Server does with empty space in a table... It does nothing unless you tell it to.

Executing DELETE statements against a table...

To what entity to the e-mail, address, and phone number belong? Presumably a person. A student? They certainly don't look like they belong in the Fact table at...

Seriously? All of these follow a similar pattern... this one:

SELECT DISTINCT field1, field2

FROM SourceTable;

Boggles my mind you could ask a reasonably complicated question and then trip up on the part...

Could you post your code? Not sure why you have ot itereate over the results and do something... trying to figure out a way to avoid using a cursor.

INSERT INTO MyNewTable(ColumnList)

SELECT ExpressionList

FROM OldTable

?

Could you post your create table scripts and some sample data? It sounds like you have to unpack the intervals and then compare, but I'm not sure without table...

Oh, you neglected to mention that it was a vendor database. Key piece of information.

having said that, the only way I can think of helping this situation out is to...

Is there any way you can split this part of the data into a separate column?

convert(nvarchar,keyvalue) like '%11857548%'

Ideally, you'd want the 11857548 value in a column by itself so you...