SQL Server Data Services (SSDS) Interview Questions 

I've tried to use the where service_date < 03/13/2007.. but it does not give me the logical result that i need...please help me...can you help me to get all the data that the date will not be greater than October 28, 2006..thanks...i only need the where part...thanks...

Bare with me...I am learning

I need help generating a report using SQL Reporting Services. I was told by my instructor that a stored procedure would allow me to combine 2 queries into one (basically). Here's my dilemma. I need to create a report that will display my data --and-- sum the balance column in the data. However, when I add the exec statement in the Query Builder (in Report Server) it only displays the first query and NOT the second. Any help is appreciated

Here's the create procedure statement I created:

Create Procedure Report

AS

Select *
From Chart_of_accounts
where account between 610004 AND 610013

Select Sum(balance) as [Total_Balance]
from chart_of_accounts
where account between 610004 and 610013

-------------------------------------
Now, in the Query builder I enter "Exec Report"

But the displayed results in the report only show the first SELECT statement and not the second. How can I get the report services to display a sum of the "Balance" column ALONG WITH the data itself.

COLDFUSION WEB DEVELOPER
Talented goal oriented individual with over eight years experience creating data-driven accounting, human resource and ecommerce solutions for customers on various platforms.
?Innovative approaches to problem solving.
?Hands-on experience leading all stages of system development efforts, including analysis, design, development, implementation and support.
?Outstanding leadership abilities; able to coordinate and direct all phases of project-based efforts while managing, motivating, and leading project teams.
?Adept at developing new applications that push the limits of current technology.

CORE COMPETENCIES: Coldfusion MX, Coldfusion Components, Microsoft SQL, Web Services, Web Application Design, Development, and Support.

* Platforms: Microsoft Windows® operating systems, Linux (Red Hat, CentOS, Fedora), and MacOSX
* Networking: TCP/IP, FTP, SSH, HTTPD, SMTP, POP
* Languages: Cfeclipse, Macromedia Studio, Notepad++, Aqua Data Studio, SQL Tools

I am looking to get into a SQL position (wiht Oracle), and they said with no prior expierance it would be 35K. The job is part customer service, dealing with the customer and explaining to them the database and writing scripts to modify data if they put it in wrong.

Is a job like this a good starting point, or am I heading down the wrong road?

I'm working on a report which has these input parameters:

StartDate (textbox, data type is datetime)
EndDate (textbox, data type is datetime)
AccountNumber (dropdown, data type is string)

I need to set up logic where if the user viewing the report has input only date values, they'll be prompted to select an AccountNumber, or if they select an AccountNumber they'll be required to select a valid date range.

I've successfully created functions for purposes of validating the fields, and put these on the Code tab of the Report Properties, but now I'm not clear on how to make this work from the report itself.

Can I pop up a messagebox that fires if the user hasn't input the required info and they try to View the report? Or can I just populate a textbox with some error text like "Hey dummy, you forgot the AccountNumber"?

I have some data....i want it to convert into excel,pdf,html......can i convert them as i like..is there any opton like this.........

I need to use a webservice to send and receive data from an SQL Server 2005 database. My problem is I do not have much knowledge on creating webservices. I need to create Web Methods that return class arrays and take in dataset. Please help!

I have a report that has salespeople names in the rows and Years in the columns. It shows sales for the data. So it shows 2007 sales and 2008 sales for each salesperson. How do I create a column that will compare 2007 sales to 2008 sales?

How can I dynamically place column headings into a Table? I'm using SQL Reporting Services 2005. I'm using a table instead of the matrix because we wanted fixed columns. I've placed my data into the correct column, but I'm stumped onto how to get the headings.

My PROC returns my data in the correct colunms and I'm hiding the details and using the footers to display the data. But that won't work for the columns.....

I need to know how to have a bar chart and then data plotted as a line as well with differing values on the y-axis.

if we can, how to do it?