Please read this article to learn how to post so that people can help you more easily.

January 16, 2017 at 10:14 pm

#1923099

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

?