SQL help string search Robbie 1 170
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 Roy 1 213
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 fi...

Question on sql script Utf 2 192
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...

ERD Tools Bob 0 335
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 ...

Help with a pivot Query Utf 2 280
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...

Problem with Query Utf 4 177
SQL2008 I am trying to get the following query to work Declare @FileName varchar(max) Declare @FullPath varchar(max) Declare @Licence varchar...

Updating one paramter from another CharlesL 1 182
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 aut...

Help Required in SQL Jami 1 180
sql 2000 Question i have following ddl and sample data CREATE TABLE [Model_data] ( [main_id] [varchar] (15) COLLATE SQL_Latin1_General_...

convert IIF statements Utf 3 196
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...

Duration between 2 dates Kru 1 338
Hi, I need some help on calculating number of days between two dates excluding weekends and holidays. Is there a function in sql that can do this...