• SSRS line chart color

    I have PV and high two series on one chart. I need to compare PV vlaue with high, when PV value is deviated to high then set the color red. I wrote the expression as "IFF(PV<=HIGH, RED, GREEN", for which I got the color but there is a small problem. For example: PV = 20, 25, 28, 35, 37, 39, 28....

    anu4kumari5 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL injection attack detection

    How can I find if my site is vulnerable for SQL injection attacks? Can anyone share the tips to prevent it?

    KelvinS80 pointsBadges:
  • MS SQL Server version

    Hi MS-SQL Server-ers, I'm wondering with is the date displayed in the version of SQL Server (by using @@version)? Could anyone tell me what is that date referred to? Thank you!

    srithea350 pointsBadges:
  • SQL Server database administrator

    Temp DB size is gradually increasing. My current temp DB size is 12gb. How do I resolve this issue?

    nasarbabu30 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE435,940 pointsBadges:
  • SQL Server: Parameterize IN clause

    Is there a way to parameterize an SQL query that contains an IN clause with a variable number of arguments? Something along the lines of this: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc I don't want to use a stored procedure/XML so what's the best...

    ITKE435,940 pointsBadges:
  • Sanitize user input for a SQL injection using PHP

    What's the best way to sanitize user input for a SQL injection / XSS attack? I need it done with PHP too and it needs to still allow types of HTML tags. Thanks!

    ITKE435,940 pointsBadges:
  • SQL Server 2008 R2 database isolation change

    I want to change my database isolation to read uncommitted in SQL server 2008 R2. Can someone tell me the exact process and how should I can achieve this?

    edwinjhoffer3,365 pointsBadges:
  • Trigger email alerts on Windows Server 2008

    In Windows Server 2oo8, can I trigger it to send out an email alert when our logical disk partitions become low on space? We currently have two SQL Servers that are running out of space. It's due to log files. Thank you.

    ITKE435,940 pointsBadges:
  • Move SQL query results to another table

    I have this query: SELECT a.* FROM devices_staging a INNER JOIN ( SELECT ComputerName, MAX(SystemSync) max_date FROM devices_staging GROUP BY ComputerName ) b ON a.ComputerName = b.ComputerName AND a.SystemSync = b.max_date And the results I get are correct. How do I move these results to another...

    icelander5 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE435,940 pointsBadges:
  • Add SQL Server Agent jobs to Microsoft Excel spreadsheet

    I have a list of SQL Server Agent jobs and I need to add them to my Excel spreadsheet. The problem is that I don't want to do this manually. Is there a T-SQL command that would create this list for me?

    ITKE435,940 pointsBadges:
  • SQL Server log file is too big

    We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally, we did transaction log file backup it should be clear up , but it still 172 GB. What to do?

    mimiKh5 pointsBadges:
  • SQL Server: Should I have auto-shrink turned on?

    This is a basic SQL Server question, but for my database, should I use the auto-shrink option. But someone told me it's not really secure. Is that true?

    ITKE435,940 pointsBadges:
  • Can I add a dependency to a Windows Service?

    We currently have a Windows Service that's using a SQL Server database. I don't have control over it (my boss does) but he asked me to add a dependency so it starts up after SQL Server starts up. Can I do this? Is there a specific tool I have to use?

    ITKE435,940 pointsBadges:
  • How to fix this error in SQL and Excel?

    When I execute the T-SQL, I want to copy result and paste Excel sheet but the numbers had problem. For example in SQL, 4.2900 but when I copied Excel 42.900. Can you help this problem please?

    edwinjhoffer3,365 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1230 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following