Hello, I've done a asp.net application to generate reports over a particular data. Initially i created local reports (.rdlc) to generate reports. I created separate .xsd for each rdlc and designed the reports. I build the dataset programmatically and bind it to the rdlc. I used the following code for binding the datasource to the report...
I want to know that is there a solution for formatting the output of the report controls like css that is used for web forms? ...
Which are the reliable registry entries to see install versions of SQL Server? Like if I have 2005 and 2008 both installed on my machine, how can I check this in registry? Also how to check which is the default one? ...
After using SQLite for development and beta-testing for a home-project I want to migrate the DB to Microsoft SQL Server to get better performance. Is there any free/cheap utils that will do this? So far I have found DBConvert that looks like a good product, are there others? ...
I tried to use text or ntext as the variable's type but they are disallowed. Is there a way to bypass this? ...
I want to get some random records from db. There is two solution for this : 1- Using TABLESAMPLE for getting data from db directly. 2- Write a method In my application for doing this. In this method we generate multiple random number and get data like this : select * from db where ID = @RandomNumber if this ID does not exist, I pass...
How can I supress hyphens (------------) from the results set of this sqlcmd-command: C:\temp>sqlcmd -d AdventureWorks -s ";" -Q "SET NOCOUNT ON SELECT top 5 FirstName, LastName FROM Person.Contact;" FirstName ;LastName --------------------------------------------------;--------------------------...
As you know the PIVOT syntax is like below : FROM table_source PIVOT ( aggregate_function ( value_column ) FOR pivot_column IN ( <column_list>) ) table_alias I want to know is it possible that we pass a query as <column_list> to PIVOT? In action, I want to write FOR DepartmentName IN (SELECT Name From Department)) instead of ...
Last night I got completely hosed by a worm from Dilbert.com (so be careful there). It is invasive enough where I am going to do a complete system restore. The only thing I need to save on the pc is a database (consisting of just tables & stored procs) in SQL 2008. How can I export them so that, once I restore, I can easily import them a...
How does INSERT, UPDATE & DELETE work on a SQL Server table partition? Technical explaination please how the SQL server engine handles table partition vs non table partition. ...
There are two tables that I join them together, one of them is a temp table and I create an index after creating the table. But it is said in the query execution plan above. what should I consider to convert all scan operations to seek operations? There are parts which are joins and where conditions... Regards bk ...
Hello, I want to ask if there is a way to show results (all at once) just after the query ends execution? In other words, I dont want to see "Partial" records on the way of query execution. Thank you. ...
I want to be able to choose a groupID and do a cascading delete through three tables which are found in a MS SQL server database. The tables look like the following: table 1 - GROUP ------------------------------------------- groupID | description | etc table 2 - MEMBER ------------------------------------------- memberID | name | et...
We have a function that pulls the date from the first 8 characters of a string. Because of the way this system was written, the users are told they have to enter the date in an 8 character format in the field. For example, 12/06/10 must be entered. The way the original function was written, 12/6/10 or 12/06/2010 would generate a wrong...
Can somebody please let me know how we can determine if a local disk or SAN. Thanks ...
Hi all. I have a little problem with a query. I'm selecting data using the between command, But when I select the initial date equal to the final date the query doesn't show data. I know that the problem is the format. In my database I got something like this:2009-05-22 15:32:52.000. But when I send the date parameter from ASP.NET Page...
I have an application (ASP.NET MVC) that uses a Next New method to get the next new piece of work. The user clicks on a Next New button, and my NHibernate code would go fetch the next piece of work with an Active status. As the number of users has increased, we have seen an issue arise where 2 users can get the same piece of work. This ...
Have you any problems using it on high concurrency environment? It's really works as advertised by MS? I'm using SQL Server 2005 and would like to hear the experiences of those who are/was using it on applications using it on production. Snapshot isolation per se is not new for me as I develop/administer Firebird/Interbase as well - whe...
I need to make a local copy of a database in a .NET app so that it can function offline. My server database is SQL Server 2005, and it's copying to SQL Server 2008 Express. It doesn't have to be anything fancy - just start from scratch (or delete the existing db), copy all tables/constraints/foreign keys, and copy data from some of the...
We have a SQL Server DB with 150-200 stored procs, all of which produce a viewable query plan in sys.dm_exec_query_plan except for one. According to http://msdn.microsoft.com/en-us/library/ms189747.aspx: Under the following conditions, no Showplan output is returned in the query_plan column of the returned table for sys.dm_exec_quer...