Viewing 15 posts - 796 through 810 (of 902 total)
A Question on the multi selected, is the intention to have the @Item variable store the results of the selection by the user?
Ninja is correct about an Indexted Temp table...
October 7, 2011 at 3:02 am
Jnrstevej (10/7/2011)
When i try running the script i get the following error which i cant seem to fix
Msg 102, Level 15, State 1, Procedure Waterfall_version2, Line 22
Incorrect syntax...
October 7, 2011 at 2:59 am
Ninja's_RGR'us (10/6/2011)
Can you run the sp alone in ssms?
If yes, you can try dumping the dataset and redoing...
October 7, 2011 at 2:39 am
Sorry I've been quite busy with a some other work.
I seems like a lot of effort to get a distinct list of Items.
A couple of suggestions, dont use SELECT....INTO...
October 7, 2011 at 2:08 am
No problem. 😀
October 3, 2011 at 5:59 am
I take it you're allowing muliple selects in the SSRS, one thing to remember is that SSRS will send multiple items as a CSV string. eg 'A102,A103'.
So what you need...
October 3, 2011 at 5:30 am
Are you physically defining your temp table with a create or being lazy and doing a SELECT....INTO?
There are issues with SSRS (and SSIS) where by if you return data from...
October 3, 2011 at 4:54 am
You could use the INFORMATION_SCHEMA.COLUMNS
SELECT
'ALTER TABLE [' + Table_Schema+'].['+Table_Name
+'] Alter Column ['+Column_Name+'] varchar('
+Convert(nvarchar(5),Character_Maximum_Length)+');'
+ ' Update ['+ Table_Schema+'].['+Table_Name
...
October 3, 2011 at 4:47 am
I've never come across this syntax in 10 years of T-SQL programing, but its good to see it, and the explination for it.
I think 98% of people would written...
August 17, 2011 at 6:56 am
Vishal Singh (8/4/2011)
Not sure wwhatswrong with this query but whenever I am running this, I am getting all those rows with State='closed' which it should ignoring.
SELECT [ID],Priority,Title,[Created By],[Assigned To],...
August 4, 2011 at 5:10 am
Its something very similar yes, skcadavre, though i think you're missing an | in the last regex expression.
No problem Paula, I've been asked to do similar things in the...
May 18, 2011 at 5:22 am
Paula
you may have a problem with the way you are stripping the start of the postal code, especially those that only have a single letter and single digit at...
May 18, 2011 at 4:39 am
Stefan, I dont think CELKO was having a go at you more the Original Poster.
May 17, 2011 at 11:25 am
I can validate that based on the sameple data that you provided in the original post Chris's method works as intended.
The averages, for each row is 11.33,26.33,44.00,55.00.
May 16, 2011 at 12:37 pm
I think the method with the SIGN functions should read :
(SIGN(ISNULL(Col1,0))+SIGN(ISNULL(Col2,0))+SIGN(ISNULL(Col3,0))+SIGN(ISNULL(Col4,0)))
May 16, 2011 at 10:11 am
Viewing 15 posts - 796 through 810 (of 902 total)