Forum Replies Created

Viewing 15 posts - 31 through 45 (of 98 total)

  • RE: CTE returns NULL value.

    i am getting the following error while executing the procedure.

    The statement terminated. The maximum recursion %d has been exhausted before statement completion.

    Please help to solve the problem.

    November 19, 2008 at 6:57 am

    #900487

  • RE: All database physical_name Path

    steveb (11/12/2008)

    try this code to get the file paths for each db on a server.

    DROP TABLE #DBFiles

    CREATE TABLE #DBFiles

    (

    [DBName] [nvarchar](100),

    ...

    November 13, 2008 at 3:50 am

    #897964

  • RE: All database physical_name Path

    Thanks You Very Much GUYZZZ...

    Great Work...! :w00t:

    November 13, 2008 at 12:28 am

    #897912

  • RE: Update a record through EXISTS

    Chirag (11/4/2008)

    yes you can. if record count is only criteria then this will work.

    Update table1 set col1 = value

    where exists (select * From table2)

    Thanks for your quick reply.

    If i...

    November 4, 2008 at 2:24 am

    #893481

  • RE: Uniqueidentifier datatype as like identity function???

    Hi Guys,

    Thanks you for your valuable reply's. Because of Performance Issue, i am think about this. So that it will be in sequence when i am inserting or updating a...

    September 23, 2008 at 11:17 pm

    #876114

  • RE: Row number returned in resultset

    Hi Scott,

    Use ROW_NUMBER function like the below one. I think you will get.

    DROP TABLE #Test1

    CREATE TABLE #Test1...

    September 23, 2008 at 5:29 am

    #875557

  • RE: ORDER BY CLAUSE

    Hi,

    Try this...

    DROP TABLE #Test

    CREATE TABLE #Test (fldName varchar(8))

    INSERT INTO #Test

    SELECT 'Suresh'

    UNION ALL

    SELECT 'Arun'

    UNION ALL

    SELECT 'Kamal'

    UNION ALL

    SELECT 'Bala'

    DECLARE @Name varchar(8), @Order varchar(8),@Sql varchar(50)

    SET @Name = 'fldName'

    SET @Order = 'ASC'

    SET...

    September 23, 2008 at 5:13 am

    #875549

  • RE: Combining Rows into single one

    Hi suresh,

    Try this one also.

    SELECT

    fldID,fldName,fldStatus,[India]AS Addresss,[USA]AS Addresss,[Denmark]AS Addresss,[Spain] AS Addresss

    FROM

    (SELECT fldID,fldName,fldStatus,fldAddress FROM #Test) T

    PIVOT

    (

    MAX(fldAddress)

    FOR fldAddress IN ([India],[USA],[Denmark],[Spain])

    ) AS Test

    ---

    September 22, 2008 at 6:04 am

    #874903

  • RE: Enable Files and Filegroups

    Mike John (9/16/2008)

    If I understand your question correctly I suspect that the options for file and filegroup backups are disabled because the database in question has only a single file...

    September 17, 2008 at 12:07 am

    #872801

  • RE: allow varchar value to string and decimal parts

    Hi,

    try the below one.

    DECLARE @Text VARCHAR(16)

    SET @Text = 'ABC222'

    SELECT SUBSTRING(@Text,PATINDEX('%[0-9]%',@Text),LEN(@Text)) + 100

    ---

    August 29, 2008 at 5:34 am

    #864936

  • RE: SELECT values from XML column

    Hi Hari,

    Is it possible to post your Details column xml structure???

    ---

    July 22, 2008 at 1:27 am

    #846194

  • RE: How to Pivot a table

    Hi black,

    Try this. It should work as per your result set.

    CREATE TABLE tblPivot (fldDate DateTime, fldValue int)

    INSERT INTO tblPivot (fldDate,fldValue)

    SELECT '4/1/2008',4

    UNION ALL

    SELECT '4/3/2008',6

    UNION ALL

    SELECT '4/7/2008',9

    UNION ALL

    SELECT '4/2/2008',1

    UNION ALL

    SELECT '5/8/2008',4

    UNION ALL

    SELECT...

    July 18, 2008 at 12:36 am

    #844811

  • RE: Identity Default Instance or Named Instance

    Tks all for your valuable post. 🙂

    July 17, 2008 at 3:28 am

    #844220

  • RE: Identity Default Instance or Named Instance

    Perry Whittle (7/16/2008)

    check the services.msc console or enumerate through code

    a default installation of SQL server will have the following service name

    MSSQL$SERVER

    for a named instance it will be

    MSSQL$instancename

    Hi Perry,

    Could you please...

    July 16, 2008 at 2:57 am

    #843610

  • RE: Getting the Last Integer values

    Hi Ken Simmons,

    Thanks Ken. I got it. 🙂

    July 10, 2008 at 11:37 pm

    #841242

Viewing 15 posts - 31 through 45 (of 98 total)