sure enough... must be getting old... forgot that my Tally table is indexed, so that caused me to overlook it.

Definitely need an ORDER BY clause! TOP VALUES without an...

Here's an example... I'm just creating a bunch of dates from a table of numbers.

SELECT TOP 1 SomeDate, N

FROM

(SELECT DATEADD(dd,n,'1-1-2010') AS SomeDate, n

FROM dbo.Tally) x

WHERE SomeDate<=GETDATE();

What you want is...

If you're using 2012, then you can use PARTITION and COUNT, then you don't need GROUP BY.

robert.wiglesworth (1/30/2014)

---

I am trying to create a query that will give me customer and order information the scenario is this:

TableA has customer information such as:

CustomerNumber

Firstname

Lastname

Address

City

State

Zip

TableB has order information...

This post might help a little:

They discuss calling SQL Server stored procedures from an Access front end. One of the last commenters is Van Dinh, who at least used...

Does this work? The SQL returns what I want it to...

DECLARE @sql varchar(1000); -- just a variable to stuff the completed SQL statement into.

declare @curDate nvarchar(8)

declare @filePath VARCHAR(500)

set...

If you do this in Reporting Services, it's simple.

create a data source that points to your database,

then a dataset that points to this query

then add a tablix and add a...

You can create one "outer" report that acts as a container for the subreports, and then use a tablix for the subreports (or just place them, if you want) ...

, i have tried to use sub reports but not able to split the data within subreports for specific customers.

If your main report is just (CustomerID, CustomerName, OrderCount, OrderDate)

and your...

The query is basically "asking" which column to total, and then setting the query up to accomplish that. It's just a slightly more advanced version of using parameters.

It's saying...

need to write IIF condition; like if labor then populate VendorNo information and right side is inoviceamt information data below) we need to pull data

If Labor THEN what?

Sounds like you...

Could you post some data as a UNION query or a CREATE TABLE and then some INSERTs... (Not millions, just enough to get an idea of what you're dealing with.)...

I saw the first part and thought... oh, use STUFF...

and then I saw the odd requirement (show all permutations)

Here's the sample data part I did from the example... since he's...

Never thought I was qualified for it anyway. =)

After coming up with one answer, I looked around at all the other options, and that one is probably the worst. ...

I don't see any reason why you couldn't create a @FileName variable or similar and just build the string in pieces, and then use it in a loop to process...