I have a query that has some parameters:

(

SELECT DISTINCT

T.TICKET_NUMBER AS TicketNum, A.DESCRIPTION AS Action, O.SYMBOL_CODE AS Symbol, T.TRADE_PRICE AS Price, T.VOLUME_TRADED AS FillVol,

T.EXTENDED_PRICE AS TotalValue, T.SUBMITTED_TIME AS ActTime, T.SUBMITTED_DATE AS...

Your code fails when there is no '+' in the string, causing the right() function to fail. You could simply update ... etc WHERE the old_column does contain a '+'.

partial...

Sounds like one of your stored procedures is sorting, joining, or comparing a TEXT column.

TEXT is useful for storing lots of highly variable input provided you only want to store...

This message is telling you that two process were trying to access the same data at the same time: look up "deadlock". The job cannot complete while other people or...

You could handle the issue by pre-validating the data for output, and directing accordingly.

> Select Data that meets all your file conditions for output: a view in SQL might be...

Updating the Primary Key (1) to (1+1=2) would create two records with the same Primary Key (2). This will not work, and should not be attempted.

A Primary Key constraint requires...

iklektic (5/28/2009)

---

Thank you everyone for your responses.

The purpose of this report is to list new customers (or customers that are in our system but have not used our services in...

This might be the SQL Server service. Probably not a good idea to kill the service behind the scenes.

I would suggest using more than one column to store the data, then your users can search intelligently.

create table dbo.Chapters

(chapterID int not null,

sectionID int not null,

csDescription varchar(100) not null

)

insert into...

Kris (5/26/2009)

---

Sorry to be a pain, but before I've even add the extra where clauses it doesn't appear to be giving me the correct results. I get 90000 records back...

Kris (5/24/2009)

---

That's awesome. Thank you so much. I don't want to push the friendship but they have just now asked me if I can exlude anything that starts...

For real?

"insert into master..SomeUserTable"

Might be a little more usful if it returned tomorrow's date if it is run tomorrow:

SELECT DATEADD (DAY, DATEDIFF (DAY,...

eseosaoregie (5/28/2009)

---

My desired result is to count the number of attendances as activity and sum up the cost. However where I am selecting the cost i need to select the...

Where will this data be held? I would assume it is going into SQL Server 2005 but your description of the issue makes me wonder.

You can use access, excel, or...