Viewing 15 posts - 1,996 through 2,010 (of 3,738 total)
No ideas?:crying:
December 23, 2011 at 9:36 am
In the following example, XYZ8066402 & ABC9032405 do not have the green arrow but 673343 does.
XYZ8066402
ABC9032405
673343
If the column starts with a character there is no problem.
December 21, 2011 at 1:32 pm
I found an example on the internet with a visual and I was able to get to the table properties and add the report.
December 21, 2011 at 9:12 am
I'm having trouble selecting table properties.
I can easily get Report and Column Properties but I can't select the table properties. There are a lot of columns and I have to...
December 21, 2011 at 8:38 am
I have drill down enabled and the Subtotals and Totals are currently in the Report Header and Group Headers.
December 21, 2011 at 8:34 am
I do not want a interactive sort.
I tried it but when I clicked on the Sort Arrow it collapsed the grid.
I was to sort three columns, AccountCode, AssociateCode and TransactionDate...
December 21, 2011 at 8:16 am
subbareddy542 (12/17/2011)
declare @Year intdeclare @mon int
declare @Main datetime
set @year=2012
set @mon=3
set @Main=convert(datetime,conert(varchar(10),@year)+'-'+convert(varchar(10),@mon)+'-'+'01')
select convert(varchar(10),dateadd(ss,-1,dateadd(mm,1,@Main)),120)
Your code will produce an error, syntax error on conert(varchar(10)
Modified code:
declare @Year int
declare @mon int
declare @Main datetime
set @year=2012
set @mon=3
set...
December 18, 2011 at 11:03 am
I found what I needed.:satisfied:
SELECT *
FROM Company AS co WITH (NOLOCK)
LEFT JOIN ...
December 16, 2011 at 10:15 am
That is what I thought and I was trying to convince someone that just because their Send Mail Task Starting working it had nothing to do with Database Mail which...
December 15, 2011 at 2:20 pm
Please confirm whether or not the SSIS Send mail Task is or is not related to Database Mail.
Correct me if I'm wrong but the Send Mail Task does not use...
December 15, 2011 at 1:52 pm
Doesn't is use SMTP Mail?
December 15, 2011 at 1:20 pm
Why would you want to import the data from a CSV, then match on the SSN and/or DOB and turn around and export back to a CSV?
What is...
December 13, 2011 at 2:15 pm
Koen Verbeeck (12/12/2011)
Welsh Corgi (12/9/2011)
I had to change the Debug Option 64bitRuntime to False.
You should also do that when you are not using CozyRoc but regular SSIS tasks dealing with...
December 12, 2011 at 6:58 am
I had to change the Debug Option 64bitRuntime to False and I no longer get the error.
December 9, 2011 at 8:09 am
Viewing 15 posts - 1,996 through 2,010 (of 3,738 total)