Viewing 15 posts - 16 through 30 (of 61 total)
Hi,
I need to evaluate each account number in the while loop and not just have a counter. My question is how do I evaluate each account. This is what I...
August 8, 2006 at 8:17 am
Reet,
My mistake, I thought you were stuck on syntax.
Not a problem, As Ryan mentioned by using the ISNULL function you can accomplished what you're asking for.
Avoid dynamic SQL whenever...
July 26, 2006 at 9:16 am
For the simple reason that's they way the ERP system stores the data, We're in the process of building a conformity process and set standards for this data.
Technically you're...
July 26, 2006 at 8:03 am
Reet,
Is this a syntax issue? This is a skeleton sproc for dynamic SQL I've been using for awhile:
I rule of thumb that I follow is that when I have many...
July 26, 2006 at 7:07 am
If you're using the date for display this is how I accomplished that:
CONVERT(DATETIME,SUBSTRING(b.duedate,5,2)+ '-' + SUBSTRING(b.duedate,7,2) + '-' + SUBSTRING(b.duedate,1,4),101) + 30 AS duedate,
duedate in my case is a varchar(8). ...
July 26, 2006 at 6:52 am
The above code will work if you're in the situation you have outline. However my data situation is that I have twelve columns of data not 12 rows.
This is what...
July 26, 2006 at 5:59 am
The issue with this customer number is that in some cases the entire customer number is alpha for example, in some cases the user has entered say MICROSFT as a...
July 25, 2006 at 1:07 pm
I changed the range method and decided to use the IN function instead this worked out better. As I mentioned before this customer number is a varchar because it contains...
July 25, 2006 at 5:55 am
I've been here for the past two years and have used SP4 and this started when backups started running for 12 hours. I'm still not sure if this has anything...
July 12, 2006 at 7:27 am
Thanks everyone for responding. This has helped greatly.
July 5, 2006 at 6:09 am
I do have error handling and track logs, however what I'm trying to accomplish is documenting the physical DTS package, the different steps associated within the DTS package. For Application...
June 30, 2006 at 11:50 am
I did a test and ran the schedule jobs at a time where I could see if they are running and if they are loading data. This test passed. The...
May 3, 2006 at 1:00 pm
The way I usually accomplish Matrix type tables or X-Tabs is I usually have a sproc creating this via a DTS package. Now you have a X-TAB table. For the...
April 25, 2006 at 2:11 pm
The quickest way is in query analyzer set the output to text and then hit CTRL - A (to select all) - CTRL C. Next open Excel and paste into...
April 25, 2006 at 2:04 pm
Viewing 15 posts - 16 through 30 (of 61 total)