Viewing 15 posts - 5,971 through 5,985 (of 7,168 total)
I do not know of a tool that will piece that together for you.
If you know specifically what you're looking for you could search the definitions of the all sql...
June 20, 2011 at 4:38 pm
Selvaraju (6/20/2011)
June 20, 2011 at 4:26 pm
June 20, 2011 at 4:19 pm
sturner hit the nail on the head...we must have been working on this at the same time
June 20, 2011 at 3:36 pm
Thanks, but a picture is not going to help much. Can you please save off the plans as .sqlplan files and attach those?
June 20, 2011 at 3:22 pm
SSIS is type-safe and is fussy about implicit conversions from one data type to another which is what you;re experiencing. Basically, in all the cases you mentioned, it's complaining about...
June 20, 2011 at 3:04 pm
It sounds a little bit like you're aiming to re-invent the wheel...are you sure this is something you want to give users the ability to do?
If you must, then here...
June 20, 2011 at 2:18 pm
Doing a text compare these are the only diffs:
|--Top(TOP EXPRESSION: ((1)))
|--Nested Loops(Left Semi Join, WHERE: ([SearchDB].[sys].[fulltext_index_docidmap_132195521].[docid]=FulltextMatch.[docid]))
|--Top(TOP EXPRESSION: ((2)))
...
June 20, 2011 at 2:08 pm
Oops, I neglected to mention one thing...I changed the variables from Int32 to Double. Please do that and you'll hopefully see what I see.
June 20, 2011 at 1:59 pm
satishchandra (6/20/2011)
returns table
as
If (@TestCol =1)
select 'Abc' as Col1
else
select 'xyz' as Col1
-----Gets the following error
Msg 156, Level 15, State 1, Procedure fn_test, Line 6
Incorrect syntax near the...
June 20, 2011 at 1:54 pm
See if something along these lines will work:
@Row_Count_tblA /
(
(@Row_Count_tblA - @Row_Count_tblB) == 0 ? NULL(DT_I4) : (@Row_Count_tblA - @Row_Count_tblB)
)
* 100
June 20, 2011 at 12:14 pm
kramaswamy (6/20/2011)
June 20, 2011 at 11:44 am
vinaseetha87 (6/20/2011)
Stored Procedure -How to Pass @SortColumn And @SortOrder
SQL is a declarative language, i.e. this does not work:
DECLARE @SortOrder NCHAR(4),
@SortColumn SYSNAME ;
SET @SortOrder = 'ASC' ;
SET...
June 20, 2011 at 11:37 am
Will dot ( . ) ever naturally appear in the string?
If not then something like this may work:
SELECT PARSENAME(REPLACE('RNL00:123456-3:1', ':', '.'), 1),
...
June 20, 2011 at 11:30 am
Viewing 15 posts - 5,971 through 5,985 (of 7,168 total)