Forum Replies Created

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

  • RE: How do you count percentage?

    Try this script. You need to look at your duration figure as it appears to be more than a week. I also assumed that you use '10' to seperate the...

  • RE: Running same SQL code against a number of tables

    Dynamic SQL should do the job given required columns exists in all tables with the same name. Even if the columns names are different in some tables, you may be...

  • RE: What's going on with nvarchar(max)?

    Thanks Peter.

  • RE: What's going on with nvarchar(max)?

    Looks like either define @V2 as VARCHAR(MAX) or convert it to VARCHAR(MAX) in the concatination will give the correct results, but not NVARCHAR(MAX). Still don't know why though.

  • RE: Copying Excel worksheet in SSIS script task

    Try this: Sheets("Sheet1").Copy Before:=Workbooks("Book2").Sheets(1)

    It's really a VBScript question. You can google for the answer (too many there) or try record a macro in Excel and then see the code (that's...


    kimberlyphillips01 (5/22/2011)

    Thank you for the reply, I greatly appreciate it. Your solution parses and executes but returns no date at all. any additional ideas?

    Please check your statement can...

  • RE: How to compare multiple rows of one table with multiple rows of another table

    kamranzafar_ch (5/22/2011)

    Thank you Lutz for the reply. As I also want to run it on SQL Server 2005 then what changes are required in this code.

    CTE & ROW_NUMBER() were instroduced...


    kimberlyphillips01 (5/22/2011)

    Can someone tell me why my statements are adding days instead of weekdays? The returns on all of the variables and subselects are int, I have tried several...

  • RE: Operating system error 1450

    Can you re-produce the problem with adjusting memory setting to it's original values? If you can re-produce it, it may be related to memory setting (but I don't know why...

  • RE: LightSpeed Backup job failed

    Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the...

  • RE: Change user by variable

    If I read it correctly, you are trying to replicate the 30 views for each schema for those users required. Any special reason for that? Can't you create the view...

  • RE: will max dop hint help here?

    There is no black/white answer, "it depends". It depends more on your specific query and environment. please post your query and plan.

  • RE: KILL/ROLLBACK process showing Await Command

    Yes, restart service is the way to fix. Most interesting to me is that, I experieced this a few times on SQL2000 but not other versions above that (yet). I...

  • RE: How to Find a column has index or not

    Try this script that list the columns of a table in any index:

    select column_name =

    from sys.index_columns ic

    inner join

    sys.columns c

    on ic.object_id = c.object_id and ic.column_id = c.column_id

    where object_name(ic.object_id) = '<your...

  • RE: Hiding tables from users

    One way might be set up a database role and grant "deny access" to those tables you want to hide from the user. Add those users as that role member.

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