Viewing 15 posts - 7,651 through 7,665 (of 8,731 total)
So, you have a current solution but would like a better approach?
You could try with EXCEPT or NOT EXISTS.
Here are the examples.
select PArtNumber,
Item
from #Table_Orig prev
CROSS APPLY dbo.DelimitedSplit8K(VALUE, ' ')
WHERE prev.FileVersion...
September 30, 2013 at 1:12 pm
From the first line, it seems that you don't have permissions to SELECT data from a table.
It would help if you tell us what were you trying to do.
September 30, 2013 at 12:33 pm
To help you, we would need some consumable DDL, sample data and expected results based on the sample data provided as noted in the article linked on my signature.
I know...
September 30, 2013 at 10:38 am
You could also avoid using dynamic SQL, even if it might reduce performance a bit.
You could try this.
DECLARE @ReportLevel AS VARCHAR(10);
SELECT *
INTO #TempLevels
FROM tblLevels AS a
INNER JOIN tblReports AS b...
September 30, 2013 at 10:33 am
Do you have some column to identify the night shift?
Otherwise, you would have to code exactly for that employee and it will fail when another employee takes the night shift.
September 30, 2013 at 10:25 am
Just another possible solution.
SELECT *
FROM DelimitedSplit8K(@test, ' ') x
WHERE CHARINDEX( '@', x.Item) > 0
For the code of DelimitedSplit8K please read the following article:
September 30, 2013 at 9:44 am
Jeff Moden (9/29/2013)
I'm am totally afraid for this person...http://www.sqlservercentral.com/Forums/Topic1499747-391-1.aspx
For this person or for his/her company?
September 29, 2013 at 3:04 pm
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!
Congratulations Lynn. Best wishes for the newborn...
September 29, 2013 at 9:32 am
I don't understand completely your problem. Please read the article linked on my signature to guide you on your posts and get better help. If you give me DDL, some...
September 27, 2013 at 12:59 pm
You can't. You need to repeat the CASE statement for every column needed or change the logic.
September 27, 2013 at 11:57 am
Sean Lange (9/27/2013)
Luis Cazares (9/27/2013)
Sean Lange (9/27/2013)
Luis Cazares (9/27/2013)
September 27, 2013 at 10:44 am
To add to what has been posted, you could read this article:
Why doesn’t ISNUMERIC work correctly? (SQL Spackle)[/url]
EDIT: There's a good solution but you might not like it. Use TRY_CAST()...
September 27, 2013 at 10:15 am
ScottPletcher (9/27/2013)
Neither CAST nor CASE is actually necessary here:SIGN(CHARINDEX('@', <string_value>))
+1 I've never used it before and had forgotten this function.
September 27, 2013 at 10:07 am
You need to add a MAX (or MIN) to your price columns and group by the others.
September 27, 2013 at 10:02 am
Viewing 15 posts - 7,651 through 7,665 (of 8,731 total)