Using MS SQL Server

Table variables and joins
Hello All, I have this table: CREATE TABLE [dbo].[AMS]( [AMSFGGID] [int] IDENTITY(1,1) NOT NULL, [AMSDESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF with these values: INSERT INTO AMS (AMSDESCRIPTION) VALUES ('TEST DESC 1') INSERT INTO ... 1 Apr 2008 10:07

difference between explicit inner join and implicit
>> Is there any difference between explicit [sic: infixed] inner join and implicit inner join << In theory, yes; in practice, no. The SQL-92 Standard says that the infixed join notation is executed in left-to-right order in the FROM clause. But the optimizer is free to re-arrange the query as long as the result... 14 Apr 2008 16:13

testing if value is null
On Mar 31, 10:12 am, laredotornado <laredotorn...(a)zipmail.com> wrote: How do I write a query where if a column, "value," is NULL I return the phrase "No value entered" but otherwise return the column's value, even if it is the empty string? I'm tried to modify this simple query You can also use a case stat... 31 Mar 2008 17:56

Doing Summation on multiple criterias on the same column in a single query
On Mar 31, 12:43 pm, --CELKO-- <jcelko...(a)earthlink.net> wrote: Why do you assume that all flags are aggregations? << Not aggregations per se, but things set by events at a different level of abstraction in the data model. Most of my postings have dealt with things that should be deduced from simple... 3 Apr 2008 18:01

Need help writing a stored procedure
How would I write a stored procedure to get * where duedate is less than and not equal to today's date. Is this right? select * from library where duedate < != getdate() Thanks ... 1 Feb 2008 23:37

sql learning
I am thinking about doing a computer course.It is learning about sql to become an MCDBA.I am trying to find out how difficult this could be as I will be doing it from home and it is going to cost over £4000 for all the CD ROM's,books etc.You understand I don't want to start the course only to find I can't do it.I h... 1 Feb 2008 14:13

autonumber
I am working with a database that was created in Lotus and importing it into Access. There are hundreds of clients in this data base that have to be kept and maintained. My question is: Will auto numbering work with this imported file and will it continue with the last number that is in there and if not can I ma... 1 Feb 2008 00:43

Transfer data to web page fields
Can anyone help me to transfer data results from a SQL query to input forms on a web page using vba or whatever will work. I work on a web page with forms that I need to populate with data. The web page is not mine and I have no control of the web page. My data comes from an SQL query and I want to code the ... 1 Feb 2008 04:06

help with update
Hi all.....Im ok with sql but by no means a guru i have like 100,000 rows of lineitems example: invoiceid, lineitemId, squencenum 9999999 11111111 1 9999999 11111181 2 9999999 11111182 3 the Data consistes of Many Invoices and the Lineitem id is a Unique Id (Most are consequtive but not a Guarantee) and ... 1 Feb 2008 00:43

Join 4 tables - can it be done?
I need some help, i need to join 4 tables but get a huge number of results, so I must be doing something wrong. here are my tables WebGroups - WebId -Title (values: "Admin" or "NonAdmin") WebGroupMembers - WebId - MemberId Webs - WebId - Title UserInfo -MemberId -Title I want to return the Di... 1 Feb 2008 14:13