Answer Questions

• BI Analyst Select Statement returns no results

  I am using the following conditional select statement but it returns no results. Declare @DepartmentName as varchar Set @DepartmentName = null Declare @status as bigint Set @status = 4 IF (@DepartmentName = null) BEGIN SELECT CallNumber AS [Call Number], Problem, Solution, Note FROM AdminView WHERE (Status = @status) ORDER BY CallLoggedDT END ELSE IF (@DepartmentName <> null) Begin S ...Show All

• CloudNine Concatenate field based on unique id.

  I have a table like this Id comment -- ------- 1 abcd  1 efgh 1 cc 2 aa1223 3 myComment 3 myComm123444444 I want to a SQL statement that returns unique Ids with their comments concatenated with comma. 1 abcd,efgh,cc 2 aa1223 3 myComment,myComm123444444 Can anyone help me with this. thanks. You can do this with a user-defined aggregate written using SQLCLR framework in SQL Se ...Show All

• Igor K. Using images in database

  We are building mostly read Real estate web site where there are many pictures what users will see from their browers.We have come up with 3 ideas.But we need help,is there any alternatives to these. 1.Put them into the database we are using . 2.Seperate the images to another instance and record images to that instance . 3.Use the filesytem. What is the best way of storing and retreving images for a concurrent web application ...Show All

• Nathan Neitzke Error:User does not have permission to perfor this action.

  I just installled the Visual web developer - express addition. When I try to add aSQL database to my project it gives the following error - "User does not have permission to perfor this action" . Can someone please help If this is a Visual Web Developer issue, then you should try posting on the following forums: http://forums.asp.net/ . Is there any other information provided besides the error mes ...Show All

• mark92929 SSIS SELECT / DELETE / INSERT

  I am trying to do the following for a few tables in my DB. I have an ODBC datasource and would simply like to update my DB from this datasource. I want to pull the table data from my ODBC datasource, delete any existing data in my SQL tables and then insert the data from my ODBC datasource into SQL. I am trying to create an SSIS package to do this but am not sure where to start. Any help or examples would be appreciated. ...Show All

• Skylark Error in Creating Stored Procedure from VS 2005

  When I create a stored procedure in VS 2005 using C# and deploy it to the server I can't execute it there and here is the error message: Msg 6522, Level 16, State 1, Procedure GetAll, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'GetAll': System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral ...Show All

• Tom Guinther Can you setup backup/restore functionality in SQL Express 2005 from a C# app?

  Hi, I'm currently working on a project which uses a SQL Express 2005 database. I want to be able to setup SQL Express from my C# program so that it can perform backups to a specified path location at the requested interval itself. This would free up my program from having to manage the backups. Just wanted to know if this is possible Also, when the current database becomes corrupt will SQL Express perform the restore for the user ...Show All

• txnet Doing a data import using DTS Wizard in SQL Server 2005 - being efficient with 5 flat files

  Hi, I'm a new user of SQL Server 2005. I have the full version installed. I also have SQL Server Business Integration Dev Studio installed. My OS is Windows XP. I'm importing a series of 5 flat files into a database on one of the SQL Servers we have. My goal is to get 5 different tables (though perhaps I should do one and add an extra field to distinguish each import) into the database for further analysis. I tried doing an import via D ...Show All

• Ganesh Next bug with "slowly changing dimension" task and nvarchar(max)

  Hello I use SSIS to load a Unicode file into a single table I Use a "slowly changing dimension" task to load the destination table and when i map a column (DT_WSTR) to a column with the datatype nvarchar(max) i have an error message that say that i can't map theses columns because there have not the same datatype. I find a workaround : i map all my cols except the colums that must fill the cols with datatype nvarchar(max) , and after i ...Show All

• jh2005 Report/query parameter default values

  I am using a SQL stored procedure for a report. The sproc has a variable in it (@itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT sh ...Show All

• pvh How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. am i doing the correct thing this command will search for the keyword LIVER. or issit this command i doing half way through.. SELECT Omim_No FROM av WH ...Show All

• hairunizam Data Comparison Question

  I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do Thank you very much you have ...Show All

• nbn DataReader Source and Column Types

  Is there a way to control the types for output columns of a DataReader Source It appears that any System.String will always come out as DT_WSTR. As I have my own managed provider, and I know what went in, I can say that really it should be DT_STR. The GetSchemaTable call from my provider will always say System.String as it does not have much choice, but GetSchemaTable does contain a ProviderType which is different for my DT_STR vs DT_WSTR, or ra ...Show All

• Paul Smith - Sagestore Changing login permissions

  I am trying to set up a secure system and would like some advice on how to do it as it is a bit tricky. The underlying security is Windows Authentication but I need to set various permission levels in the application. What I want to do is to allow users read-only access to a users table. Once they are validated and their permission level is determined, then I want them to be assigned to the role that is set for their permission level. I hav ...Show All

• Mikkel S SSIS Script Component

  Dear all, Such a pain, I know. Yesterday I did a couple of questions regarding transformation rows and very kindly I obtained answer (Thanks Jamie and Michael) But now I face another stupid issue and is how to map source with destination columns inside Script Component Task. On my Flat File Source I’ve got defined thirteen columms (from Column0 till Column13); that’s fine. And then, I’ve got a sql table as destination with another ...Show All