Hello Guys, Here I am facing a problem that I want to pass a dataset to a SQL Server stored procedure and I don't have any idea about it and there is no alternate solution (I think so ) to do that, let me tell what I want ... I have an Excel file to be read , I read it successfully and all data form this excel work book import to a da...
I have a package in SSIS, in the data flow I have a script component that is a data source, setting variables to an Excel Data Flow Destination. With ScriptOutputBuffer .AddRow() .scriptRowID = 2 .Filename = Variables.foundFile .RunTime = Now .Status = "found" End With Unfortunately the dates are coming out in the ...
I have a stored procedure which selects a single field from a single row (based on a conditional statement) and stores it in a local variable. Based on the value of this field I update the same field in the same row of the table (using the same conditional statement). So the procedure first does a select into a local variable and then ...
I have readonly access to the master database however the following query only returns a subset of users. What permissions are needed to return the rest of the users? SELECT [name] FROM master.dbo.syslogins ...
I have been doing a coding in for last 7 months. Most part of it has been the updations to the very poorly coded software in asp. Now I am going to redevelop entire software in asp.net. I want it to be very efficient. I need some tips and guidance about how to plan project and design a good database. Thanks in advance for help. ...
i am trying to run a query in another server and need to specify it in the select statement but the server name has got an '-' in it, like server-name. this is producing the error in the title. How can i fix it? ...
I've got a table which has a column named id which is of type Identity. But this column contains duplicate values 1..8 and then again 1..10 How in the world is this possible? ...
i have generated the script and created the schema in my computer. now how can i get the tables data? i dont have enough access in the remote database to copy it. Can it be done using sql server? ...
Let's say I have an item table with columns id (PK), parent_id (FK), name, and date. I also have an item_parent table with columns id (PK) and name. Items can belong to the same parent, or an item can have no parent (parent_id can be null). I am trying to construct a SQL query to select all items ordered by date (DESC), keeping all item...
Below is a SQL Server 2005 update trigger. For every update on the email_subscriberList table where the isActive flag changes we insert an audit record into the email_Events table. This works fine for single updates but for bulk updates only the last updated row is recorded. How do I convert the below code to perform an insert for ever...
My 32bit .NET application runs SQL 2005 Express SP3 and uses CLR. The install works fine on XP & Vista. The install fails on XP 64bit & Widows 7 64bit machines. The error is in one of my SQL scripts that creates an Assembly: Error: “Execution of .NET Framework code is disabled. Set ‘CLR enabled’ configuration option and restart server....
Hey everybody, got an interesting question I think. I've got a Silverlight3 application which is querying a SQL Server 2005 database asynchronously. However, some of the data sets the queries return are massive and so I'm looking into data pagination. Goals: 1) Just in time data calls - I only want to query for page 3's data when the ...
This .NET application used to work. When it did we were using the Oracle ODBC 9i. We moved to 10 g did not work anymore. Now at 11g stills does not work. I have set SQL Command Timeouts all over the place. I have set the connection timeout and the query timeout in the linked server properties to 120. I can run the proc from SQL Ser...
I have two tables, jobcli client_id job_id jobs job_id jobTitle startDate projectmgr What I am having trouble with is to display client_id, job_id, jobTitle, startDate, and projectmgr in a query, where the results are grouped by client_id and have max of date. So far I can get a list that's groupped by client_id with their c...
In SQL Server 2005, there was a stored procedure available called sp_generateinserts. However in SQL Server 2008, it doesn't seem to exist. Does anyone know if it is still around? Thanks. ...
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target ...
Hello, I have a complex DB in SQL Server format. I've already written several queries to get the anlysis I need, how ever each time I want to add another layer of data/field it takes much time. I am interested in something like the features DabbleDB has/had at which you could select columns from various tables and it would integrate th...
The task is to copy table1 ( A,C,B ) to table2 ( A,B,C ) Tables effectively identical, the same fields/constraints just physical sequence of fields is different. Can I do it with standard tools and minimal coding. For bulk copy in this case mapping for each field pair seems to be required. ...
how to write a if else statement to insert query for showing the error in stored procedure below is my stored procedure.I want to show a error message when already inserted student_id is insert again..Student_id is primary key so its show error in my code but i dono how to get that error and show ....how to do friends plz help me..... ...
I am trying to put the query result into a PowerPoint file like the below EXEC XP_CMDSHELL 'SQLCMD -Q "Select * From test_tbl" -O "E:test_tbl.ppt"' but it is not working. Below is the summary that I am getting **output** Sqlcmd: Warning: '-O' is an obsolete option and is ignored. Msg 208, Level 16, State 1, Server SUMERU-49484E24, ...