Search results for query: *

Thanks MajP. While the link didn't really answer the question it pointed me in the right direction. My good fortune that you happened to visit this forum rather than Access. Rod Stephens Chapter on LINQ did the rest. Awesome, would never have studied that chapter otherwise, i.e. would have...

I'm trying to mimic DataSet table queries within VB code that are simple as pie in SQL Server. Another words I want to work with the data tables in vb and perform e.g. left joins that can then be used to create a new table within the DataSet that contains only rows from Table A that are not...

I've learned something from each of you. Thanks Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I believe there's a way to select e.g. either all customers from a table or just one customer from a table when given either a customer's unique id (alpha characters) or a null value as the parameter input to a stored procedure. Of course it is possible to just use an IF Else block, but isn't...

Yuck! It's no wonder why MS OS computers run so slow even with the unbelievably fast processors we now have. Why doesn't MS know how to write efficient code? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert...

Hi Victoria, Once again, you've provided excellent help. In your first response you eluded to the possibility of getting inundated with too much detail. My intention is to have the user go directly to the activity I want to analyze, perform it and exit. If that process in itself will...

Thanks Victoria! I guess the next question is where I can expect to find the log file - same directory? Also do I need to change the flag to TRUE for all 3 of these? SQLLogSQLStmt=FALSE SQLLogODBCMessages=FALSE SQLLogAllODBCMessages=FALSE Karl Cursors, triggers, user-defined functions and...

I'm new to Great Plaines. I'm trying to learn what tables are effected when various transactions are performed. I've read from another thread that the dex.ini file can be modified to create a SQL log file. I've also read that version 10.0 may not support this feature. My question is rather...

I really like the idea presented by gmmastros. It makes it easy to create reports that might include only a subset of all stores (with a simple inner join to a temporary Store-Report table). I would tweak his idea by just creating a reporting table in the Corpdb database for the actual...

Is there no concern for the possibility that the date range spans January 1? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Thanks and hi SQLSister. I've never used them, but I put them into the post for completeness. I assume you can't think of any other TSQL that I might have to change, can you? I also don't use triggers, so any compatibility problems there I can ignore. Karl Cursors, triggers, user-defined...

Thank you both. I read the links inside the link and I downloaded a 2008 evaluation. I guess I misread something, but it is a little tricky. Select a as b, c from aTable order by aTable.b That is invalid, but if you remove the aTable. from aTable.b, then it is ok. Select a as b, c from...

I plan to upgrade to SQL Server 2008 from 2000. I’ve read that to run in 2008 mode, you must not use an alias (for a column name) in the Order By or Group By clauses. The use of *= and =* for joins is also verboten along with the keyword “WITH” (except in nolocks). Hmm, does that mean...

Thanks for the link, but it confirms that I need to bid this project out to someone more fluent in .Net than I. Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I think AxImp is for doing just the opposite, i.e. taking an existing ActiveX Control and porting it to .NET. I need to write an ActiveX Control in .NET so that it can print a SQL Server report, but I need to use the ActiveX Control in an existing VB6 application. I'm not very fluent in .NET...

I need to print a SQL Server report (using the report server) from a vb6 application. Does anyone know of example code for creating a vb6 control in .net that could expose the properties and methods to accomplish the printing? Karl Cursors, triggers, user-defined functions and dynamic SQL are...

Does anyone know how to code a call to SSRS from VB6? Is there a .NET wrapper to do it? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Does anyone have example code for calling a 2008 SQL server report (off the server) from VB6? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Can a report be called from a stored procedure? I don't have SSRS, so I have no clue. Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I don't use SSRS, but I'm wondering if the report server can run a report that is called from a stored procedure? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com