Question on sql script2963 (9/11/2010 4:08:06 PM) UtfCould 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 search1998 (9/12/2010 11:46:54 AM) RobbieHi,
Is there any easy way to search a column to see if it contains either a dash
or alpha character ?
getting trace of changes in database1851 (9/12/2010 10:47:49 AM) RoyHello 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 Value71824 (9/8/2010 11:48:54 PM) shapperHello,
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,
Simple question re autotrim varchar101746 (9/9/2010 5:48:42 PM) PaulI 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 Tools0986 (9/11/2010 1:04:28 PM) BobCan 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.
Updating one paramter from another1659 (9/10/2010 6:54:37 PM) CharlesLHello, in a SQL 2005 report is have two parameters:
When the user selects the start date, is it possible to have that
automatically update the end date? Say, to automatically update...
convert IIF statements3821 (9/10/2010 1:10:03 AM) Utfhi,
I am trying to convert IiF statement to query statement. Probably the CASE
here is what i have...
if [TP] = '2' then 'FH' elseif [TP] = '3' then 'FH' elseif [INV]=55555 then
Help with a pivot Query2983 (9/10/2010 8:48:06 PM) UtfCould 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.
Problem with Query4946 (9/10/2010 7:10:06 PM) UtfSQL2008
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
New Forums & sqlserver.programming2841 (9/9/2010 8:33:52 PM) scottI 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 SQL1857 (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...