Viewing 15 posts - 4,366 through 4,380 (of 11,678 total)
Just make sure that each part of the query that is not dynamic is a string properly enclosed with double quotes.
The variables need to be concatenated to the strings using...
October 23, 2013 at 12:51 pm
wolfkillj (10/23/2013)
Koen Verbeeck (10/17/2013)
There are certain characters XML cannot handle, because they are used by XML itself.For example: < > & " '
It's...
October 23, 2013 at 12:39 pm
wolfkillj (10/23/2013)
I've published my first technical blog post. I'd appreciate any feedback from this group on both the technical aspects and the writing. Thanks, everyone!
Nice blog post. Very good for...
October 23, 2013 at 12:36 pm
Suresh Babu Palla (10/23/2013)
Yes, I managed to getrid of subqueries and joined all my selects in to one and got the result.
Great, glad you got it worked out.
October 23, 2013 at 10:58 am
Perhaps you can specify EXECUTE AS dbo in the stored proc and make sure your colleagues have execute permissions on the sp.
October 23, 2013 at 7:46 am
Grant Fritchey (10/23/2013)
October 23, 2013 at 7:24 am
avishain (10/23/2013)
but i have to keep this format since i execute this string via EXCECUTE SQL TASK ( i send it to an oracel DB to...
October 23, 2013 at 7:09 am
GilaMonster (10/23/2013)
Koen Verbeeck (10/23/2013)
Beatrix Kiddo (10/23/2013)
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I utterly refuse to believe this :-D.
Ask them about SSIS 🙂
What's...
October 23, 2013 at 7:03 am
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
October 23, 2013 at 6:56 am
avishain (10/23/2013)
i got a variable which is an Expression.
my expression is this:
'||'''DateVar'''||'
i got another variable which is the DateVar and looks like :
02/07/2013
i want to populate the expression and...
October 23, 2013 at 6:55 am
GilaMonster (10/23/2013)
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I am not a DBA. I have never once had a DBA job. I'm...
October 23, 2013 at 6:51 am
Not a pre-defined function, but there are several methods to achieve your requirement.
Concatenating Row Values in Transact-SQL[/url]
The XML one is my favorite.
October 23, 2013 at 5:50 am
Beatrix Kiddo (10/23/2013)
(What's SSC in this context? Wikipedia suggests So Solid Crew :cool:.)
SQLServerCentral 😉
October 23, 2013 at 5:49 am
Suresh Babu Palla (10/23/2013)
Thanks for your Inputs. I did managed to join the tables.
Did you get rid of the subqueries?
October 23, 2013 at 4:44 am
Smash125 (10/23/2013)
Have checked the Execution Log. It says the same thing. Apart from this any thing I can do to improve
If the report takes 16 seconds to execute, the...
October 23, 2013 at 4:43 am
Viewing 15 posts - 4,366 through 4,380 (of 11,678 total)