I don't think you understand. GROUP BY is working exactly as intended in the example you've given. When you include multiple fields in the condition it only aggregates...

So you are grouping by a bunch of different fields, each of which can have multiple values ([P1_start] can be either CONVERT(nvarchar(5), STARTTIME, 108) or ''). If you have...

As a suggestion, it will be easier for people to help you if you clean up the code that you post. For example:

USE [Sourceinfo]

GO

/****** Object: StoredProcedure [dbo].[CTTS_TIME_sp] Script Date:...

It would greatly help if you would provide a sample of data from your 'number' field.

One quick thing, you're not formatting your conditional statement correctly ...

IF blah blah

BEGIN

<do this>

<do that>

END

ELSE

BEGIN

<do...

This is a really interesting problem. I cannot think of a way to do it completely dynamic in terms of the maximum size of your combination collections and I'm...

NEWID() is to create a new unique identifier ... ordering by that function makes no sense to me. I would be curious to understand exactly what you're trying to...

My first question ... why are you using OPENROWSET to query a database on the local server? Even if you're hitting a remote server, the function is really designed...

Without knowing more detail about a lot of aspects of what you're doing and why you're doing it, it is hard to be very sure with advice, so take it...

Can you give some examples of questions you're trying to answer with your database?

I think it's worth pointing out that there are a lot of people who are here specifically because they want to find out the best ways to accomplish goals, not...

If I understand you correctly, this isn't really a SSRS specific issue. You're trying to do something and then get the results of that something before the something is...

DECLARE @test varchar(255);

select ISNULL(@test,'') MyColumn;

edit: I agree with Steve below ... why do you want to do that? Are you wanting to change the data the table contains...

Have you tried doing both parts of the process in the same stored procedure?

You can use a separate exe to watch the files and still use SSIS. The .NET languages have a built in FileSystemWatcher class so it's trivial to write a...