Forum Replies Created

Viewing 15 posts - 6,706 through 6,720 (of 15,381 total)

  • RE: Query Needed

    Many thanks to Alan for the sample data. I think I would do this a little differently because the user wants a cross tab here instead of all jammed into...

    September 25, 2013 at 1:37 pm

    #1653337

  • RE: select truncates varchar(max) column(s)

    I assume you are running this in SSMS and the results panel has the value truncated? That is because SSMS truncates long text. You can change the amount of text...

    September 25, 2013 at 1:17 pm

    #1653329

  • RE: Are the posted questions getting worse?

    wolfkillj (9/25/2013)

    but I really don't want to stand in the bed of a truck traveling 100 mph!

    Why not? There are those of who did that all the time as a...

    September 25, 2013 at 1:14 pm

    #1653328

  • RE: Top 50 based on Sum

    jerome.morris (9/25/2013)

    This is correct but I need all my other selects in there as I pass this to a datatable for reportviewer.

    thanks

    This is where you have to post some details...

    September 25, 2013 at 10:31 am

    #1653263

  • RE: cursor question

    FDS_ (9/25/2013)

    Well i did it and its working fine! Thanks all for the answers.

    It would be great if you could post what you did. It may very well help someone...

    September 25, 2013 at 9:52 am

    #1653248

  • RE: Top 50 based on Sum

    jerome.morris (9/25/2013)

    Correct, I need to sum(Duration) grouped by Operator_Name and return the result desc based on the the sum for each operator.

    This help?

    select top 50 sum(Duration), Operator_Name

    FROM DocketTB

    WHERE (Docket_Status...

    September 25, 2013 at 9:50 am

    #1653246

  • RE: Top 50 based on Sum

    jerome.morris (9/25/2013)

    Order by? top 50 what. Do I not need to sum the Duration then select the top 50 that what I don't understand

    thanks

    You have me at an extreme...

    September 25, 2013 at 9:14 am

    #1653229

  • RE: Top 50 based on Sum

    jerome.morris (9/25/2013)

    Hi all based on my query below, how do I select just 50 based on a Sum of duration matching the criteria defined?

    SELECT Contract, Docket_Category, Docket_Date, Docket_DateRaised, Docket_EngFinish, Docket_EngStart,...

    September 25, 2013 at 8:51 am

    #1653209

  • RE: How to search?

    It was me who has repeatedly told you over the last few days that you need to parameterize your dynamic sql. I have posted the same link to the same...

    September 25, 2013 at 8:46 am

    #1653207

  • RE: Creating a CASE login within a CASE logic

    SteveEClarke (9/25/2013)

    Sorry -

    What I am trying to achieve is a CASE within a CASE I suppose

    Two conditional checks ...

    So ...

    SUM ( CASE field_SEX WHEN "MALE" THEN

    ...

    September 25, 2013 at 8:42 am

    #1653205

  • RE: Returning Windows Logon Credentials to a SQL Query

    You should ORIGINAL_LOGIN() instead in case there is any impersonation going on.

    http://technet.microsoft.com/en-us/library/ms189492.aspx

    September 25, 2013 at 8:34 am

    #1653196

  • RE: I need an exclusion query again. My totals are wrong.

    frdrckmitchell7 (9/25/2013)

    Thank you for your response:

    I've built the (part of) query like this:

    (IM.ItemCode BETWEEN '999999' AND 'CL00000'

    OR IM.ItemCode NOT LIKE '001920'

    OR IM.ItemCode NOT LIKE '001921'

    OR IM.ItemCode...

    September 25, 2013 at 8:32 am

    #1653193

  • RE: Creating a CASE login within a CASE logic

    SteveEClarke (9/25/2013)

    I have the following code which seems to accumulate the complete file - rather than the upper record set -

    When OperationPhase = 2 and ResCat = 'MC' - I...

    September 25, 2013 at 8:22 am

    #1653188

  • RE: Can you please anybody one explain?

    dwain.c (9/24/2013)

    Sean Lange (9/24/2013)

    dwain.c (9/23/2013)

    Steven Willis (9/20/2013)

    techmarimuthu (9/19/2013)

    How to do database migration in Sql server?

    i need basic and step by step instruction.....

    Please help me

    Thanks in advance

    The easiest method is to...

    September 25, 2013 at 8:00 am

    #1653175

  • RE: Help required to extra image from varbinary column and create image on file system

    donnaklinton (9/25/2013)

    Hello

    Here is my code:

    This thread is 2 years old and your post looks a LOT like spam to me. Nothing but references to your SDK and a link to...

    September 25, 2013 at 7:57 am

    #1653172

Viewing 15 posts - 6,706 through 6,720 (of 15,381 total)