select based on count 7 165 (12/13/2009 10:47:32 AM)
Hi all I have a table UserName PrinterName PageCount Message criss HP 7 Printed criss Xerox 6 Printed criss menolta 5 printed bob hp 3 printed bob hp 4 Printed I wanted to get thouse users whos Pag...
roma_victa

Need help with join syntax and SQL select 8 131 (12/11/2009 9:22:01 PM)
-- Given the following: CREATE TABLE [dbo].[a]( [id] [int] IDENTITY(1,1) NOT NULL, [desc] [varchar](50) NULL ) CREATE TABLE [dbo].[b]( [id] [int] IDENTITY(1,1) NOT NULL, [desc] [varchar](50)...
Utf

Need help with the SELECT statement. 4 158 (12/11/2009 4:35:01 AM)
--SQL 2005. I am converting Access db to SQL Server and need some help how to construct the query to desire results below. Thank you in advance. IF OBJECT_ID('Tempdb.dbo.#LoanComp', 'u') IS NOT NULL ...
Utf

SQL Server 2000 Disable Ad-Hoc Access 1 355 (12/9/2009 4:02:01 PM)
We recently had an audit done and they came back from some ESM tool and said that this should be disabled. Here are my questions: 1. Why? Does anyone know? 2. The only thing I could find that this is i...
Utf

New to Windowing functions 5 112 (12/10/2009 8:26:39 PM)
hi I=92ve started learning about Windowing functions and while I somewhat understand the basics, I still feel like I don=92t quite see the big picture. Anyways, here are few questions 1) I assume the ...
klem

Backup - Restore MS SQL 0 125 (12/12/2009 8:51:42 AM)
Easiest and Step by Step procedure to create backup and restore MS SQL using Enterprise Manager http://www.ezdia.com/Backup_and_Restore_MS_SQL/Content.do?id=1047 ...
Additya

change database that exists on the same server 7 134 (12/4/2009 12:04:07 PM)
Hi I'm trying to connect different database on a same server based on the varriable i set declare @scheme varchar(100) set @scheme = 'first' -- SELECT @scheme , @Plan , @SecurityRF, @Holdings, @S...
ganesh

Implementing autoincrement identity 8 173 (12/9/2009 7:25:22 PM)
Hi I'm looking for an advise/suggestion on how to build my own auto-.increment identity. I've a table with the following structure: ParentId ChildId Field1, Field2,..... 1 1 1 ...
Peter

Exporting/Importing Image Columns 1 321 (12/11/2009 8:31:01 PM)
We have a situation where we'd like to create stored procedures to export and import images data from a certain table. For various reasons we cannot simply bulk export/import. Is it possible to do this ...
Utf

help with SQL Join 4 114 (12/11/2009 6:45:32 PM)
I need to use the Vendor Transaction Table to identify which vendors have NOT been used in 2008 or 2009. This table has one row for every transaction. I know how to get the vendors that were active during ...
Dig