Forum Replies Created

Viewing 2 posts - 31 through 32 (of 32 total)

  • RE: how to overcome from the tempdb spill over ?

    ChrisM@Work (8/19/2015)

    Can you post the entire query please, and the definition of the tvf "splitstring".

    Cheers.

    SP :

    DECLARE @lobid INT = 3,@LineOfBusiness VARCHAR(50)='ECN'

    DECLARE @CmsContractID VARCHAR(MAX)='H9285'

    SELECT DISTINCT...

    August 19, 2015 at 6:33 am

    #1821004

  • RE: Help on query - produce permutation combination

    Quick suggestion, use dynamic SQL

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @TABLE_STR NVARCHAR(MAX) = N'';

    declare @t2 as table (tab varchar(100))

    insert into @t2 values ('V')

    insert into @t2 values ('VL')

    insert into @t2 values ('1099')

    insert...

    June 4, 2015 at 4:43 am

    #1802933

Viewing 2 posts - 31 through 32 (of 32 total)