Viewing 15 posts - 1,996 through 2,010 (of 3,738 total)
No ideas?:crying:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2011 at 9:36 am
Thanks @@ZZartin. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2011 at 9:22 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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 18, 2011 at 11:03 am
I found what I needed.:satisfied:
SELECT *
FROM Company AS co WITH (NOLOCK)
LEFT JOIN ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2011 at 1:52 pm
Doesn't is use SMTP Mail?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 12, 2011 at 6:58 am
I had to change the Debug Option 64bitRuntime to False and I no longer get the error.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2011 at 8:09 am
Viewing 15 posts - 1,996 through 2,010 (of 3,738 total)