Question on sql script21293 (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 search11321 (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 ?
Thanks !
...
getting trace of changes in database11101 (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 Value72152 (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,
LastPasswo...
Simple question re autotrim varchar102133 (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 Tools01263 (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.
thanks,
...bob
...
Updating one paramter from another1893 (9/10/2010 6:54:37 PM) CharlesLHello, 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 statements31042 (9/10/2010 1:10:03 AM) Utfhi,
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 Query21245 (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.
2009-2010 ...
Problem with Query41211 (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
Declare @ReportTy...
New Forums & sqlserver.programming21092 (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 SQL11165 (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...