Question:
I have build a SSIS package.
I would like to send some data in a tabular format as part of the email message body.
(not as an attachment)
I have tried SSRS – but this doesn’t work for my requirements. I need to change the subject based on the count of rows returned from the query”
eg . Subject: [...]
Question:
I am learning Reporting Services and I havre SQLExpress 2008 with Reporting Services loaded on my local Machine. I have learned to author reports and now I want to open the Report Manager. I am told to go to the default location of
http://ComputerName (my local computer name)/ reports
or
http://localhost/reports
but the browser gives the error message that [...]
Question:
I would like a window to pop up once the system date and time equals a date and time selected in a datetimepicker control. I.e., User selects date and time in a datetimepicker and when the system date and time equal the time picked, a window pops like a reminder in outlook.
Any thoughts on how [...]
Question:
The following query
sum(convert(numeric(6,2), .NoOfMeals * DiscountPrice))
returns different result if Qty is numeric or decimal. For one, it returns the correct value, the other it returns NULL. What is the right way to convert this?
Thanks
Solution:
remove the dot before the NoOfMeals
select sum(convert(numeric(6,2), NoOfMeals * DiscountPrice))
Question:
I have a tab on an Access form whose property is set to not visible when the form opens and only becomes visible when a command button on another tab is clicked. What I want to be able to do is make that tab not visible once someone clicks on another tab. I put the [...]
Question:
I’m hoping this is relatively straightforward. I’m getting ready to install SQL Server 2008 on a production server. Here’s the short Q: Can it co-exist with an already installed vesion of MS SQL Server Desktop Engine 8.00.761 (MSDE) and a seperate instance of SQL Server 2000?
The whole story if you are interested: We are running [...]
Question:
I successfully installed SQL server 2008. But have trouble connecting to the DB engine.
I am running it as ADMIN.
But still.. it throws error.
Things to be checked like.. Services and TCP/IP and the error i am getting are in the attachments.
Please suggest
Solution:
Also, connect to the instance as “.\SYED”
Question:
I am using outlook 2007 and outlook connector to an MSN permium account. It has worked flawlessly for years.
The last few days the calender has been moving my calender entries around by itself. Usually by exactly one hour. In other words put an appointment in at 11pm look at it again a little later I [...]
Question:
I have a stored procedure that returns an integer value (ie the number of rows modified). I need to know how to return the number of rows modified and the actual modified rows.
I can make an output parameter to hold the number of rows modified, but the rows being modified are in a temp table [...]
Question:
This is my first forayinto SQL Store procedures in quite a while. I am trying to create a procedure that will return the row count, but what I have written simply will not work. What am I doing wrong?
Code Snippet:
CREATE PROCEDURE dbo.Sandra
@prodID int,
@rownum int output
AS
SELECT C.CategoryName, P.ProductName,
OD.UnitPrice, OD.Quantity, OD.Discount
FROM Categories AS C INNER JOIN Products [...]