I think the problem is that the cert tests are often behind the development of the test. I have not even attempted a cert since Windows NT and one...

Can you explain what is not sorting in the right order?

Given that you said you were new take the following example

create table #Example_data (Tran_dt datetime,Sales_amount decimal(6,2))

insert into #Example_data

select '03/20/12',100.00

union

select '03/21/12',200.00

union

select '03/22/12',200.00

union

select '04/11/12',300.00

union

select '04/2/12',250.00

union

select '04/3/12',100.00

union

select '04/20/12',400.00

union

select '05/12/12',200.00

union

select '05/13/12',600.00

union

select '05/15/12',100.00

union

select '05/16/12',150.00

union

select '06/1/12',200.00

union

select...

While the where clause can easily be adapted to include three months the real question is in the group by statement. Also do you want an average over through...

I would suggest you looking into replication services and log shipping and examine those to options. With replication services you could infact be realtime.

If you right click on a test box in a report design you can choose TextBox Properties and then you should be able to define the format.

There are many solutions and also several questions. when you say you are doing a datawharehouse are you just moving the data from tableA in the source to TableA...

Does anyone have any oppinoin on this?

Yeah automatic updates are on that was one of the first things I checked. I was a little surprised when I got the different results which was why I...

I have actually read all those already. What I did not see and have not found an answer for was why was a reboot of SQL server needed before...

So I have a bit more information. It seems if I have peaced the information together correctly that and index rebuild during reqular maintenace can cause the text catalog...

write the records as a string and add them to a variable as I did in my example this will cause the ouput of the variable to output one long...

Hopefully this will give you some ideas.

declare @tmp table

(test1 varchar(5))

insert into @tmp

select '1234'

union

select '4321'

union

select 'abcd'

union

select 'dcba'

Declare @teststrng varchar(100)

set @teststrng=''

select @teststrng=@teststrng + test1 + '|' from @tmp

select @teststrng

I would probably simply create a default template file with BOF already in it then simply open that to dump my ouput in. you can add in a renaming...

Nevyn (8/3/2011)

---

Dan.Humphries (8/3/2011)

---

Nevyn (8/3/2011)

---

cengland0 (8/3/2011)

---

GSquared (8/3/2011)

---

Government's role in human civilization is application of force. So, the moment it moves outside of defense against force, it turns into a problem,...