Search results for query: *

Our company currently provides several software systems that utilize SQL Server as a back end. Up to this point in time, our data structure has been stored in one huge table with generic field names (Field001, Field002, ect.). There is no way to make our software work with more fields...

I've got a report that is grouping on the first left character of a field. I've got a "New Page Before" on my group header. Each time the next group starts on an even page, I want to skip another page and so the beggining of each group is printing on an odd page. I've tried putting a formula...

I'm trying to duplex 11X14 paper on a Savin MLP32, and the printer is just printing the even pages. Any idea on how to make printers duplex custom paper sizes?

Hopefully this is just a stupid problem with a simple answer. I am trying to use a Crystal report to print 11X17 duplexed paper that will go into books. On the left edge of the page, (binding edge), I need about a .8in margin for the binding. The problem is, when I print with a .8in margin on...

Grrr....Apparantly SQL doesn't like the idea of using aggregate's in an update statement. I'm using the following select statement to select a count of children records, and link them to parent records. Problem is, when I try to run an update off of this statement, SQL politly informs me that...

I'm trying to so something with SQL that I can't quite get a handle on. I have a program that is supposed to be able to handle batch scanning. When it scans multiple pages, it links them all to one record that may be defined in scripting code, but it doesn't support linking each individual...

I know this sounds like a dumb question, and I am currently looking through the SQL Books Online, but I figured somebody out there might have a quick answer for me...

Is there a way to select the property of a table, and have Query Anylyzer return a list of columns that exist in the table?

I'm completly new to foxpro, and I am doing something that requires me to create a script that converts a bunch of Foxpro databases into SQL tables. I thought it'd be nice to have something that would return the fields in a paticular database, or all the databases in a directory. That way I...

I've got some fields that have more data than I want to print sometimes. I need to either find a way to make Crystal stop printing half of a letter when the field is to long, or select a left portion of the string. My problem is that selecting the left twenty five characters of a field may be...

I'm creating a report for some indexes, and I want to group for every left character of a field, except for numerics, in which case I want everything together. Whay I currently have is this -------------------------------- left({nstemp.name1},1) -------------------------------- And I want to...

I need to add a two inch margin every other page. Is there a way to attach a formula to a margin?

I'm having trouble using a user defined variable to tell a select statement inside my proc what database it is supposed to be selecting from. Here is the code. ----------------------------------------------------------- alter PROCEDURE moveimg (@olddb char(12), @newdb char(12)) as...

When the following is typed in, I get these results... select right(('0000'+pageorder),3) from neworder 4 5 6 7 8 9 10 11 12 13 ect... I know this is something stupid and dumb, but I'm too tired to figure it out....

Is there a way to make a DTS package append a CSV file rather than overwrite it? I've been searching the documentation, and have come up empty handed thus far.....

How can I do this? declare @database varchar(20) set @database='img000029' select * from @database.dbo.imgs

Einstien's definition of insane was "Doing the same thing twice, and expecting different results" declare @indextyp char(5) declare @IL char(5) set @indextyp='D' set @IL='A' select names.key1 as name1, case when @indextyp='D' then inst.a19 else inst.a18 end as name2, inst.b15...

How can I say "select animal from database1.eatenanimals where database2.whatateit='dog' and database2link=database1id.

How can I do this, or can I? Update table set column1 = ' 'hi' '

Can somebody tell me how to zero fill these? It reads this... c1 LAN2496 139 LAN2496 14 LAN2496 141 LAN2496 142 LAN2496 143 LAN2496 144 LAN2496 145 LAN2496 146 LAN2496 147 LAN254 12 And it wann read this... c1 LAN002496 0139 LAN002496 0014 LAN002496 0141 LAN002496 0142 LAN002496 0143...