Viewing 15 posts - 1,096 through 1,110 (of 1,497 total)
Try using a transaction and UPDLOCK.
Here is an outline - you will need to add error handling etc.
DECLARE @NextInvoiceNumber int
BEGIN TRANSACTION
SET @NextInvoiceNumber =
(
    SELECT NextInvoiceNumber
    FROM InvoiceNumbers WITH (UPDLOCK)
    WHERE Company =...
April 10, 2008 at 3:02 am
Try something like:
SELECT *
FROM ord1 H
WHERE EXISTS
(
    SELECT NULL
    FROM PRCR C
    WHERE C.customer = H.customer
        AND C.division = H.division
        AND C.ack_by = 'P'
        AND C.sku_upc <> 'N'
        AND C.ovnd_key IN (H.ovnd_key, '')
)
March 17, 2008 at 11:42 am
Maybe you could try variations on:
SELECT T3.IDK, T3.C4
FROM T3
WHERE EXISTS
    (
        SELECT *
        FROM T1
        WHERE T1.C1 = T3.IDK
            AND EXISTS
            (
                SELECT *
                FROM SelField S
                WHERE S.val = T1.C1
            )
    )
    AND EXISTS
    (
        SELECT T2.IDK
        FROM T2
        WHERE T2.IDK = T3.IDK
        GROUP BY T2.IDK
        HAVING...
February 14, 2008 at 3:12 am
I think these are the ODBC functions which TSQL seems to be able to process.
February 14, 2008 at 2:57 am
DECLARE @s varchar(255)
SET @s = 'Mark_m_andrew_levey_caa12002'
SELECT REVERSE(LEFT(REVERSE(@s), CHARINDEX('a', REVERSE(@s)) - 1))
February 12, 2008 at 7:20 am
SELECT TOP 30
    S.Prod
    ,S.Acct
    ,S.TC
    ,CASE N.N
        WHEN 1 THEN S.SubmitRep1
        WHEN 2 THEN S.SubmitRep2
        ELSE S.SubmitRep3
    END AS Rep
    ,CASE N.N
        WHEN 1 THEN S.Percent1
        WHEN 2 THEN S.Percent2
        ELSE S.Percent3
    END AS Percentage
FROM dbo.tbl_CYProcessedSales S
    CROSS JOIN -- make 3...
February 5, 2008 at 10:26 am
SELECT U.*
FROM Usr_AmtDetails U
    JOIN
    (
        SELECT X.AcctID, MAX(X.RenewDate) AS RenewDate
        FROM Usr_AmtDetails X
        GROUP BY X.AcctID
    ) D
        ON U.AcctID = D.AcctID
            AND U.RenewDate = D.RenewDate
February 5, 2008 at 7:53 am
I do not see any problem.
What logically happens for a left join is:
1. An inner join is done.
2. Any rows in the left table not in the result are added.
3....
January 30, 2008 at 10:40 am
If you check my Rolling Total query, you will see I am grouping by M2.userhistoryid
January 29, 2008 at 8:02 am
Umm.... You obviously did not try my original query as no rows would be returned.
In future, please read the following when posting:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
As you seem to want a rolling total, try...
January 29, 2008 at 2:48 am
You need to get the required userid's and then use them with a derived table or a subquery.
Here is an example of a derived table:
SELECT M.*
FROM moviesviewed M
    JOIN
    (
        SELECT M1.userid
        FROM moviesviewed...
January 28, 2008 at 10:59 am
Try getting rid of the brackets:
SELECT P.user_permissions_id
    ,U.[user_name] AS [User]
    ,UA.[user_id]
    ,A.abreviation AS Account
    ,UA.account_id
    ,P.[read] AS [Read]
    ,P.write AS [Write]
FROM q_user_account UA
    JOIN t_users U
        ON UA.[user_id] = U.[user_id]
            AND U.active = 1
    JOIN t_account A
        ON UA.account_id = A.account_id
    LEFT...
January 24, 2008 at 3:33 am
Dale,
My apologies – I did not visualize the joins correctly. (More coffee required!)
I do not think HAVING can be used easily in this case.
Ken
January 17, 2008 at 3:38 am
BusinessObjectInstanceId = @BusinessObjectInstanceId
OR
@BusinessObjectInstanceId = ''
Also, as BusinessObjectInstanceId is an integer, the implicit type casting will not help.
Try OR @BusinessObjectInstanceId = 0
January 16, 2008 at 9:29 am
Viewing 15 posts - 1,096 through 1,110 (of 1,497 total)