Search results for query: *

Hi all, I have a minor issue with a matrix report. I would like the output to look like this...I have made up the column names for the purposes of illustrating the point. Male Female Total Single Married Single Married Single Married USA 10 5 2 20 12...

I would like to find midnight of the previous day. Try the following code: DECLARE @start_date DATETIME DECLARE @start_date1 DATETIME DECLARE @start_date2 DATETIME SET @start_date = getdate() PRINT cast(@start_date as varchar(50)) SET @start_date1 = DATEDIFF(dd,0,@start_date) PRINT...

Hello all, as a newbie to SQL 2005 I started using table vars in my sp code - until I realised that for sps that returned large result sets this could be a really bad thing ;-) Now that I have identified and fixed the source of my non-executing sps does anyone know of a sizing document/white...

I am new to MSSQL 2005 and I've 'solved' the problem, but just wondered if anyone else has come across a similar issue. I have a stored procedure which has a static SQL statement that contains a clause this... SELECT pn1.given_name, pn1.family_name, per1.date_of_birth FROM dbo.person per1...

Hello, I have a problem with using BOE XI to export a report to HTML. The situation is that the report's output is designed to be embedded within a web page generated on the fly along with information derived from other sources. I use ASP scripts to give the required functionality. The issue...

I have a number of clients at different physical locations, all of whom use the same set of cubes but very likely for different reasons. I initially set up each cube's aggregation based upon what I thought were the most appropriate aggregation usages, i.e. each dimension used in the cube would...

I am using SQL Server 2005 beta - Microsoft SQL Server Management Studio version 9.00.1116.00 I've read the SQL Server doco and looked around a fair bit but can't really find anything that helps me. Here is the question: 'What is the recommended approach to implementing a domain in SQL Server...

Hi all, I've had a look around the posts but can't find anyone with a similar issue. Here is the problem :- I have a main report that calls a sub report and the sub report returns the number of enquiries for a particular product. Don't ask me why I am using a sub report its not really relevant...