Forum Replies Created

Viewing 15 posts - 10,261 through 10,275 (of 13,879 total)

  • RE: Issue with script component when used as destination

    Can you share the code inside the Script Component?

    January 1, 2013 at 6:47 am

    #1572680

  • RE: Sentiment Analysis

    How about this... Go find a random person, show him or her your copy of SQL Server, then ask how he or she feels about it.

    I thought I'd give this...

    December 31, 2012 at 12:29 pm

    #1572584

  • RE: Sentiment Analysis

    mksunel (12/31/2012)

    I want to do sentiment analysis, I need to know how I can achieve this using SQL Server?

    Oh come on. Please see the link in my signature regarding how...

    December 31, 2012 at 11:15 am

    #1572559

  • RE: Dynamic IN clause

    If you really need to do this, you might have to resort to dynamic SQL. At the moment, SQL is treating 'USA','CAN' as a single-valued list (so if the country...

    December 31, 2012 at 10:12 am

    #1572542

  • RE: How to Update Columns of a Table with two instance in one update Statement.

    Roland, I tweaked your query a little to include a WHERE clause & was consequently able to simplify the CASE construct. Also, your update needed to reference the alias (t1)...

    December 31, 2012 at 7:14 am

    #1572503

  • RE: Need To Generate XML File

    so that means Brenda Smith was subordinator of Alexander Tuckings

    Why? Why not a subordinate of someone else?

    There is no ordering of data and there is no way for SQL...

    December 31, 2012 at 3:28 am

    #1572473

  • RE: data for Min/Max rows

    popq79 34287 (12/31/2012)

    OrderID is auto gen number but can use orderdate for this purpose.

    If there is one order placed, then I want both min/max to contain the same long with...

    December 31, 2012 at 2:51 am

    #1572458

  • RE: data for Min/Max rows

    Does the OrderId column follow an ascending pattern? What I mean is, can we assume that, for each customer,

    Min(OrderId) is the first order

    and

    Max(OrderId) is the most recent order

    ?

    Also, if a...

    December 31, 2012 at 1:58 am

    #1572448

  • RE: Dropped connection during Excel VBA

    axwack (12/26/2012)

    I have a spreadsheet that culls the data from the sheet and inserts these into parameters in stored procedures. If there is an error on the sheet or the...

    December 31, 2012 at 1:44 am

    #1572444

  • RE: Need To Generate XML File

    Saravanan, can you answer Dave Ballantyne's question? It is a critical point.

    December 31, 2012 at 1:35 am

    #1572439

  • RE: I want to give a conditional statement in dervied column

    ngreene (12/28/2012)

    (DT_STR,50,1252)(band == "C1" ? "Developer" : band == "C2" ? "Tech Lead" : "Something Else")

    I added the string conversion "(DT_STR,50,1252)" incase you are inserting into a varchar field. ...

    December 28, 2012 at 2:28 pm

    #1572243

  • RE: ssis 2012 package

    Jon Jaroska (12/28/2012)

    The package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:

    There...

    December 28, 2012 at 9:12 am

    #1572147

  • RE: I want to give a conditional statement in dervied column

    krishnasrisatya (12/28/2012)

    I want to give conditional statement in dervied column by adding a new column.In band column if Band is B1 then in new column it should be Manager like...

    December 28, 2012 at 6:10 am

    #1572088

  • RE: ssis 2012 package

    Jon Jaroska (12/26/2012)

    I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there...

    December 28, 2012 at 2:13 am

    #1572045

  • RE: cannot open datafile

    This is an essential troubleshooting tool for variables (though there may be others) that will help you nail down the problem.

    There are others - simply setting a pre-execute breakpoint on...

    December 28, 2012 at 2:09 am

    #1572043

Viewing 15 posts - 10,261 through 10,275 (of 13,879 total)