Topics
Started by
Posts
Last post
Scenario: A student can take a particular test (reading, in this case) 5 times before graduating. …
4 replies
rsRecordset.Open "select ESDSTotal,ER2DSTotal,ESASKSIZE,ESBIDSIZE,ER2ASKSIZE,ER2BIDSIZE,ER2RATIOASK…
6 replies
I use the PIVOT clause to generate a pivot table. But i want to add a sum row at the end to show me…
3 replies
Hi, I have a report that prints out all records in a table for that day, I'd like to add a count in…
2 replies
Hi, I want to keep track of data change and want to enter the pk such as testkey and timing …
1 replies
I have a table with 15,000 rows. I have created a new column on the same table. I would like the ne…
5 replies
Hi, I have a select statement accessing data through a linked server using the OpenQuery synta…
4 replies
I need to search for a record in a table that is the "nearest" to a given date. The table to be qu…
3 replies
This might sound like a stupid question. I have recently switched from sql 2000 to sql 2005. I am a…
1 replies
Hi My table data is as below. YEAR PERIODID CONTNBR Net_Transaction_Amount 2006 6 19863 2…
2 replies
Hi, I'd like to query a table excluding all records with a specific value in a column, this column …
7 replies
CREATE TABLE #tmpt1 ( Col1TINYINTNOT NULL IDENTITY(1,1), Col2TINYINT ) INSERT#tmpt1(Col2) SEL…
3 replies
By: Lowell
Query from different servers Can someone tell me why this query works when I run it from one server…
2 replies
I am not really sure how to do this or if this is even doable. I have 4 tables (A,B,C,D) with a pi…
2 replies
I'm not sure exactly how to ask this question, so I will just give sample data and my objectives fo…
2 replies
Viewing 15 topics - 11,551 through 11,565 (of 12,234 total)
You must be logged in to create new topics.