Hello, I have installed MSDE in my work station. I have created a userid/password combination. My colleague is trying to connect to my MSDE database...
I have a table with this structure: UserID varchar(10), NotesDate DateTime Notes Varchar(3500) I have records like this: jgamma1 May 10 2002...
Hi,<br /><br />I have written a Stored Procedure which has nothing but select queries which joins nearly 8 tables. My SP uses a dynamic query and so...
This is my problem... I've a got a textbox containing a memo (text) field of my sqldb. At the place where the textbox should be, there's not enough...
I'm trying to use dynamic SQL inside a UDF. Is that possible, I can go for SP but, This UDF I'm combining with my master select query.
I have a UDF which queries a table. The UDF uses a Cursor to concatenate a column and return it to the calling select statement. Since the UDF cannot...
I have a table called tblEntity and it has the structure like this: entity_id int entity_name varchar(255) display_name varchar(400) column_name...
I have designed a report. When I deploy it from my system to the Report Server, It is deploying fine. The same RDL when its is deployed from another...
I need to connect to a remote sql server database using windows authentication.I have the username/password (its actually a windows account in their...
I have a simple select query displayed in Table control. What I want to do is to display a total at the end of each page ( In the table footer or...
I have a table which has 10 records. tblNotes ======== Notes1 Notes2 Notes3 etc ... Notes10 I want to write a select query which returns all the...
I have placed a list control arranged textboxes which has values from the database. Since list is free form, I have arranged each record display in...
We are designing a landscape report. When exporting to PDF, we are getting lot of blank pages in-between, how to resolve this.Any idea would be of...
I have a report in which I want to limit the number of records per page to 5. How do I achieve this. If I adjust the report page size, The number of...
We are installing sql 2000 reporting server. Issue is we are selecting a database different from the current system where the reporting server db...
I have installed Visual Studio.NET 2003 in my system. I couldn't find the Business Intelligence Projects which is needed for designing reports. How...
I have a sqlserver database which has few tables. I have 7 users accessing those tables. All of them have administrative privileages on those tables....
I have a Query which returns over 3 LAKH records, I have to show them in my page as 100 records..Now i'm using ADO recordset paging and showing...
I have a query like this: select distinct partno from plop where partno NOT in (select distinct partno from ploptemplate) Its taking much time, I...
I have three tables as follows: 1)tblDestination 2)tblQueue 3)tblGroup tblDestination.QCode=tblQueue.QCode tblDestination.GCode=tblGroup.GCode Now...
Separate names with a comma.
