Viewing 15 posts - 10,471 through 10,485 (of 11,678 total)
irobertson (1/14/2011)
Hi,Another way is to use a table variable to limit your values:
...
Just because I find it a bit easier to read than dynamic SQL...
You are right, that is a...
January 14, 2011 at 3:45 am
Niteen.gavhane (1/14/2011)
CREATE PROCEDURE testbizclose_remove
(
@Par int
)
AS
SELECT DAY FROM BIZ_CLOSING WHERE BIZ_ID = 802 and (case @Par when 1 then shift in( 1,4,6,7) when 2...
January 14, 2011 at 3:14 am
brian.willis (1/13/2011)
January 14, 2011 at 12:51 am
Grant Fritchey (1/13/2011)
Does a heck of a lot more than just format the code too.
That sounds like: it does also your dishes, the laundry and it unclogs your toilet 😀
January 14, 2011 at 12:14 am
johnzabroski (1/13/2011)
"By the time that SQL Server 2000 was released,...
January 14, 2011 at 12:04 am
Stefan Krzywicki (1/13/2011)
Is the INTO just there to make it compatible with ANSI standards?
They threw it in so Celko would be happy.
January 13, 2011 at 11:43 pm
bruce.b.allen (1/13/2011)
steveb. (1/13/2011)
or you could put the data as is in a...
January 13, 2011 at 9:33 am
You can force the execution result of the data flow to succeed, so your loop would always continue.
However, this raises another problem: how to detect failure? If you can do...
January 13, 2011 at 9:30 am
Paul Brewer (1/13/2011)
For SSIS jobs there's an 'Execution Options' tab iwhere you can specify 'Use 32 bit runtime' , no need to write batch files.Regards
That is unfortunately only possible from...
January 13, 2011 at 8:59 am
MARKDSQL (1/13/2011)
That sorted it, thanks very much.
No problem, glad to help and that it worked out.
January 13, 2011 at 8:54 am
dkschill (1/13/2011)
I was trying to demonstrate the EXISTS syntax as a replacement for IN.
That will only work if you are looking for the existence of rows that have a particular...
January 13, 2011 at 8:52 am
Jan Van der Eecken (1/13/2011)
Ray K (1/13/2011)
Thank you, fellow Threadizens, for coming to my rescue -- and I'm not just talking about getting my simple question answered.I've been Celkoed again.
In...
January 13, 2011 at 8:46 am
Toreador (1/13/2011)
You mean I was supposed to read all the words in your reply?!
For the one time Hugo has fairly short reply 😀
January 13, 2011 at 7:45 am
MARKDSQL (1/13/2011)
Can i specify wether to use, or not use...
January 13, 2011 at 7:42 am
Viewing 15 posts - 10,471 through 10,485 (of 11,678 total)