Viewing 15 posts - 1 through 15 (of 16 total)
How about this?
April 27, 2011 at 7:14 am
Thanks for the help understanding table-valued-functions and APPLY. It is all clear to me now.
Yesterday, after you told me about the tvf, I created one with a parm as it...
April 13, 2011 at 9:28 am
Got it. I was forgetting the fact that I am able to pass a parm to the function, whereas that is not available when joining to a table.
In my first...
April 13, 2011 at 8:44 am
I do have a question about how the APPLY works. I have looked at some other sites but still don't quite understand how it joins the rows from the function...
April 13, 2011 at 8:01 am
Thanks Lowell. I had never used a table valued function or APPLY. This makes sense and is a perfect fit for another project of mine.
April 13, 2011 at 7:26 am
That is way too simple. It formats it much better than simply looking in the system table, but it still doesn't format it the same way as when I...
September 4, 2009 at 2:14 pm
Thanks for your reply. I thought I deleted this post as I realized I should have posted it in SS2005.
I was told to use COALESCE and it worked for me.
July 21, 2009 at 10:35 am
Now I understand. Thanks for the help... and the lesson. mpv
July 21, 2009 at 10:25 am
That worked. Thanks. I have seen COALESCE before, but don't fully understand it. Is it like an OR condition where it uses the first value in the...
July 21, 2009 at 10:13 am
I am trying to compare two columns to find the ones that are different.
If I use the following, I only get item4. I would expect to get item2, item3...
July 21, 2009 at 9:37 am
The View works. My only concern is that two of my tables are in one DB and the third is in a different DB. Are there problems creating...
July 7, 2009 at 11:51 am
I don't see what you did, other than adding code to create the tables with data. I assume you are implying that I need to do this whenever I post...
July 7, 2009 at 9:05 am
I can't use a join. The utility I am calling expects one table name to be passed in the from parameter, and all the logic needs to be included in...
July 7, 2009 at 7:38 am
There are a number of batch file compilers you could use to turn the batch file into an .exe file. This is an effective way of keeping users out...
June 5, 2009 at 7:19 am
I'm sorry, but he doesn't deliver on his promise to "... execute the job easily with a single click." As you will notice at the end of the article...
June 5, 2009 at 6:19 am