Viewing 15 posts - 31 through 45 (of 629 total)
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...
June 19, 2012 at 7:42 am
Can you explain what is not sorting in the right order?
June 18, 2012 at 2:08 pm
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...
June 12, 2012 at 2:36 pm
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...
June 12, 2012 at 1:48 pm
I would suggest you looking into replication services and log shipping and examine those to options. With replication services you could infact be realtime.
January 27, 2012 at 7:54 am
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.
January 27, 2012 at 7:52 am
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...
January 27, 2012 at 7:44 am
Does anyone have any oppinoin on this?
November 23, 2011 at 7:03 am
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...
September 16, 2011 at 11:54 am
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...
September 16, 2011 at 7:45 am
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...
September 16, 2011 at 7:28 am
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...
August 9, 2011 at 3:03 pm
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 +...
August 9, 2011 at 12:37 pm
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...
August 3, 2011 at 3:09 pm
Nevyn (8/3/2011)
Dan.Humphries (8/3/2011)
Nevyn (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
August 3, 2011 at 3:01 pm
Viewing 15 posts - 31 through 45 (of 629 total)