Viewing 15 posts - 8,221 through 8,235 (of 26,490 total)
Welsh Corgi (3/31/2013)
Lynn Pettis (3/10/2013)
Welsh Corgi (3/10/2013)
Lynn Pettis (3/10/2013)
March 31, 2013 at 1:06 pm
teninthreeforms (3/31/2013)
I'm having trouble incorporating this into my query though. I get forbidden text messages.
You need to take what I showed you and use it in your code. Don't...
March 31, 2013 at 12:55 pm
I can run the code all day long, it won't tell me what the problem is if you don't show me. I have no idea what the expected results...
March 31, 2013 at 12:53 pm
I hope the following code snippets help you:
declare @AccountNumber varchar(8) = '0023456';
select
patindex('%[1-9]%', @AccountNumber),
len(@AccountNumber),
len(@AccountNumber) - patindex('%[1-9]%', @AccountNumber) + 1,
...
March 31, 2013 at 12:40 pm
Welsh Corgi (3/31/2013)
I'm filtering on a specific job in this case.
SELECTj.job_id,
s.srvname,
j.name,
js.step_id,
js.command,
j.enabled ,
last_run_date
,
...
March 31, 2013 at 12:23 pm
Jan Van der Eecken (3/31/2013)
Lynn Pettis (3/30/2013)
SQLRNNR (3/30/2013)
Lynn Pettis (3/30/2013)
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
March 31, 2013 at 12:22 pm
SQLRNNR (3/30/2013)
Lynn Pettis (3/30/2013)
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?
Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third...
March 30, 2013 at 5:49 pm
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?
Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to...
March 30, 2013 at 5:43 pm
The information you see in sp_helpdb can be found in the system dmv's. Start with looking at sys.databases and go from there. Be sure to check out each...
March 30, 2013 at 12:40 am
In this case, I would not use the time data type. Plus, if you do and the total time reaches 24 hours or more, the time data type will...
March 29, 2013 at 6:20 pm
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?
Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not...
March 29, 2013 at 6:16 pm
umarrizwan (3/29/2013)
select 'select mfg from'+convert(varchar,ApplianceTypeTableName)+'union'
from
ApplianceTypes
check you query editor to result to text
and execute above.
copy result in another query editor window and execute.
Why all the extra work when you can...
March 29, 2013 at 6:13 pm
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
ScottPletcher (3/29/2013)
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb.
Really? ...
March 29, 2013 at 5:49 pm
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?
Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and...
March 29, 2013 at 5:44 pm
Not that I don't believe, is there anything I can do to see this? I may not have the time right now but this could be something I could look...
March 29, 2013 at 5:30 pm
Viewing 15 posts - 8,221 through 8,235 (of 26,490 total)