Viewing 12 posts - 136 through 147 (of 147 total)
You could add an additional input to the SP and pass the name of the SP calling into it (OBJECT_NAME(@@PROCID))
January 24, 2013 at 9:13 am
SET NOCOUNT ON
DECLARE @StatsToUpdate TABLE ( StatName NVARCHAR(MAX) )
DECLARE @StatUpdating NVARCHAR(MAX)
INSERT INTO @StatsToUpdate
( StatName
...
January 23, 2013 at 9:30 am
DECLARE @table TABLE
(
ProposalId INT,
RiskId INT,
RiskTaken BIT
)
INSERT INTO @table
SELECT 1, 1, 1
UNION ALL SELECT 1,2,0
UNION ALL SELECT 1,3,0
UNION ALL SELECT 2,1,0
UNION ALL SELECT 2,2,0
UNION ALL SELECT 2,3,0
;
WITH ProposalRisk
AS
(SELECT DISTINCT ProposalId FROM...
January 23, 2013 at 7:49 am
lestatf4 (1/23/2013)
Surely the column order in the query is irrelevant to the optimizer?
create view...
January 23, 2013 at 5:35 am
CREATE TABLE #ExamResults
(
Pass_Fail CHAR(1) ,
ExamScore INT,
)
INSERT INTO #ExamResults
...
January 18, 2013 at 9:05 am
You can't do this directly.
You would need to add a text box (name it Outcome) into say a table / matrix on the report which shows the records and the...
January 18, 2013 at 8:58 am
Ah yes. I misread the original spec. Your method way better
November 22, 2012 at 1:58 am
Are you able to alter the staging table to add an extra column in there? If so there is a nice solution to this similar to the one we...
November 21, 2012 at 8:36 am
This is is no way elegant or the best solution to the problem and I have made some assumptions about the table field types and lengths etc and will be...
November 21, 2012 at 7:29 am
Depends on where you have the sub report? Is it in a group footer? It may be worth putting in whileprintingrecords; on the sub report
November 1, 2012 at 7:02 am
Probably not the most efficient or elegant way to do it but works for me
DECLARE @sql NVARCHAR(MAX);
DECLARE @dbs TABLE
(
...
October 22, 2012 at 9:10 am
Create a text box parameter called searchstring so the user can enter the search string they want.
Create a dataset with the following condition:
select * from <yourtable> where <yourfield> like '%'...
March 29, 2012 at 6:50 am
Viewing 12 posts - 136 through 147 (of 147 total)