Help With T-SQL
Wed, 23 Jul 2008 10:09:01 -0700 (PDT)
I have the following T-SQL I want to use as a stored procedure.
However, when I run the script all at once it errors out.
If I run each operation one at a time it works.
What do I need to put in between the opertaions to make it run
through? I denoted the operations with "--------break--------------
below.
...
|
Help with substring/ patindex function
Wed, 23 Jul 2008 10:44:47 -0500
I have a table column that has data as shown below
item A STD
item B STD 1
item C 1 FP
item D 1 FP 1
etc...
I want a way to return everything to the left of STD or FP
So,
item A
item B
item C 1
item D 1
etc...
Is there a way I can use substring with patindex to do this in a query?
Thanks
...
|
Querying Help - return the MinTemp and MinDateTime
Wed, 23 Jul 2008 17:08:51 +1200
I am trying to return a record set like this from a SQL 2005 database.....
DateTime MinTemp MinTempDateTime MaxTemp MaxTempDateTime Period
2008-06-09 1.2 2008-06-09 3:34:12 4.5 2008-06-09 4:45:23
Night
2008-06-09 12.2 2008-06-09 6:34:12 24.5 2008-06-09 14:45:23 Day
B ...
|
SQL Server and RRAS
Mon, 21 Jul 2008 17:14:55 +0100
Hi all
Ran SQL server on a server in June that had RRAS enabled and all worked fine
Trying again now and just can't get the LOCAL terminals to access the server
is RRAS enabled
If it's disabled it works fine.
So it looks like it might be a the LOCAL firewall blocking acces.
However the normal window ...
|
New publication wizard ends with error
Sun, 20 Jul 2008 04:31:50 +0100
Hi
I installed a new instance of sql server 2005 developer, installed sp2 on
top and restored a previously backed up sql server 2005 database.
I then went on to setup merge replication. I ran the 'Configure Distributor'
step with success. When I tried to create a new publication by right
clicking on 'Loc ...
|
developer vs standard
Sat, 19 Jul 2008 23:31:01 +0100
Hi
What is the difference between sql server developer and standard?
Many Thanks
Regards
...
|
Trigger to insert column value
Thu, 17 Jul 2008 18:29:29 +0100
Hi
I am new to triggers. I have checked the syntax of triggers but it is very
complicated for a newbie like me. What is the syntax of a trigger that will
once a new record is inserted into the Contacts table, sets the value of the
column 'Company Type' to Client in the inserted record?
Thanks
Regards
...
|
|
|
Can SQL Server 2005 Std run on 1 processor in a 2 processor server?
Thu, 17 Jul 2008 12:17:17 -0500
I ask this as my budget is limited. I can get SQL Server 2005 Std with SA
and a 1 processor license for <$300 through a non-profit tech site. My
server has 2 processors, however. I found a source that caters to
nonprofits that will sell me one for ~$1500 (a single processor license).
So .... can SQL run O ...
|
Amazon: "Accelerated SQL Server 2008"
Wed, 16 Jul 2008 08:25:11 -0600 (MDT)
http://easyurl.net/SQLserver2008
...
|
What's the best way of removing duplicates records?
Tue, 15 Jul 2008 15:03:28 -0400
Hi All,
What's the best way of removing duplicates records? I need to check for duplicates records based on first name, last name, address phone and zip. It always could based on a different fields set.
Thanks,
Joe
...
|
