Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS between 2 sql tables
We are trying to import data from one database to another. The schemas are not the same. We need to use existed schema in the destination. We are unable to create the transformations between the source databases and the destination. What exactly are the steps in the DTS wizard to use two...- jemahoney
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Report Distribution
On Crystal 8.0 I am trying to distribute reports to users that alrady have other distributed reports. I am using the old report distribution expert. So the only thing I did was use the Compile Report routine and copy the report.exe and the report.ctf to the distributed reports subdirectory. When...- jemahoney
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Pervasive SQL syntax
Snytax is very straightforward. Here is one written for Scalable SQL, a slightly older version of Pervasive.sql Create Proc K_test @parm1 as Select * from Batch where Status = 'K' and batch.editscrnnbr = @parm1;- jemahoney
- Post #2
- Forum: Pervasive: Pervasive.SQL
-
Is there a bug in the max function
I am using the TSQL select statement: SELECT RATE_TABLE_ID,"PROJECT" = RATE_KEY_VALUE1,"CODE" = RATE_KEY_VALUE2, "EFFECT_DATE" = MAX(EFFECT_DATE),RATE,"CODE_VALUE_DESC" = ISNULL(PJCODE.CODE_VALUE_DESC,"")FROM PJRATE LEFT OUTER JOIN PJCODE ON...- jemahoney
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
