Viewing 15 posts - 6,376 through 6,390 (of 15,381 total)
Luis Cazares (10/28/2013)
October 28, 2013 at 10:44 am
arkiboys (10/28/2013)
This error message is entirely mis-leading.You are not allowed to have nested procedures containing INSERT INTO EXEC
Not sure how to solve it though.
Finally an error message.
It is really...
October 28, 2013 at 10:42 am
What is returned from the following?
exec uspMain
October 28, 2013 at 10:21 am
Take a look at this post from Lynn. It has a lot of excellent datetime functions.
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D
October 28, 2013 at 10:16 am
OCTom (10/28/2013)
Revenant (10/25/2013)
Luis Cazares (10/25/2013)
October 28, 2013 at 10:14 am
mssqlnoob (10/28/2013)
SELECT ISNULL(NULL, 1)
1
in this case the first expression should be returned which in this case should be null, why is it 1?
thanks
It is returning 1 because that is...
October 28, 2013 at 10:06 am
arkiboys (10/28/2013)
So then I tried to see if I can over come the error by running dynamic sql to execute the sp and insert into...
October 28, 2013 at 10:03 am
sestell1 (10/28/2013)
Nice one Sean.I always forget about PARSENAME as I never seem to consistently have 3 or less delimiters.
Yeah it is somewhat limited but pretty handy when you can use...
October 28, 2013 at 9:42 am
Your query as posted now should do what you are saying it needs to do.
October 28, 2013 at 9:39 am
arkiboys (10/28/2013)
The stored proc has in it a few queries with insert into...So if I run what you suggested, I get the error:
INSERT EXEC statement cannot be nested
I think now...
October 28, 2013 at 9:29 am
itsjustme (10/28/2013)
I am trying to select rows on Table A to get correct records that doesn't have any records on Table B.
Table A has a column called IP1 (10.1.1.20)
Table...
October 28, 2013 at 9:26 am
kdaniapam (10/28/2013)
HiThanks very much. I have managed to get it working the way I want
Do you still have a scalar function? Do you still have a while loop? If either...
October 28, 2013 at 9:24 am
wolfkillj (10/28/2013)
rodjkidd (10/28/2013)
I know what I know and I know people (Paul Randal, Paul White, Jeff and Gail etc) who know a heck of a lot more than...
October 28, 2013 at 9:08 am
And you need to parameterize your dynamic sql. What you are doing is directly executing a parameter to your proc. This is the text definition of sql injection.
See if...
October 28, 2013 at 8:15 am
You can make it even simpler and remove reverse entirely (which can be kind of nasty for performance).
with Something as
(
select '000006-00005-254-008' as SomeValue union all
select '010122-00008-141-113' union all
select '003215-00011-tr-009' union...
October 28, 2013 at 8:08 am
Viewing 15 posts - 6,376 through 6,390 (of 15,381 total)