Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 2,452 total)

  • RE: SQL Query Question: Working with Dates

    krhind (3/2/2012)


    Also, I took a look at the post in your signature about best practices for asking question on these forums. Perhaps I am missing something though, I tried to...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: If ... select ...else then ??

    sabercats (3/1/2012)


    Sorry, i am newbie and really don't understand what you mean "Please provide some ddl and sample data along with a clear explanation of what you are looking...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: HERE I JUST WANT TO WRITE SELECT QUERY FOR A DATE BASE ON CURRENT DATE

    just in case here it is again....works fine for me

    http://www.karaszi.com/SQLServer/info_datetime.asp

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Need help replicating an algorithm in TSQL Table?

    so does E126W4SD = 1099407588925 ?

    cos that what my version of excel displays....so, now, what are the "conversion rules" ?

    subahan_syed (2/29/2012)


    that would be 5126234194

    ...hmm..seems my version excel isnt working...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Need help replicating an algorithm in TSQL Table?

    subahan_syed (2/29/2012)


    Well. In a row value of alpha numeric code like 'E126W4SD', the above excel algorithm will provide values replacing the alphabets, based on alphabet series. Lets say an alphabet...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: If ... select ...else then ??

    i have an idea that the date criteria is causing your problem...just a guess 🙂

    pls confirm version of SQL

    pls provide "create table script" for table [System].[dbo].[Machine_Control_History]

    pls provide sample data to...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: If ... select ...else then ??

    to get this output....what query did you use, specifically what is in the "WHERE" clause?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Best approach to let users create and manage their own tables and data

    "We are going to develop a project where clients will be able to Create their own SQL tables and fields. "

    Do you currently provide your clients with some form of...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: If ... select ...else then ??

    it would easier to understand, if you care to provide some create table scripts and sample data ...with your expected output.

    but initial thought is,

    pseudo code : "WHERE end_datetime...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: select statement takes long time

    Vahid.Ch (2/29/2012)


    No I don't need,it was a sample.

    let me explain more.

    I'll have new Database everyday,around 300,000 to 350,000 rows.

    so,it stores users log,such as url,clientIP,Logtime and so on.

    imagine that an admin...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: correlated sub query

    take a look at this post/thread....maybe helpful

    http://www.sqlservercentral.com/Forums/FindPost1071067.aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Many-to-many Junction table opinions?

    Hi George

    I wonder if you could clarify something for me please?

    say I create 5 requisitions

    req1

    req2

    req3

    req4

    req5

    now, I decide that i need to link "req5" with "req2"...can I also link "req5" with...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Server Columnstore Index

    have you read this article...it may help expiain

    http://msdn.microsoft.com/en-us/library/gg492088(v=sql.110).aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: PIVOT maybe?

    is this an example of what you are trying to achieve?

    DECLARE @sample TABLE (

    id INT IDENTITY(1, 1),

    product VARCHAR(10),

    ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help needed with SQL stored procedure and XML

    alexei

    One question : did you properly obfuscate the data in your attachment xml?

    if not then please ask the site to remove it immediately.

    If you are seeking help with something from...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 1,936 through 1,950 (of 2,452 total)