Search results for query: *

Hello, I'm not new to SQL Server, but definitely new to VB.NET and need assistance populating a DataGrid. I've constructed an app with a connection string and all works fine. I know this by purposely passing the same code I would using Query Analyzer to my app and having no errors, but...

I'm trying to write a trigger to insert TblB from TblA, but not if that record already exists in TblB. Each table has a different structure, but with some identical columns (those I'm looking to insert) having same datatypes. IDNum is an IDENTITY Column. It won't fire unless its a straight...

I've been trying to export a table with Carriage Return Line Feeds to output in Label Format. I tried adding the numeric equivalent of a CR LF, but won't alter data. It simply exports the file as usual. Data needs to appear like so to run on our inkjet machines in the production dept...

How can I update tbl1 from tbl2 (both having the exact same structure) all in one step? I can do it a column at a time, but can't quite seem to nail it down all at once. IDNum, Company, Contact, Addr2, Addr1, City, State, Zip, Zip4 on both with same datatypes. David

Hello all, My manager is stuck on Dbase III plus. That being said. . .Does anyone know what the command is? I'm exporting from SQL Server as dbase III, but it will not open using dbase. I can, however, open it with VFP? I'd appreciate your input. David

Anyone have an idea why every Tbl within every DB with an INT datatype is being displayed as if were numeric? This has only been within the last couple of days. It still functions as it should. I would love to eliminate the trailing zeros. Thanks, David

Hello, I've written an SP which conducts an analysis for each Bulk Mail Center (BMC). This lets us know which project provides postage savings based on total by drop shipment destination(BMC). It currently works well. However, I need assistance figuring out how to include a single input...

Hello, I need some assistance with my IF Statement. Mostly familar with ANSI IFs. I understand SQL Server syntax is a bit different, but have little experience with it. This should be very simple for one of you. My sample: SELECT * FROM TBL1 IF PMTHD = 'BOFA-VISA' BEGIN...

Good Morning, I'm trying to save time, hopefully cutting down the usual 5-8 hours of editing in VFP, using a CASE statement to edit obscenly long columns for Piggy-Back label purposes. My reasoning is we are limited between 30-35 characters. I've tried this SQL but it's obviously changing all...

Hello, I need help flushing data to the right of a column Char(100). I've tried something like this: update tbl02 set BusAddr = ' '+RTRIM(BusAddr); Data does move to the right some, but I receive a termination error, since some data would be truncated. This is problematic since length...

Hello All, I'd like to take a table provided by a customer that has four columns provided as one like so: Business_Addr 1123 Main st Los Angeles CA 90057 and split them out into different columns: Addr1 City State Zip 1123 Main St Los Angeles CA 90057 Not sure...

Hello, I'm looking to create a program to convert from lower to uppercase for all fields. I'm using some knowledge obtained in SQL to create this, and that is obviously why I need help. It compiles properly, not sure if everything would compile regardless of whether it works or not. Here it...

I installed standalone version 4.0, I even purchased "MySQL Tutorial," and followed all the instructions(Tweak the my.ini file, etc). Everything works just fine for a few days, I shut down the server properly, and then that next morning-nothing. I've consulted the manual and nothing helps...

Hi all, This is surely a newbie question. I've loaded SQL Server7 from Office 2000 Pro and come to a halt after launching server and osql. I'm prompted for a password, which I provide, but I see this: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server...