Recent content by MatthewPeters

Well that was easy enough. Star for you gecko!

This is more of a procomm plus question but hopefully someone will be able to help me out. I would like to send a command from a Procomm Plus Meta key that fires the F4 key or any of the function keys. I've figure out how to write an Aspect script that fires the Function keys and then...

try something like . . . select field1, field2, field3 from DataBaseName.dbo.TableName that should work for you

To rename: EXEC sp_rename 'customers', 'custs' to Delete: drop tableName

WHERE (ID = @ID) AND (OrderID >=1 and OrderID <= 5)

I was having this exact same problem in just trying to create a word document and converting it to an HTML on our Intranet. After taking both approaches that it mentioned I was still getting the same error, so I took my approach to solving the problem.[thumbsup2] What I did was the following...

Here is a cross tab query example from BOL. This is the SELECT statement used to create the rotated results: SELECT Year, SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1, SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2, SUM(CASE Quarter WHEN 3 THEN Amount ELSE 0 END)...

What about this one? SELECT Dateinterval, Label, Startdate, Enddate FROM Intervals where DATEPART(month, dateadd(m, -1, GETDATE())) = DATEPART(month, endDate) Matt

Would something like this work? select Dateinterval, Label, Startdate, Enddate from Intervals where DATEPART(month, GETDATE()) = DATEPART(month, endDate) Matt

bartsimpson Looking up the following two commands in BOL may or may not be of interest to you. set arithignore set arithabort matt

Not sure exactly what your after here. If you could provide your table structure (with sample data) and your expected outcome then I'm sure someone here can help you.

Would this work? select Employee, ItemDate, Start, Stop, WeekEnd, #Hours from yourTableName where itemDate = weekend matt

Thanks for the reply. We've tried contacting Tek-Tips management for a couple of weeks now with no response. It's kind of weird because there's one guy here that has been logging into Tek-Tips for over a year and now he can't log in either. But, my account works fine. We'll shoot them...

Hello all, I'm not sure if this is the right forum to be asking this but this questions is just on the maintenance side of tek-tips.com . I have some co-workers here that are trying to create a new user here on the site and they are having a problem with their registration. Not sure if the...

Your FK should be the same data type of the PK that it is related to. The identity property for your FK should be set to NO. The identity property is similiar to the Auto-Number functionality in Access. As new records are inserted the value of the identity field will be filled automatically.