It might help if I add some data for you to insert...

INSERT INTO [dbo].[TEMP_COMMENT]

(

[GUID]

...

Yes, no tilde = NULL. That was intended... Thank you

I did read BOL, along with 50 other articles that really didn't help. So I figured it out on my own. I'm open to suggestions on how to make it...

Thank you everyone for the information. I appreciate it!

Let's say, for whatever crazy reason, that temp tables are not an option. Is there a problem with using VIEWS? Especially if the views can be recycled for other uses...?

That is what I ended up doing. I was trying to drag and drop the data flow and it wouldn't work. I found an online article that stated to double...

I'm going to go ahead and answer my own question. I create a temp table and inserted my SQL Statement into it. The I ran this code against it.

SELECT...

The simple fact I support working from home boils down to location. I live in the middle of nowhere, which is 120 miles from nothing. Over the last 9 years,...

Thank you Lynn, that was exactly what I needed!

Since DATE was not recognized (Type DATE is not a defined system type.), I changed it to DATETIME and used CONVERT.

CONVERT(VARCHAR(12),CAST(MIN([Rxo].[DATE_WRITTEN])...

There's a problem in the SELECT statement in the WHILE. In the JOIN, there's only one record where ( o1.employee = o2.supervisor ) and it is excluded by the WHERE...

On other comment. I might not recommend a single package do all of that. What I would most likely do if I was designing such a process is use the...

Theoretically it is possible to have an SSIS package do this. This first package could extract the data from the source system to a “staging area”. Then another process or...

This is probably the error message you are receiving, correct?

Msg 10706, Level 16, State 1, Line 27

Too many expressions are specified in the GROUP BY clause. The maximum number is...

Bhuvnesh,

Thank you for the response.

I didn't mean random like, "What is...

Hello cooljagadeesh,

Can you provide us with a little more detail please? What exactly are you trying to group?

If you're just looking for basic information on grouping, there's a...