Viewing 15 posts - 16 through 30 (of 2,893 total)
1. check your first row is separated by the same row separator as all other
2. from https://msdn.microsoft.com/en-gb/library/ms188365(v=sql.105).aspx: the FIRSTROW attribute is not intended to skip column headers. Skipping headers is...
February 17, 2015 at 4:07 am
karthik M (2/13/2015)
February 16, 2015 at 10:05 am
Your question setup doesn't contain enough details to help you. If you could follow the following http://www.sqlservercentral.com/articles/Best+Practices/61537/ providing exact ddl for table you have, good sample setup and exact expected...
February 13, 2015 at 5:15 am
Jeff Moden (2/12/2015)
February 12, 2015 at 8:31 am
...yes, that's true. I am not good in code tuning / optimization.
yes, that's true. I am not good in code tuning / optimization.
If there is no-one to tune this code, the only option I can suggest is to increase Connection Timeout...
February 12, 2015 at 6:32 am
... (if select into answer, ask why it would be problematic if the data set is large).
BTW, if I would hear that back from interviewer for SELECT INTO answer, it...
February 12, 2015 at 4:58 am
I have a table with code and description as belowcreate table isin_code(code varchar(5),code_desc varchar(255))...I want to identify the list of alt codes available in the table.Inputs are welcome!
I have a table with code and description as below
create table isin_code
I want to identify the list of alt codes available in the table.
Inputs are welcome!
If you need...
February 12, 2015 at 4:32 am
Also, note: CONCAT() is not an aggregate function.
If you aim is concatenate string values from different rows to single string, google for "concatenate string FOR XML PATH"
January 22, 2015 at 4:34 am
Can you also let me know without using WINSCP- SQL 2008 R2 using SSIS how can this be achieved as there is no SFTP Task available....
January 22, 2015 at 4:30 am
"C:\Program Files (x86)\WinSCP\winscp.com" /command "open sftp://testsftp:testsftp@localhost" "lcd C:\Destination" "get *.* "
Is there any other...
January 21, 2015 at 10:34 am
Just shoot in the air...
Are you trying to do FULL OUTER JOIN ? :
select CurRank = row_number() OVER (ORDER BY cr.CurScore desc)
January 21, 2015 at 8:56 am
Could you please post DDL and sample data (insert script) for your issue.
Also, could you please specify what exactly wrong with current "results" and what your real expected results are...
January 21, 2015 at 8:51 am
There are always better ways...
You should read this:
January 21, 2015 at 8:37 am
It has nothing to with T-SQL.
You need to build the file name you want using whatever script language you are using.
If for any razy reason you doing it...
January 21, 2015 at 8:07 am
... I think the upper case ID in ProductID makes is stand out a bit more when reading it.
To really stand out it should be named as:
January 21, 2015 at 7:04 am