chindilog (8/28/2015)

---

The problem here is, I am not using any tool. I am working on inventory tool, which through JDBC connects to database server. Database is called fishbowl database. Once...

black beans

Of course, you need some tweaking to make it numeric.

CREATE TABLE #SampleData( num varchar(100));

INSERT INTO #SampleData VALUES

('1000:001'),

('1001:001'),

('1002:001'),

('999:001'),

('998:001'),

('99:001'),

('1:001'),

('2:001'),

('3:001');

--This won't work correctly

SELECT * FROM #SampleData ORDER BY num

--This...

Actually, serverproperty('ProductVersion') returns the version in the form of 'major.minor.build.revision'.

Here are some changes to your code which might follow a better logic.

- I changed the @ver to an integer...

mar.ko (8/28/2015)

---

I want the EXEC right after the CTE.....no can do.

I put a semicolon after the last paren of the CTE and that throws a syntax error.

Something strange is happening...

Are you ending your statements with semicolons?

Other than that, I would need to see some sample code to be sure what are you talking about.

I included some comments on your code.

DECLARE @ver nvarchar(128);

DECLARE @UserName nvarchar(50);

DECLARE @UserD nvarchar(80);

DECLARE @LoginD nvarchar(80);

-- Initialize the variable.

SET @ver = CAST(serverproperty('ProductVersion') AS nvarchar)

SET @ver = SUBSTRING(@ver, 1, CHARINDEX('.', @ver) -...

Read the article on your signature on how to post performance questions.

No need to loop, the code that I posted will traverse the entire table and create the complete statement.

Here's a slightly different example:

CREATE TABLE ScriptTable(

groupID Nvarchar(10),

...

First you were truncating the date because you inserted the string value into a date variable and were expecting an 8 character string, so the variable converted again from date...

Something like this could work if you always return the same columns.

DECLARE @sql nvarchar(max) ;

SELECT @sql = ISNULL( @sql + CHAR(10) + 'UNION ALL ' + CHAR(10), '')

+ SQLStatement

FROM...

ScottPletcher (8/27/2015)

---

Since you literally can't add enough values here to make a cursor all that bad, you might want to use a cursor just to have better control over the...

patrickmcginnis59 10839 (8/27/2015)

---

drew.allen (5/30/2012)

---

dwain.c (5/29/2012)

---

Datetime functions do have their issues though, like the following:

SELECT DATEADD(month, 1, '2012-02-29')

Depending on your point of view, the results this returns looks wrong, or maybe...

Of course, you can do it without a cursor and a bit of dynamic sql.

Create procedure call_procedure(

@multiple_weeks varchar(8000)

)

AS

----Sample Data

--DECLARE @multiple_weeks varchar(8000) =...

Another possibility.

SELECT *

FROM #temp

ORDER BY CASE WHEN Section NOT LIKE '%[^0-9]%' THEN CAST( Section AS int) * -1

...