Viewing 15 posts - 1 through 15 (of 19 total)
January 22, 2004 at 6:07 am
forgot it. bad data in data file. sorry
</cm>
</cm>
August 14, 2003 at 12:54 pm
Thanks for the quick reply. I also go this to work
Cast(CSI.CSICode as char(10)) + ' ' + CSI.CSIName
</cm>
May 14, 2003 at 6:36 am
FOrget it. I was caught a stupid mistake on my end. Thanks again.
</cm>
January 7, 2003 at 6:27 am
Thanks for the replies. COALESCE('%' + @FirstName + '%',Contacts.FirstName) I am simply trying to add a a wildcard filter on to the parameter but it does not seem to work...
</cm>
January 7, 2003 at 6:20 am
I usually do strip out with script, but this is for multiple dts jobs that generate txt files. we have html in the description so i guess i could just...
</cm>
December 5, 2002 at 2:08 pm
Thanks for all the replies. However the data is coming from an extract and parsing the data into 2 columns is not feasible. Is there a standard function for...
</cm>
September 19, 2002 at 4:36 am
I feel like an idoit. Someone else created this table and i never thought to look at the data types. no wonder the query wasnt working. sorry to bother. thanks
</cm>
August 12, 2002 at 8:59 am
works beautifully. thanks for the always quick responses. this is the best community.
</cm>
July 16, 2002 at 8:49 am
i realize that thE product table is not normalized but we are restricted at the moment to importing daily from an image dB through DTS. we basically have to parse...
</cm>
July 16, 2002 at 7:23 am
yes. thank you for your patience and help.
not sure what i would do without this site.
-cm
</cm>
July 3, 2002 at 5:27 am
basically i need to take a given shortsku, look it up in tblproduct, from there get the edp and join that to tblkit and from there get the componentedp(s). i...
</cm>
July 2, 2002 at 3:17 pm
Thanks,
table a is a product table that is maintained in our legacy system and then imported into sql. any of the data could be modified. i definitely will need...
</cm>
May 20, 2002 at 10:16 am
Viewing 15 posts - 1 through 15 (of 19 total)