Topics
Started by
Posts
Last post
Hi, Here is the difference between UNION and UNION ALL. UNION: 1) Exclude duplicate values 2) Will …
1 replies
I need to be able to summarize the data for a report ordered by StaffName allowing for multiple row…
38 replies
Hi.i am trying to formulate a setbased solution which would speed things up dramatically: As part o…
4 replies
I had posted this in SQL 2005 forum. First thanks Peso I got the answer in SQL 2005 but my client …
2 replies
i m trying to execute query with server 2000 query is: select * from employee where salary = ? but …
1 replies
Hello. This line works fine. MyTable has 3 columns exec (insert MyTable SELECT 'C2100', 'LG', 'TV')…
1 replies
I'm looking for some guidance on the best way to building this query or function or what ever is ne…
4 replies
I have a query that returns a few rows, well I'd also like to join in a sub query that sums some st…
1 replies
I think I am in abit of trouble here. I wrote a program a couple of months ago that was pretty sol…
4 replies
I posted yesterday thinking a SELECT Distinct would solve my problem but it didn't. I have a store…
1 replies
Currently, I am tracking database structure changes through upgrade scripts. The database have a ve…
9 replies
Hello, I have a column in a table that stores time in milliseconds and I want to be able to sum the…
3 replies
Hi, I am having problems writing this query with SQL Server 2000, i need to display a list of playe…
4 replies
I know that I can do this to add a new NT User to the Database and grant them access to a specific …
3 replies
Ran this to select 30 records from one table. select * from tower.nbdocdeletedrecords with (nolock)…
5 replies
Viewing 15 topics - 3,346 through 3,360 (of 17,082 total)
You must be logged in to create new topics.