Viewing 15 posts - 556 through 570 (of 5,502 total)
Please remove the last line
@database_name = N'master', @flags = 0
and the preceeding comma.
I accidentally copied the last two parameter of the sp_add_jobstep parameter. I'm sorry.
February 27, 2012 at 2:54 pm
Ok, here's a first draft that might help you to get started.
After a closer look to the code you've posted I don't think there's a need to use a parameter...
February 27, 2012 at 2:28 pm
jcrawf02 (2/27/2012)
Ah yes, those Detroit cacti are a real pain...
I guess you're not referring to those on the ground, are you? 😀
February 27, 2012 at 1:59 pm
Are you familiar with writing stored procedures?
I would break the sproc into three parts:
1) get the html table and assign it to @tableHTML
2) depending on an input parameter create [TJC_Custom].[dbo].[tblDailyJobStatus]...
February 27, 2012 at 1:54 pm
Evil Kraig F (2/27/2012)
Jeff Moden (2/25/2012)
It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀
This is a YouTube video just...
February 27, 2012 at 1:20 pm
Wouldn't it be easier to use a stored procedure that would create the html formatted table as a nvarchar(max) variable and call that sproc with @command?
I, personally, wouldn't put that...
February 27, 2012 at 1:13 pm
Did you try to use UNPIVOT with tab1 to get a table with whatever_symbol, whatever_description and whatever_value that can be used in a join on with your current query (or,...
February 27, 2012 at 12:34 pm
So, is SaraGate a new name for RedGate? :unsure:
And, thank you, Brandie. Now I know there's a key required. So the area seems to be locked. I'll keep asking questions...
February 27, 2012 at 11:18 am
Koen Verbeeck (2/27/2012)
This one obviously is (on another site):
...
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've...
February 27, 2012 at 10:43 am
Your requirement looks like a wildcard search:
WHERE (((CABWO_WO_DETAILS.TITLE) Like "*" & [Please Enter WO Title] &"*"));
February 26, 2012 at 3:45 am
@r.P.Rozema:
I absolutely agree. Completely missed the fact that we have a "known scenario" for step 2.
I'd go for the CHARINDEX approach then. Thank you for the correction!
February 26, 2012 at 3:10 am
Let me quote from my previous post:
Step1: use the DelimitedSplit8K function referenced in my signature with delimiter ','
Step2: using the result set, apply the DelimitedSplit8K function with delimiter '='
February 26, 2012 at 2:28 am
Hi Richu,
I'm not sure if this is what you're looking for (especially in terms of the SED nodes), but here's something to start with:
SELECT
'@name' = n.Name,
'@desc' = n.Descr,
'Address/@name'...
February 26, 2012 at 2:26 am
Did you try using SUM() OVER()?
SUM(Num) OVER (PARTITION BY Age) AS Ga
SUM(Num) OVER (PARTITION BY Age, D1) AS GaD1
SUM(Num) OVER (PARTITION BY Age, D1, D2) AS GaD1D2
February 25, 2012 at 1:41 pm
Guessing again, it seems like the OP is quite happy with the answer received at msdn
February 25, 2012 at 12:43 pm
Viewing 15 posts - 556 through 570 (of 5,502 total)