Forum Replies Created

Viewing 15 posts - 451 through 465 (of 2,894 total)

  • RE: Updating field

    I'm glad to help!

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 4:47 am

    #1614924

  • RE: How to display Financial Year wise Summary

    avdhut.k (5/14/2013)

    Hey Sorry,

    I posting the table correctly,

    but while Posting it gets meshed.

    I cannot see you have posted a table. Just formatted/indented text.

    Have you read forum...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 4:46 am

    #1614922

  • RE: Updating field

    You stored proc returns SEQNO in the recordset.

    Not very well written proc I would say, crap actually.

    To get the above value from it, you should execute this proc and...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 3:50 am

    #1614897

  • RE: How to display Financial Year wise Summary

    avdhut.k (5/14/2013)

    Hi,

    I had requirement,I want a report in sql server 2008 as follows,

    Total PayDate Amount

    2000 ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 3:45 am

    #1614892

  • RE: Updating field

    cyberdaemon (5/13/2013)

    another option iam thinking right now is to create a udf that will call this executable sp. and the result will be call to my sp that will update...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 2:48 am

    #1614868

  • RE: how to check if a user is an admin or is a guest?

    sp_helpuser

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 2:44 am

    #1614865

  • RE: How to display Financial Year wise Summary

    avdhut.k (5/14/2013)

    Hi,

    I had requirement,I want a report in sql server 2008 as follows,

    Total PayDate Amount

    2000 20110401 1000

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 2:31 am

    #1614860

  • RE: Replicating GROUP_CONCAT Function of MySQL in SQL Server

    Using FOR XML PATH is most common technique to achieve string/row concatenation.

    So, what is your question?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 14, 2013 at 2:29 am

    #1614859

  • RE: Quering Code

    dwilliscp (5/13/2013)

    I do not have permissions on the server.. and there is a lot of red tape to get anything installed.

    However I did use the SQL provided... with a few...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 10:56 am

    #1614701

  • RE: facing problem in configration of database

    It has nothing to do with SQL.

    It's a problem with your application configuration file.

    Try to clear down \bin\Debug and \bin\Release folders.

    After, build check what config file is copied there...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 9:25 am

    #1614656

  • RE: Quering Code

    michael.higgins (5/13/2013)

    SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

    FROM sys.sql_dependencies d

    INNER JOIN sys.objects o

    ON d.object_id = o.object_id

    INNER JOIN sys.objects p

    ON d.referenced_major_id = p.object_id

    Worth a...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 8:45 am

    #1614635

  • RE: facing problem in configration of database

    What tool do you develop with? .NET?

    If so, check your build configuration. Debug vs Release

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 8:39 am

    #1614630

  • RE: Quering Code

    Install RedGate DB search - it's free!

    http://www.red-gate.com/products/sql-development/sql-search/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 8:36 am

    #1614627

  • RE: Performance Tuning

    First of all: it's really hard to work with code which looks like vietnamese noodles.

    I've tried to add some indentation there:

    ALTER PROCEDURE [dbo].[spreport]

    @pSiteSeqId VARCHAR(MAX),

    @pStartDate DATETIME2,

    @pEndDate DATETIME2

    AS

    BEGIN

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 4:35 am

    #1614539

  • RE: Returned unique Rows from two different tables with the same ID

    another way of doing it without windowed function:

    SELECT pl.ID, usr.FirstName +' ' + usr.Surname as Createdby, pl.ProspectGuid, pl.MobileNumber as CTN, pl.Firstname + ' ' + pl.Surname CustomerName,

    Convert(varchar(10),pl.CallBackDate, 103) as...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 13, 2013 at 4:15 am

    #1614537

Viewing 15 posts - 451 through 465 (of 2,894 total)