Technical Question

Oct 11, 2007

Hi,

My question concerns the number of connections reporting services opens to generate a report with
several subreports in it.

I have a main report with 3 datasets, all based on different store procs. In the same report i also have
2 subreports who each have 1 dataset, also based on store procs.
When the report is being generated, how much connections does RS opens to the sql server?

Greetz,

Vinnie

View 1 Replies


ADVERTISEMENT

Non-Technical Question

Oct 27, 2005

Unlike the majority of this posts, my question isnt anything technical, what i needed to know is if anyone knows any SQL Server presentation, giving a overview of the application (its history, layers, services,etc) that i can download? I´ve searched on this website and on google but so far didnt had much luck since most presentations i find are very narrowed and dont give the general overview that i needed from SQL Server.

Thanks in advance and sorry about my english since its not my native language ;)

View 7 Replies View Related

Technical Manuals Of SQL

Feb 2, 2006

Hi everyone,

I am making my first steps to SQL..
someone can help me ....
saying to me some place where it could lower papers, technical manuals, etc ... of SQL
I would like knowing the commands and processes that SQL handles,
with the idea of doing my own programs.
Example, simple....

DECLARE @dt datetime
SELECT @dt = 'Jun 13 1995 12:00:00'
SELECT CONVERT(varchar(10),@dt,101)

in this code the commands are seen....
DECLARE
@
CONVERT

Can someone please help me

Thanks

View 3 Replies View Related

Request For A Technical Term

Apr 13, 2006

I'm not really sure how to explain this, so please bear with me.
I have a SQL statement, such as:
SELECT TOP (10) FROM chartTracks
This works with SQL Server Express 2005, but when I moved my site over to work with a MSSQL Server 2000, the statement had to be changed in order for it to work:
SELECT TOP 10 FROM chartTracks
I was just wondering if there was a technical term for this, and if possible, the locations of anymore sourecs of information regarding the above?
I'm just writing a report and would like to include this, if possible. Thanks in advance!
 

View 2 Replies View Related

Detailed Technical Design (DTD)

Apr 10, 2007

Hi,

I'm a newbe in SQL Server and I have to build "Detailed Technical Design" Document regarding the SQL Server . If anybody knows something or has an example / structure about this document please send me a replay.....

Thank you in advance

View 1 Replies View Related

Can I Have A Simple Technical Example Of How To Start?

Jun 14, 2007

I find difficulty in getting started with the service broker, and didnwt find a simple example.

I understand service broker is used for usynchronous jobs.

For example- I want to have a service that will perform SQL commands.



What are the necesary commands to create the queue,

to add the comand "Update MyTable Set MyField=1" to it,

and to get the command and perform it in another sesion?

View 3 Replies View Related

Own Query Language For Non-technical Users, Any Frameworks Known?

Jul 23, 2005

HelloWe have the challenge to introduce for our database applications adynmaic search for the end users. The end users are non-technicalusers.I am looking therefore for possibilities which would allow to build ownquery language with expressions according to the need and skills forthe users.I found one product so far. "EasyAsk - Decision Adviser". does somebodyknow also other tools or frameworks which can be integrated?http://www.easyask.com/product*s/decision-advisor.cfmThe environment is currently MS SQL Servers and C# Webservices.Myvision is to have a framework or library which can be seamlessintegrated into our existing solutions which is currently a smart C#clients. i.e. by using web-service or an C# API.thanks Mark Egloff

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved