You never declare the variable @db_name, which should be declared in the same scope that you declare the cursor.

You really have a weird way of doing things, I missed things...

You can't do anything in a view except for a single...

I'm sorry, I can't see the screenshot. It would be better if you post DDL for the tables instead of screenshots.

I know this might seem like more work, but it should be faster than using the scalar function, which is basically a udf.

SELECT DATETIMEFROMPARTS(

...

I would try to use an adequate collation for the comparison.

DECLARE @C NVARCHAR(10),@R NVARCHAR(10)

SELECT @C=N'12'

SELECT @R=N'12'

SELECT UNICODE(@C),UNICODE(@R), @C, @R

IF @R = @C COLLATE Latin1_General_Bin

BEGIN

SELECT 1

END

GO

Paper

Something like this?

CREATE TABLE RACE(

MEMBNO CHAR(15) NOT NULL,

RACE_AI CHAR(1) NULL,

RACE_AS CHAR(1) NULL,

RACE_WH CHAR(1) NULL,

RACE_BL CHAR(1) NULL,

RACE_NH CHAR(1) NULL,

RACE_NA CHAR(1) NULL)

INSERT INTO RACE

VALUES ('0001', 'Y', NULL, NULL, NULL, NULL, NULL)

...

My options:

SELECT

MAX( CASE WHEN ItemNumber = 1 THEN Item END) AS Col1,

MAX( CASE WHEN ItemNumber = 2 THEN Item END) AS...

Brandie Tarvin (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure if search engines...

scorpman (11/18/2015)

---

Hi,

I have a question, in terms of performance what's best in a query with LEFT JOIN:

- Put the clause in ON of the LEFT JOIN

- Put the clause in...

robert.sterbal 56890 (11/18/2015)

---

We're usually reference Books Online by name and most times include a link to the page...

Carlo Romagnano (11/18/2015)

---

I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is good in some...

You're right, those issues might cause a problem. They didn't in my current environment, but I'd be willing to improve the script if you help me with some DDL to...

SoHelpMeCodd (11/18/2015)

---

Luis Cazares (11/17/2015)Even if a strongly typed method is used, I would consider that fixing bad data should be important. Creating a list of integers and splitting it, shouldn't...

Follow these steps to solve this issue:

1. Open Edge

2. In the address bar, type the following: http://chrome.google.com/

3. Press Enter

4. Click on Download

5. Install

6. Use a proper browser. 😀

I'm sorry, I...