Viewing 15 posts - 451 through 465 (of 1,183 total)
One option is .... Look at Red Gates' SQL Packager.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 2, 2008 at 4:25 pm
I know I'm commenting late, but at least OleHank titled the post appropriately.
I do not envy your position. :w00t:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 2, 2008 at 4:02 pm
DECLARE @t VARCHAR(15)
SET @t = '111.222.333.444'
SELECT PARSENAME(@t,4),PARSENAME(@t,3),PARSENAME(@t,2)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 30, 2008 at 8:01 am
Mani Singh (6/23/2008)
did you check filter by table_schema in information_Schema.columns.
That's where it said FLOAT.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 24, 2008 at 7:08 am
GOT IT.
Changed the datatype from VARCHAR(7) to VARCHAR(8) and back again.
But still unsure how this could happen?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 1:07 pm
Place it between the code blocks. Look to the left in the "Post Reply" screen.
another explination is to start your code with an
open bracket+the word CODE+a close bracket
[.code.] ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 9:34 am
We need a bit more info to help you. 🙂
Read this article and re-post.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 9:08 am
Without address a "Why" a direct answer to your question is ...
DECLARE @t TABLE (codeValue VARCHAR(256))
INSERT @t
SELECT '6,16,26,35' UNION ALL
SELECT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 7:53 am
Read up on COALESCE in BOL.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 20, 2008 at 9:55 am
Or you could take advantage of the fact that an IP address just happens to have four parts just like a fully qualified SQL object name and use PARSENAME. 😀
SELECT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 19, 2008 at 2:25 pm
😛
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 19, 2008 at 7:06 am
Not so far!
$#&&@%....! ... Jeff, you just had to bring that up didn't you!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 18, 2008 at 8:11 am
Michael Earl (6/18/2008)
Is this a one-time update, something you intend to do regularly in batch, or something you need to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 18, 2008 at 7:08 am
Matt,
Thanks for the suggestion, but I left out one VERY important point. This needs to work on 2000 as well. I probably should have posted in that forum :hehe:
Anywho, I'm...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 17, 2008 at 1:57 pm
Nice. I'll give it a whirl.
Any more takers out there?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 17, 2008 at 11:00 am
Viewing 15 posts - 451 through 465 (of 1,183 total)