Viewing 15 posts - 21,841 through 21,855 (of 26,484 total)
Also, looking at your initial post, you only provided the DDL for two of the tables in the query. Really could use the DDL for the other two tables....
March 23, 2009 at 11:37 am
First question, does the following query return the correct result set that you are deleting items based on?
SELECT distinct
Application.ApplicationID,
ApplicationProduct.ProductControlID
FROM
...
March 23, 2009 at 11:34 am
The only "table" that is being created is a table variable. You should be fine using this script.
March 23, 2009 at 11:19 am
If you have the cursor based code for doing this, it would help if you posted that as well. It will answer questions that will make rewriting in a...
March 23, 2009 at 10:41 am
kevin.l.williams (3/23/2009)
"Since col2 is used in the WHERE clause, the output does not include the...
March 23, 2009 at 10:12 am
I should mention that I also got to meet Steve Jones last week at the Colorado Springs SQL Server Users Group meeting. He was down doing a presentation. ...
March 23, 2009 at 10:01 am
mtassin (3/23/2009)
r.hensbergen (3/23/2009)
March 23, 2009 at 9:49 am
You can use an Execute Package Task to execute another package, but I'm not sure about calling a specific task within another package.
March 23, 2009 at 9:18 am
I do agree with you Gus, I think that is why The Thread is probably still alive. This one has been very entertaining and has allowed many of us...
March 23, 2009 at 7:24 am
Bob Hovious (3/22/2009)
I just kidded Lynn about chastising someone for hijacking "the rant", because it had already been briefly hijacked by a discussion of incrementing next...
March 22, 2009 at 9:51 pm
I just think a discussion of Dataphor should be separate and distinct from this rant which did start as a discussion regarding the shortcomings of T-SQL, but really were more...
March 22, 2009 at 9:49 pm
Bob Hovious (3/22/2009)
Don't hijack it like you guys did with the "increment" discussion, Lynn? 😉
I agree. In fact I think I may have even said that it too...
March 22, 2009 at 9:42 pm
steve dassin (3/22/2009)
Steve Jones - Editor (3/15/2009)
...C#, VB, etc. are programming languages designed for working with a variables, of sets of variables in objects.
How do you realize a result of...
March 22, 2009 at 8:56 pm
We also need the proper "business" scenario. Could be something based on our past experience or something similiar. I guess we should come up with some ideas.
March 21, 2009 at 9:18 pm
Jeff Moden (3/21/2009)
March 21, 2009 at 4:05 pm
Viewing 15 posts - 21,841 through 21,855 (of 26,484 total)