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...
Thanks for your quick HELP!!!, This works now.
What you said is correct. I'm trying out this query, but doesn't come up with correct results. What could be the issue. select...
I have a table with this structure: UserID varchar(10), NotesDate DateTime Notes Varchar(3500) I have records like this: jgamma1 May 10 2002...
I'm not using any Locks with the query. Also I cannot reduce the joins since we are fetching data from those tables.If i'm using giving no lock with...
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.
Adriaan, Can you please explain me more on how you are doing this.Thanks for your time.
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...
This query only returns the last row and not all. Should I have to use a cursor? Please advise.
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...
I applied this formula and got it rendered correctly. (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width Thanks for your...
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...
Separate names with a comma.
