Search results for query: *

Hi: This is the SQL data table I am using for my report with a couple of sample rows. Document Field Name FieldValue (memo) Salesorder Salesman 1 Check Salesman 24 Many different document types, many field names, many identifiers. The...

Any ideas on how to proceed? SQL Express does not have the Utility Explorer and uninstall/remove programs is no more. Thanks in advance.

Using Excel 2007 and a fairly straightforward query which pulls data from ODBC. I have edited the query to add a new field but regardless of where I put it, I don't get a new column on the worksheet with the new values. If I use the query editor, it does show data but this is an already heavily...

Using Excel 2007 and a fairly straightforward query which pulls data from ODBC. I have edited the query to add a new field but regardless of where I put it, I don't get a new column on the worksheet with the new values. If I use the query editor, it does show data but this is an already...

I need a single query to produce output on two lines. The output needs to be copied into Excel with headers. I tried inserting char(13) and char(10) but that does not make the output break. Any help is appreciated. Thanks

Have poked around the various postings on this subject but haven't found the solution yet. I am designing a report for a client and have loaded the identical printer driver (HP5500) which does not have a paper size setting of 11x17 or a Custom paper size option for that matter. On their end...

Hi: I have a spreadsheet that has multiple rows with multiple columns. I need to create a text output that has a row for each column: From: Col 1 Col 2 Col 3 Row 1 Row1,Col1 Row1,Col2 Row3,Col3 Row 2 Row2,Col1 Row2,Col2 Row3,Col3 To: Row1,Col1...

I need a datetime formula in the following format: YYYYMMDDHHMSS-ZZZZ where ZZZZ is the GMT time zone offset. Any help would be appreciated. Thanks

Hi: I have a report which produces data for an upload that lists check and invoice detail. The header for the report requires the number of checks. I need a two pass report and a formula which calculates the number of checks whilereadingrecords and can be used in the report header. Did this...

Hi: I have a simple stored procedure that takes a begin and end date as parameters and builds a table of values. Both paramenters are smalldatetime types. There are two dates in the query that are compared to those and both are also smalldatetime. When I put the stored procedure into SSRS and...

Hi: I am using the 2008 Management Studio. Any Save operation which involves a Browse makes SQL hang and then *eventually* it can browse. I can save fine into the default My Documents folder. I didn't have this problem a week ago. I am firewall protected and virus protected like you read about...

Hi: I have no problem generating a SQL2008 query with results in XML. What I don't know how to do is how to get it to create a file on disk so that I can import into an unrelated application in it's UI. Any help is appreciated. Thanks

I am calling a DOS batch file with the shell command. So far not much luck with using objprocess.startinfo.arguments=" /c " & [batchfile string] (It doesn't run). So for the moment pursuing this with the shell command. My issue is that when I execute the batchfile and append >c: foo.txt...

Hi: I need to create a stored procedure in one database that depending on the passed parameter, pulls either a value from that database or a second database. To boil it down, the code of the table population looks like this so far: INSERT #TEMP (mydescription) select mydescription from...

Hi: Is there any way to prompt the user for a value and generate a USE statement based on what they enter? I have a VB app that takes a product number from the user and based on a part of the product number needs to make a choice of two different databases from where to pull data. So if the...

I have a combo box linked to a sql table via ODBC. When the SQL users add more values, I would like the Access user to be able to force a re-read of the table so that the combo box is up to date. This is a switchboard-driven app so the user will not have access to the linked table manager and...

Hi: I am using Access 2007 to accomplish (what I thought was) a simple 4 step task: give the user a linked list of values and prompt the user to select one. Use that value in a DOS batch file as part of a switch. Ask the user to confirm. Report completion of batch file. In other works, user...

Hi: I need to create a simple query whose output is XML. It needs to print invoices with amounts for each customer but also needs to pass the total invoice amount for each customer. (I am using InfoPath to create the XSL which is then used by an end-user product which apparently does not...

Is there an 'express' version for Microsoft Reporting Service downloadable from Microsoft or do I have to buy the developer version of the whole package? If there is, any tips on finding it? Microsoft has not made it easy - there is a page for Visual Studio 2008 for Express but no Reporting...

Hi: I have two tables I am trying to join. The first (call it the 'parent' table) has fields with variable length identifiers, call them abcfoo, def for instance. The second table (call it the 'child' table) has identifiers like abcfoo|123, abcfoo|345, abcfoo|456, def|123, def|246. I would...