Search results for query: *

Brian Perry from the SQL server forum came up with this Sql stmt to return the data you wish. Typically, I create a view to bring the info back and point crystal to the view. Select pn+Rev as pn from ( Select left(p2.pn,8) as pn ,Max(right(p2.pn,1))as Rev From fd_pn p2 Group by left(p2.pn,8) )...

Thanks Brian, You made it so simple. One question please. What does the 'AS dt' do?? Thanks MikeD Mike Davis MSsql, VB and Crystal Reports Developer

A fellow on the CR forum has the following problem: snip.. Part numbers have a revision letter as follows: 123A-234A 123A-234B 123A-234C I want to show this one only I posted this SQL statement which works but returns two columns. How can I rejoin the columns?? This puzles me Thanks MikeD...

DocTec, This sql stmt returns the distinct information you are seeking, altho in two columns. Select left(p2.pn,8) as pn, Max(right(p2.pn,1))as rev From fd_pn p2 Group by left(p2.pn,8) in CR you could join them. I tried to getit to come back together as one column, but no success. I'm...

What is the general consensus using controls. Do you bind them or write the read and write procs. I'm talking 50k records and up. Last century we would never use a bound control. Have things improved, can you cancel an edit in the new ado controls? Are you creating one connection and using...

Thanks to all, the problem was the Server=(local) connectstring="Driver={SQL Server};" & _ "Server=(local);" & _ "Database=BasePkg;" & _ "Trusted connection=Yes" Is there an updated or better driver to use than...

Using your suggestion, I get the error: Provider not found or installed properly" Am I typing it properly? "Provider=SQLEDB.1" Thanks MikeD Mike Davis MSsql, VB and Crystal Reports Developer

I have tried to connect to my local server buts but can't wihout setting the prompt to ALWAYS. Anybody have a clue? The code is right out of MS BOL. Here is my code m_ConnectionString= "driver={SQL Server};server=MDHOME;database=BasePkg;Data Source=Select * from...

Rick and Terry, I have reinstalled the BOL from the CD.(3 times) I have copied the SQL*.* from work and still no luck. Even tried running hh.exe path\sql80.col and I get the same error that it can't open the file. I going for the BOL standalone. Thanks to all. MikeD Mike Davis MSsql, VB and...

Hi Terry, I checked and no such file. Mike Mike Davis MSsql, VB and Crystal Reports Developer

When I Click on the BOL in SQL 2000 programg group, I get the error message that it cant open SQL80.col. I'm using the developer edition on my home pc/server. I copied everything in the books folder on the cd to my installed Books folder but still the same error. SQL80.col is not on the...

MikeB You were correct on [Page N of M] being set in the group, The Group footer wasn't set properly. Thanks again, MikeD Mike Davis MSsql, VB and Crystal Reports Developer

These individual Queries return the proper totals. But I need a query or view that returns LogDate,LogTime So that the Date is my column and Time is my row and I summarize on Count of Date. Select StaffName,Count(LogDate) as Count From Tab1 Where Tab1.LogType=1 Group by StaffName Select...

Yes, they have a PrimaryKey-ForeignKey Relation. Tab2.FK=Tab1.PK Mike Davis MSsql, VB and Crystal Reports Developer

Hi, I have a parent/child pair of tables that I need a count of both instances. The parent Contact Log has these fields LogDate,LogTime,LogType The child table has followup Calls to the parent. LogDate,LogTime. I need to count the instances of calls by Date and Time Of inital calls and...

Age old battle you are talking about. The best of both worlds has the client loading the dictionary/constraints from the server and then doing the checking client side where exceptions are handled more easily. This assumes that a thick client is ok. If an application if supposed to provide...

Age old battle you are talking about. The best of both worlds has the client loading the dictionary/constraints from the server and then doing the checking client side where exceptions are handled more easily. This assumes that a thick client is ok. If an application if supposed to provide...

Terry, Thank You. I have been all around the solution but couldn't score. I couldn't believe an eloquent solution was so hard to come by. Thanks Again, Mike Davis Going back to the drawing board on self joins and filters. Mike Davis MSsql, VB and Crystal Reports Developer

Can you look at the SQL Query to get an Idea of what is really happening? Run your report that shows the wrong record. From the menu, DataBase, Show SQL Query. Copy and paste this to notepad so you can really debug it if it is really lengthy. Posibly CR is making the wrong join out of your...

Chiara, You can create a stored procedure and/or a view that is stored on one server. Point CR to the View. Design the whole report around the view. CR and your users won't know that it is comming off several servers. hth Mike Mike Davis MSsql, VB and Crystal Reports Developer