Search results for query: *

It is an off site db with SELECT only permissions. I cannot create/drop tables there. RyanEK. when selecting top 1, I will always get 1st previous records which means when Seq is 400 or 300 or any other value, top 1 will always return lowest Seq which is 1, which means that Previous row for seq...

This will not work because "TOP 1" will return the same Dept regardless of the seq.(i.e. Seq of 500 or seq of 400 will yeild the same result) Thanks, Kirill

My appology, I have a seq column that seem to increment as new step is added. Order Department Seq 1 Dept01 100 1 Dept02 150 1 Dept02 150 1 Dept03 200 1 Dept02 250 1 Dept04 300 1 Dept05 350 1 Dept06 400

I forgot to mention I am using SQL2000 thus no PIVOT UNPIVOT, however union all will do, I only have 18 columns

I have a table with 2 columns called Department and Order Num, Order Department 1 Dept01 1 Dept02 1 Dept03 1 Dept04 1 Dept05 I need to have a new table with prev dept in the thrord column like Order Department Prev.Dept 1 Dept01 START 1 Dept02...

Hi I have a Table that defines progression of document. Here is the table1; Name Dep1 Dep2 Dep3 Dep4 Route1 Acct Admin Sales Invoice Route2 Acctg HR Sales Invoice etc. Then I have another table2 Route CurrDept other columns Route1 Accounting etc What I need...

he wants it from sub to mail, link works the other way from main to sub. Did I read it incorrectly :)

you need to declare a gloabal variable in your subreport then assign value to it in your sub and then call it your main report. 1. Go to your subreport, and create new formula filed and type: global numbervar x; //This will declare variable x:= {Table.Value} // assigns value to your variable...

Hi, I have a report where I put a picture object in details section and its Graphic Location.property changed at run time. Report looks fine when previewed on the screen, however when printed only random picture shows up. All picture files in WMF format created in AutoCAD. Any Ideas ?

Hi, I have a report with some sub-reports in it. I am trying to controll page alignment in the sub depending on the result sent in the main report. Is there a way tyo control portraitvs landscape page orientation ? Thanks

I have the following xml file, I am trying to get a LINQ to have Filename and Manifest # in one collection. I have made 2 queries that work fine (see bewlow), but how do I make one query for this messed up XML. Thanks for any help Dim file As XElement =...

I dont understand why my sebquery duplicates rows now. Any help would be appretiated !!! SELECT MIN(CAST(foy.SOItemDept.SONum AS varchar(12)) + '-' + CAST(foy.SOItemDept.SOItemNum AS varchar(12))) AS SOFul, MIN(foy.SOItemDept.SONum) AS SoNum...

I have two perfectly working views and I need to join them but dont know how. Here is statement #1 SELECT CAST(foy.SOChangeLog.SONum AS varchar(12)) + '-' + (CASE WHEN SUBSTRING(TheChange, 8, 1) = ':' THEN CAST(SUBSTRING(TheChange, 6, 2) AS varchar(12)) ELSE...

Hi, How can I show only nth page of a muly page document. So far if I just inser a PDF file it shows only 1st page. Any heplp would be appreciated. Thanks

Hi, I'd like to know if some knows how to have a variable name of a variable. For example I have an array that collects somethig about a customer but I dont know exactly which customer yet, thus I would like to define this artray after customer number. so I am looking for something like this...

I am just using a Freefont that they provided, I do not have the IDAutomation Formula. So what I need the field to default to IDAutomationHC39M font when I am using custom function. How Do I do it ?

Hi, I've made myself a little function that helps me barcode things. The only problem is that the result of the function need to appear in IDAutomationHC39M font. Is there a way to code the font into this function. Thanks Function (stringVar ToBarcode) "*"&ToBarCode&"*"

Labour relations would love it :)

I wish I could trust my users to do that.

thanks for your comment