lol :hehe:

You either ref yourself, or seen an older ref do that. Only problem, we may be god on the field, but we do need to keep control of...

I wasn't the atheltic type when I was younger. Getting involved in soccer has changed that. Realizing that many of the refs I work with are in their...

Alan Frelich (8/8/2008)

---

I use the ASCII function to return the ascii characters of the string and it returns char(32) numerous times on the end of the string. When I run...

I've never had a problem with rtrim. How do you know that it isn't working?

😎

Just a guess, but the service account running SQL Server may not have sufficent priviledges to run xp_cmdshell.

😎

I have been officiating soccer since March 2003. I have started going to the gym on a regular basis finally back in June. I was getting myself ready...

Lynn Pettis (8/8/2008)

---

Since you want A, B, C, or all three, try the following:

DECLARE @product_name nvarchar(3)

SET @product_name = 'All'

SELECT

*

FROM

dbo.product

WHERE

...

Since you want A, B, C, or all three, try the following:

DECLARE @product_name nvarchar(3)

SET @product_name = 'All'

SELECT

*

FROM

dbo.product

WHERE

(product_name =...

dream coder (8/8/2008)

---

Thanks, but i need a IF because of the following:

DECLARE @product_name nvarchar(3)

SET @product_name = 'All'

SELECT * FROM product

WHERE product_name = CASE @product_name

WHEN 'All' THEN...

dream coder (8/8/2008)

---

Thanks i saw that step, i would still like to know if u can use an "IF" in the WHERE clause of the SQL statement cause i dont...

Because nothing met the criteria specified in the WHERE clause??

I can't really answer this question as I have no data (tables, sample data, expected results) with which to test the...

Not sure, but would using a decimal (decimal(24,0)) instead of bigint help at all?

😎

Reformatted your code some so I could read it better, but really can't help you with the query as there really isn't enough information.

It would help if you provided the...

Check out this code and see if it provides what you the results you require. Also, when writing multiple table queries, you should use table aliases for all columns,...

This is another way to write the code above:

select @Records = count(*)...