Forum Replies Created

Viewing 15 posts - 1 through 15 (of 108 total)

  • RE: MDX query behaviour

    Martin Schoombee - Sunday, May 20, 2018 7:03 AM

    From the above, I'm guessing that your attribute relationships also follow the same structure...

  • RE: Conversion failed when converting datetime from character string

    one other way is you can also specify the case statement including IsDat check.

    CASE WHEN IsDate(value) then CAST/Convert( value ) else "you can specify the default date " END

  • RE: add column in certain position

    1 question does column position matters to you / database ?

    you can add the column at specific order either by the way mention by Jack Corbett. there is not other...

  • RE: dynamic queries in sql


    I appreciate your view but the problem arise for permissions when i execute the SP either i have to user EXECUTE AS Clause or I have set the permissions for...

  • RE: DUMP all DML in a single procedure


    it's always good to keep your object objects isolated. this will help you to keep track. This may possible that in future there will be a change in your Business...

  • RE: DTS

    Yes you can do it by using MERGE JOIN task after fetching the data from different sources.

  • RE: How to find total size of all databases

    you can also use this query ....

    select CAST(CAST(sum(size) * 8192 / 1048576 AS DECIMAL(10, 2) ) AS VARCHAR(20)) + 'MB' from sys.master_files where database_id = DB_ID('Global_DB')

  • RE: Column Encryption in SQL Server 2005

    yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.

    check msdn for brief help on ASYMMETRIC KEY and SYMMETRIC...

  • RE: Recursivce CTE

    Why do you want to implement recursion as you are searching only for only 1 level

    As you mention :

    all the position that reports to "Product Development"

    e.g "Project Lead;QA...

  • RE: Timeout error while inserting

    There must be the problem of locking your table is getting locked

    Have you created any index which is greater in size ?

  • RE: Migrating Logins from SQL 2000 to SQL 2005

    When you restore the sql 2000 database on sql 2005, you have to fix the mapping of users & database manually.

  • RE: Table Inventory used and not in used

    You can not detect that which table is used by Application, for that you have to do manual work there is no such tool.

    About database you can check that whether...

  • RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    just a suggestion to check,

    When you created the linked server have to given the permission to NT\WindowsUser ?

  • RE: Want SQL query

    This could be simpler as mention below.

    SELECT sm_type, count(sm_type) FROM sm group by sm_type

  • RE: Issue with AND clause

    i think it should be like this...

    IF @LineFilter in ( '1,2,3' )

Viewing 15 posts - 1 through 15 (of 108 total)