Search results for query: *

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.

Give this a shot. It will place the value in your textbox into the first column in your grid. with myGrid .col = 0 For x = 0 To .Rows .row = x .text = txtBox.Text Next end with If memory serves then this should do the same thing. . . For x = 0 To myGrid.Rows...

try this drop table databaseName.dbo.tableName Matt

SqlSister, I have the following three simple indexes applied to the table . . . pcNum_ind cmNum_ind pcNum_cmNum_ind Would I need to defrag the indexes considering that I'm using a temp table? Thanks Matt

Well I found a solution that doesn't require a cursor. I found the answer on www.sqlTeam.com. The only problem is that this query is very slow. It's actually slower than using the cursor. I'm sure there's gotta be a way to speed this thing up but I've run out of time to mess with it. So, if...

Yes, Top 20 will need to be implemented in the solution but &quot;SELECT TOP 20 * FROM TABLE&quot; will only give me 20 rows. I need 20 rows from each group. Matt