DBID | Title | ParentID | OrderNum

 1      aaa       0          1

 2      bbb       0          2

 3      ccc       1          1

 4      ddd       1          2

 5      eee       2          1

DBID | Title | ParentID | OrderNum

 1      aaa       0          1      <<< main 

 3      ccc       1          1      <<< child

 4      ddd       1          2      <<< 2nd child

 2      bbb       0          1      <<< main 

 5      eee       2          1      <<< child

sImagelink = mid(request.form("Imagelink"),4,len(request.form("Imagelink")))

SELECT     ISNULL(st.ProductID, ct.ProductID) AS 'ID', ISNULL(st.Ordered, 0) - ISNULL(st.Delivered, 0) AS [On Order], ISNULL(st.Delivered, 0) - ISNULL(ct.Delivered, 0) 

                      AS [In Stock], ISNULL(ct.Ordered, 0) - ISNULL(ct.Delivered, 0) AS [Orders Outstanding], ISNULL(st.Ordered, 0) - ISNULL(ct.Ordered, 0) AS Unassigned

FROM         dbo.SupplierTotals AS st FULL OUTER JOIN

                      dbo.CustomerTotals AS ct ON st.ProductID = ct.ProductID

-- ****** Modified Version ******



declare @StartDate datetime

declare @Days int

declare @counter int



set @StartDate = dbo.Timesheets.TimeDate



if dbo.timesheets.AbsenceDays = <1 THEN

end

else



set @counter = 0



-- The reason why counter is set to 0 and not 1 is because I want to create the initial record with the Timesheet date+0.  This is because I do not want to keep the original record that is being used to duplicate and create each day timesheet.



while(@counter <= dbo.timesheets.AbsenceDays)

begin



-- Somehow need to specify a relationship between dbo.Calendar.[Date] and dbo.timesheets.DateTime+@counter



CASE WHEN(dbo.Calendar.WorkDay = “Y” THEN continue ELSE @counter = @counter+1 redo case END)



-- Above case done to ensure that the date it is about to add is not a Sunday or Saturday or public holiday.  Don’t know how to format it correctly.



print DATEADD(day, @counter, @StartDate)



-- I know I can insert record here but don’t know how.  I want the same details as the original record being checked by the script but the TimeDate field to be changed to the new date and the AbsenceDays field to be set to 1 per records.  In addition, if the absences are 3.5 days, I would need FOUR records created – 1, 1, 1, 0.5.  When adding these records, how would I get it to create records which are not simply divided by 4? (namely 0.87 days per record)[/green]



set @counter = @counter + 1

end

<?xml version="1.0" encoding="UTF-8"?>

<result>

    <books>

        <book>

            <bookID>79</bookID>

            <bookTitle>Some Good Book</bookTitle>

            <bookNumPages>300</bookNumPages>

            <authors>

                <author>

                    <authorID>200</authorID>

                </author>

                <author>

                    <authorID>205</authorID>

                </author>

                <author>

                    <authorID>215</authorID>

                </author>

            </authors>

        </book>

        <book>

            <bookID>112</bookID>

            <bookTitle>Another Book</bookTitle>

            <bookNumPages>350</bookNumPages>

            <authors>

                <author>

                    <authorID>200</authorID>

                </author>

            </authors>

        </book>

    </books>

    <authors>

        <author>

            <authorID>200</authorID>

            <authorName>First Author</authorName>

        </author>

        <author>

            <authorID>205</authorID>

            <authorName>Second Author</authorName>

        </author>

        <author>

            <authorID>215</authorID>

            <authorName>Third Author</authorName>

        </author>

    </authors>

</result>

Select FriutID from Friut where friutName like'@con'%.

DECLARE @SQLinkedTable AS VARCHAR(50)

DECLARE @SQL NVARCHAR(4000)

DECLARE @Quantity AS INT



SET @SQLinkedTable='LINKEDSERVER1.DB1.dbo'

SELECT @SQL = 'SELECT @Quantity=COUNT(*) FROM '+@SQLinkedTable+'.[CampaignSettings] WHERE SQLID=1'

EXEC sp_executesql @SQL, N'@Quantity INT OUTPUT', @Quantity OUTPUT

DECLARE @SQLinkedTable AS VARCHAR(50)



SET @SQLinkedTable='LINKEDSERVER1.DB1.dbo'

SELECT * FROM @SQLinkedTable.[CampaignSettings])



DECLARE @ExternalDB AS VARCHAR(200)

SET @ExternalDB = 'Server=111.111.111.111;Database=DB1;UID=USR;Pwd=PASS;'

SELECT * FROM OPENROWSET ('SQLNCLI',@ExternalDB, 'SELECT * FROM [CampaignSettings]')