Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
77 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 2
Page Size: 10 · 25 · 50

Author filtered by: Richard.Berry100 [x]
Answer 3 May 2013   license: CPOL
Quote:What you describe sounds like a good fitThat's a perfect fit! This could have saved me LOTS of trouble with Dot Net Frameworks etc :)Thanks a Mil
C#VBVB.NET
Answer 3 May 2013   license: CPOL
You can use SMOAdd these references:'//***** Add these references**********'//Microsoft.SqlServer.Smo'//Microsoft.SqlServer.SmoExtended'//Microsoft.SqlServer.Management.Sdk.Sfc'//Microsoft.SqlServer.ConnectionInfoAdd these Imports:Imports...
SQL2005VBSQL-ServerVB.NET
Answer 3 May 2013   license: CPOL
HiRecently done a similar thing (But you don't say if you need a database on each workstation, or if you are using a central Database on a network server.) I installed SSE2008R2 (SQL Server 2008 R2 Express) (Free) on their Server.I used SSMA (Sql Server Migration Assistant for...
VBSQL.NETSQL-ServerVBdatabaseVB.NET
Question 3 May 2013   license: CPOL
HiI have a Win Forms app running on about 15 desktops. Users all have a Desktop shortcut to the myProgram.exe Updates involve going to each station and dropping the new exe on the station. App connects to a SQL server DBWhat I would like to do is put the latest version of the app in a...
C#VBVB.NET
Re: SSE 2008 R2 Backup Strategy by Richard.Berry100
Forum Message 1 May 2013  
GuyThiebaut wrote:I take it there there is one central instance of an SQL Server rather than an instance on each workstation. If there is one central
Re: SSE 2008 R2 Backup Strategy by Richard.Berry100
Forum Message 30 Apr 2013  
GuyThiebaut wrote:I restore the backup to a test system(so yes a duplicate database) then I test a series of .Net apps This should be easy e
Re: SSE 2008 R2 Backup Strategy by Richard.Berry100
Forum Message 30 Apr 2013  
Hi Guy Thanks for your reply. I'm not working for the company, I only developed an app for their stock control. They don't have IT staff on site, and I'm really not sure what sort of backups they
SSE 200R2 Backup Strategy by Richard.Berry100
Forum Message 30 Apr 2013  
Hi I have just changed the db for a small app from using an MS ACCESS db (terrible thing!) to SSE 2008 R2 DB. Previously, they used to just copy the ACCESS db file each evening to a flash drive, and
Re: Conversion failed in sql by Richard.Berry100
Forum Message 24 Apr 2013  
Mycroft, I see original poster did not respond, but really curious - what does J-script convert '12r' to???
Forum Message 24 Apr 2013  
Yip, agreed, see the reply I posted to my own question with speed tests on various approaches, and reference to Eddy's link - Thanks!
Forum Message 22 Apr 2013  
Thanks Eddy, good link!
Forum Message 22 Apr 2013  
Hi Guys - thanks to all for the responses. I think the link Eddy posted puts a lot into perspective, in that closing the connection does not really kill it, it leaves it in the pool, and unless the
Forum Message 19 Apr 2013  
I am using a windows forms application to write data to a SQL 2008 database over a wireless network. (Scanning serial numbers) While stepping through the code in debug mode, the Connection.Open see
Re: JOIN 3 Tables by Richard.Berry100
Forum Message 5 Apr 2013  
Thanks Mycroft - I think I am going to go with your suggestion - re-write. Do you have any pointers you could offer to handle the same stock code in various locations? Should I use an Identity field,
Re: JOIN 3 Tables by Richard.Berry100
Forum Message 5 Apr 2013  
Hi Mycroft Thanks for the Advice - I agree but would have to re-write just about all the code in the app. The app was initially never intended to have multiple locations/warehouses - this requirem
JOIN 3 Tables by Richard.Berry100
Forum Message 4 Apr 2013  
Hi I wonder if you could assist again with another similar query, this time with three tables. I just cant see where I am going wrong. StkQty Join Stk History - WORKS SELECT tStk
Forum Message 4 Apr 2013  
Thanks for your reply David. Not sure if I understood correctly, but kept getting 'syntax error'
Forum Message 4 Apr 2013  
Awesome! Thanks Jörgen SELECT tStk.WH + ' - ' + tStk.StockCode as [WP], sum(tStk.Qty) as [StkTot], IIF(tHst.HstTot is null,0, tHst.HstTot) AS [HstTot], sum(tStk.Qty) - IIF(tHst
Forum Message 1 Apr 2013  
Hi Using Microsoft.ACE.OLEDB.12.0 to access an MS Access 2007 database from a VB.net (2010) project. SELECT tStk.WH + ' - ' + tStk.StockCode as [WP], sum(tStk.Qty) as [StkTot],
Re: certain rows to column by Richard.Berry100
Forum Message 27 Mar 2013  
Thanks Mycroft - will give it a try tonight
certain rows to column by Richard.Berry100
Forum Message 25 Mar 2013  
Hi Using SQL Server 2008 R2. I have a stock table, with the following fields: warehouse, product, long_description, physical_qty. All products exist in warehouse '01'. Some of the products exist
Answer 28 Feb 2013   license: CPOL
This solved the problemPrivate Function GetWhereUsedProduct(ByRef WhComp As String) As String Dim Component As String = WhComp dvBom.Sort = "WhComp" Dim Stk As New Stack Dim FoundRows() As DataRowView Dim result As String Dim stkItem...
VBVB.NET
Re: Dual Primary Key? by Richard.Berry100
Forum Message 21 Feb 2013  
Thanks Eddie, but you have totally lost me? If I lok at the two lines: ADD CONSTRAINT PK_MasterTable Prevents any duplicates in MasterTable column and
Question 21 Feb 2013   license: CPOL
HiI am trying to write a function to return the Top Level assembly(s) that a component is used on.There are two tables involved, BomHeader, which has assembly codes, and BomDetail which has the assembly code repeated for each component code that makes up the assemblyI'm heading in...
VBVB.NET
Dual Primary Key? by Richard.Berry100
Forum Message 21 Feb 2013  
Hi Our ERP system has a stock master table. It consist of the fields 'warehouse', 'product' and a bunch of other fields relating to the stock item. A product can exist in various warehouses, so
Validate a Date Time Picker Input by Richard.Berry100
Question 31 Jan 2013   license: CPOL
HiI have a form with three date picker controls. How can I validate that a user has actually selected a date (even if it is today). The dates will typically fall within range of about a month before to a month after the current date.ThanksR
VBVB.NET
Forum Message 16 Jan 2013  
Thanks PIEBALDconsult The problem was amongst other things the dates !! This works now: SELECT user_id, SUM(CASE WHEN (stkhstm.transaction_type = 'RECP' AND stkhstm.movement_date >= {t
Forum Message 16 Jan 2013  
Oops sorry - SQL Server 2008 R2 - MS Query - Excel Seem to have got a liitle further: This works: SELECT user_id, SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) ,
Totals of each transaction type by Richard.Berry100
Forum Message 15 Jan 2013  
Hi How can I get the total number of two types of transaction between two dates per user Example data: User TransactionType MovementDate Avril RECP 2012/01/04 Pat RECP
Forum Message 25 Oct 2012  
Hello David Thanks very much for the suggestion The full DB was not as large as I though it would be so just used a full backup, took that home and restored it - all perfect! Thanks Richar
Forum Message 18 Oct 2012  
Sorry Mark - Dunno where I got the 'c' from. Using Visual Studio, tried Windows, and SQL authentication??? If I open SQL management studio, I connect using sa with no password, but same does not
Forum Message 18 Oct 2012  
Thank Marc Tried the 'Script Table' .. 'Create To' and this looks good.. I would like the data as well though, when you refer to VS do you mean Visual Studio? I looked at Database Explorer in
Forum Message 18 Oct 2012  
Hi I'd like to copy a couple of tables with all field information (primary keys, constraints etc) from SQL server 2008 at work to a pc at home running same SQL server. I dont have any sort of li
Scan serial Numbers to database by Richard.Berry100
Question 7 Oct 2012   license: CPOL
HiBusy with small app to log serial numbers of TV sets received and despatched.What I have:Windows forms applicationAccess databaseWrapper class for data accessFunction to write serial of unit received to DB (SQL: INSERT INTO .... )Function to despatch a unit. Add a despatched...
VBVB.NET
Question 6 Aug 2012   license: CPOL
HelloI'm busy with a little app for my kiddie to practice math. I'm doing ok with generating some simple add and subtract sums, but the user interface is so not funky or appealing to a kid.Using VS2010, vb.net, Windows Forms Application - I'm not familiar with much else than this - so...
VBVB.NET
Forum Message 28 Jul 2012  
Hi Michael I had wondered about multiple warehouses :) In this particular case the product can exist in other warehouses, however the cost in the others does not need to be the same - only war
Forum Message 26 Jul 2012  
Thanks David I had to add warehouse in the two select statements for warehouse '01' and warehouse '02' since they were referred to in the outer SELECT as below and now it works. SELEC
Forum Message 26 Jul 2012  
Hi I need to run a query on a stock table. Each product may exist in either one or many warehouses. I am trying to find all items where the cost of the product is not the same in warehouse 01 and 0
Re: SQL Get Max for each group by Richard.Berry100
Forum Message 21 Apr 2012  
Thanks so much Jorgen! That worked brilliantly. I did have to remove: ORDER BY scheme_opdetm.product, scheme_opheadm.date_despatched DESC; becaue it gave an error (MSSQL
Re: SQL Get Max for each group by Richard.Berry100
Forum Message 20 Apr 2012  
Thanks Mycroft, but I have no idea how to do this. First, I'm not sure how to put in the PARTITION clause, Second, the Despatch date is in the header table (opheadm), with a Sales Order Num, but
SQL Get Max for each group by Richard.Berry100
Forum Message 20 Apr 2012  
Hi I posted a similar question to this here [^] however after
Re: SQL Top n By Group by Richard.Berry100
Forum Message 12 Apr 2012  
Also at work, but on my way home, will test when I get home - and yes, using 2008
Re: SQL Top n By Group by Richard.Berry100
Forum Message 12 Apr 2012  
Hi djj55 I tested the query and it did not return what I was expecting. It only returned three rows. I need the last three orders for every stock code. Maybe I need to SELECT DISTINC
SQL Top n By Group by Richard.Berry100
Forum Message 11 Apr 2012  
I am trying to retrieve the product, price, and date_despatched for the last three orders (date_despatched) for each product. There are two tables involved: opheadm (Sales Order He
Answer 8 Apr 2012   license: CPOL
I dont want to detract from VJ Reddy's solution, but if the DataGridview is not bound to a datasource, and are you adding the data programatically you can try writing an integer data type (or other numeric data type) to the DataGridview cells. Then it also sorts correctly.
VBVB.NET
Forum Message 6 Apr 2012  
I'm trying to import an Access 2007 db using the SQl Sever Migration Assistant into a SQL Sever 2008 Express database. All the steps work fine in the migration assistant, and in the pane on the lower
Forum Message 6 Apr 2012  
Thanks PIEBALDconsult The SELECT query should return only one row based on conditions in the WHERE clause, but I was wondering if there was a way to eliminate declaring a DataTable, and then equat
Forum Message 6 Apr 2012  
Is there a better way to get one row from a database. I have been using the Fill Method of the DataAdapter to fill a datatable, and then returning the first row of the table Dim dr
Forum Message 6 Apr 2012  
Thanks for all the advice Eddy. If the app works properly, I'm sure they wouldn't mind investing in a mid range pc - and I guess the performance would be a bit better than with Access db as well.
Forum Message 6 Apr 2012  
Thanks - will consider installing on same server, but I'd get someone who knows a bit more about servers to assist! I was leaning towards them getting another PC on the network and put and instance
Page 1 of 2
1 2
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid