(0.014 seconds) Articles (1873) /94 Next>> Last >| Question on sql script 2 1096 (9/11/2010 4:08:06 PM) Utf Could someone please help, I have started a new position in reporting, and I'm major learning on the job. I need to create a script to extract data from a single table. The fields are Customer, Units, Sal... SQL help string search 1 1120 (9/12/2010 11:46:54 AM) Robbie Hi, Is there any easy way to search a column to see if it contains either a dash or alpha character ? Thanks ! ... getting trace of changes in database 1 951 (9/12/2010 10:47:49 AM) Roy Hello there. I've build database trigger who saves all schema changes in some table. and i use it to apply changes in another server. It works fine as long as i do only shcma changes as part of schema and ... DateTime Null Or Minimum Value 7 1954 (9/8/2010 11:48:54 PM) shapper Hello, I am working on a authentication system and I have the following: create table dbo.Users ( Id int identity not null, LastLock datetime not null, LastLogin datetime not null, LastPasswo... Simple question re autotrim varchar 10 1934 (9/9/2010 5:48:42 PM) Paul I have a table with a number of varchar fields - name, address, etc. Many values were stored with trailing spaces, and a few with leading spaces. It's easy enough to clean up the existing data, but is ther... ERD Tools 0 1088 (9/11/2010 1:04:28 PM) Bob Can anyone recommend a good ERD program? I'm looking for something to build diagrams but there are so many out there to pick from. Any advice is appreciated. thanks, ...bob ... Keyword EXCEPT not working - SQL Server 2000 6 1021 (9/9/2010 7:59:47 PM) Jack Folks, Does the keyword EXCEPT work only in SQL Server 2005 and later versions? Thanks! J.S. ... Updating one paramter from another 1 744 (9/10/2010 6:54:37 PM) CharlesL Hello, in a SQL 2005 report is have two parameters: @STARTDATE @ENDDATE When the user selects the start date, is it possible to have that automatically update the end date? Say, to automatically update... convert IIF statements 3 900 (9/10/2010 1:10:03 AM) Utf hi, I am trying to convert IiF statement to query statement. Probably the CASE statement... here is what i have... if [TP] = '2' then 'FH' elseif [TP] = '3' then 'FH' elseif [INV]=55555 then 'FH'... Help with a pivot Query 2 1078 (9/10/2010 8:48:06 PM) Utf Could someone please help with the following: I need to create a query that will pull from one table 'Order_Line_Invoice' and display in the following output. 2009-2010 ... Problem with Query 4 1048 (9/10/2010 7:10:06 PM) Utf SQL2008 I am trying to get the following query to work Declare @FileName varchar(max) Declare @FullPath varchar(max) Declare @Licence varchar(6) Declare @LedgerKey uniqueidentifier Declare @ReportTy... New Forums & sqlserver.programming 2 936 (9/9/2010 8:33:52 PM) scott I have the new forums setup within outlook express and browsed through all of the new forum names. What forum will be the equilivant to sqlserver.programming? Thanks for any info. ... Help Required in SQL 1 966 (9/10/2010 6:34:15 AM) Jami sql 2000 Question i have following ddl and sample data CREATE TABLE [Model_data] ( [main_id] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [model_1_Group] [char] (1) COLLATE S...