Viewing 15 posts - 1,366 through 1,380 (of 2,458 total)
You could capture that amount of time that a stored procedure executes using Extended Events. "
June 11, 2015 at 1:29 pm
Can how post some DDL, sample data and the query you used to get the result set that you posted?
June 10, 2015 at 2:27 pm
Mile Higher Than Sea Level (6/10/2015)
After clicking OK, it just runs fine.
Is this error message normal?...
June 10, 2015 at 2:21 pm
dniranjan2000 (6/10/2015)
Hi Alan,Many Thanks for your suggestion and recommending the books.
currently I am concentrating on T-SQL for a good foundation.
Kind regards
Niranjan
Excellent. I got my Start in SQL in a similar...
June 10, 2015 at 9:45 am
I'm with everyone else - SQL Saturday and Local User Groups are great resources.
I would add - I have working in the past with Tek Systems. I think they...
June 9, 2015 at 2:12 pm
The image you post does not help. DDL and some easily consumable sample data would be better.
The logic you are looking for will look something like this:
-- SOME...
June 9, 2015 at 1:59 pm
The internal result strings are delimited with Char(10), conservative counts are from 64k to over 100k lines in each record. ...
Is there a way to parse the individual lines into...
June 9, 2015 at 1:45 pm
If you want to go the DBA route then you will want to learn more about backing up/restoring databases, Installing and configuring SQL Server, VMs, Disk storage and things of...
June 9, 2015 at 10:42 am
You have:
= IIF(Parameters!getSource.Value)="ACME", "Company1",Parameters!getSource.Value)
Remove the parenthesis after ".Value":
= IIF(Parameters!getSource.Value="ACME", "Company1",Parameters!getSource.Value)
June 9, 2015 at 10:28 am
Iwas Bornready (6/8/2015)
Good script, thank you.
Thanks sir!
June 8, 2015 at 10:50 am
Sioban Krzywicki (6/5/2015)
Brian J. Parker (6/5/2015)
RonKyle (6/5/2015)
That's a different but interesting topic. For that I have a separate Holiday table.
I agree that that's a better way. It's been on...
June 5, 2015 at 4:12 pm
Brian J. Parker (6/5/2015)
RonKyle (6/5/2015)
That's a different but interesting topic. For that I have a separate Holiday table.
I agree that that's a better way. It's been on my list...
June 5, 2015 at 2:44 pm
Jeff Moden (6/5/2015)
Brian J. Parker (6/5/2015)
June 5, 2015 at 2:27 pm
RonKyle (6/5/2015)
June 5, 2015 at 1:33 pm
Not sure if anyone mentioned this yet but I figured I'd add in:
US military jobs, even civilian ones on bases, have ranks, and the pay for each rank is known...
June 5, 2015 at 1:20 pm
Viewing 15 posts - 1,366 through 1,380 (of 2,458 total)