Viewing 15 posts - 1,831 through 1,845 (of 4,080 total)
I see your difficulty. Maybe a simple SSIS package?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 9:24 pm
Jeff you were posting while I was funckifying.... 😛
Congrats on the 20k. They should create a Golden Pork Chop award and pass it on to future recipients...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 9:09 pm
If you're going to run this against sets of rows, consider writing it as an inline table-valued funcation.
CREATE FUNCTION dbo.tfn_DotSplitFuncation
(
@OutlineNumber VARCHAR(1000)
)
RETURNS TABLE
AS
RETURN
(
with cte (outlineNumber) as (select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 9:08 pm
When I select "Results to File" in 2008, I receive the following message, just as if I had selected "Results to Text" or "Results to Grid". I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 8:29 pm
When the company I work for was still in the start up phase, several of us used to take LONG walks while discussing issues at work. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 1:08 pm
Hope all goes well, Barry. You'll be in our thoughts and prayers.
Congratulations Jeff, and Paul... and Jason.... and everyone else deserving of congratulations.
I am 600...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 7:34 am
I hadn't realized you were going to tables with a different structure. I don't think you are going to get away from having cross reference tables, but...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2010 at 7:27 am
Please post the schema you have created so far. It is far easier for the volunteers trying to help you to deal with specific code than with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2010 at 7:40 am
This sounds like yet another attempt to make a relational database into some sort of object-oriented framework. (Good luck with that, but be advised that you're not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2010 at 6:47 am
You beat me to it, Lutz.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2010 at 1:49 pm
According to BOL, both REAL and FLOAT are:
Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2010 at 1:46 pm
Thanks to you both for posting your sources. It's always much better to see a cite something than to rely on "I heard that... " statements....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 1, 2010 at 9:24 am
Keith,
To handle concatenation of nulls, you need use either the ISNULL() or COALESCE() function. One hint, it is sometimes best to test whether or not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 1, 2010 at 6:55 am
David, do you have any source authority that UPDATE is going to be deprecated or is that just a personal opinion? Despite your characterization of it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 1, 2010 at 6:42 am
Dobe,
The message is telling you that the length of the expression '-Grid ' + b.comp_ + '- ' + Comments2 is longer than the length of ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 28, 2010 at 10:09 am
Viewing 15 posts - 1,831 through 1,845 (of 4,080 total)