Viewing 15 posts - 6,541 through 6,555 (of 13,469 total)
Looks a lot like homework, so I'll offere a hint to help you get along.
you need to use GROUP BY employee along with a count(); i think that will get...
October 17, 2011 at 2:00 pm
Elliott Whitlow (10/17/2011)
Are you the Lowell who wrote the docs for it from the discussion on there? I just added a tweaked up version as a docx file last week.CEWII
yes,...
October 17, 2011 at 1:29 pm
Elliott Whitlow (10/17/2011)
October 17, 2011 at 12:28 pm
kbleeker (10/17/2011)
I'm sure you're not expecting a reply so long since you last updated, but here it is. This SP is absolutely fantastic - a work of art -...
October 17, 2011 at 11:31 am
i went down this rabbit hole once or twice;
I started building a catch all script that changed everything i could think of...so if a column changed from [SQL_Latin1_General_CP1_CI_AS] to...
October 17, 2011 at 11:02 am
perfectly normal;
the SQL server may create temp tables all on it's own to handle things like sorting operations for a dataset to be returned; they don't have to be explicitly...
October 17, 2011 at 10:39 am
based ont he exact example Eddie posted above, his example worked and compiled just fine on my machine.
NO EXEC didn't raise any errors at all;
Waht was your exact error?...
October 17, 2011 at 9:50 am
i don't believe the index_creation_date / modify date exists(or at least is exposed); i posed a similar question ofn when is a server side trace Creation_date...it's not available eaither...jsut when...
October 17, 2011 at 6:21 am
Dev @ +91 973 913 6683 (10/17/2011)
via xp_cmdshell;
Please follow the discussion... I cringe every time I see a recommendation for xp_cmdshell....
http://www.sqlservercentral.com/Forums/Topic1186236-1526-1.aspx
oh yeah fully aware of that one...just throwing out...
October 17, 2011 at 6:15 am
Powershell is really good for calling SMO and scripting out the definitions; there's a ton of examples for that.
There's also some CLR examples as well as TSQL calling SMO via...
October 17, 2011 at 6:05 am
PKs and UQ's constraints can be found in sys.objects;
so the common fields ofr all objects like create_date and modify_date will get you what you wan:, I think:
/*--Results
TableNamecreate_datemodify_datename
Tally2009-02-27 14:26:36.5772009-02-27 14:26:36.577PK_Tally_N
Numbers2009-02-27 14:26:41.7172009-02-27...
October 17, 2011 at 6:01 am
Performace Guard (Shehap) (10/16/2011)
GilaMonster...Really I wonder from your comments ..!!!!!!Please read more about schema partitioning + SQL Alerts+ benefits of each one + Relevant Cases studies
Gail certainly doesn't need...
October 16, 2011 at 7:22 am
your procedure has two output parameters.
if you don't need the values returned, you could change the code like this:
declare @p1 bigint
set @p1=0
declare @p2 datetime
set @p2=NULL
exec MySP @ID=@p1 output,@EntryDateTime=@p2 OUTPUT...
October 15, 2011 at 12:39 am
if you are looking for the reformatting of SQL statements type functionality, I can recommend SQL Pretty Printer For SSMS add-In
it's only $50 dollars for the registered version. I...
October 15, 2011 at 12:27 am
the OP may be a little loose in the definition of "timestamp" here;
i'm thinking it's simply a datetime field he's refering to, but I'm with Sean: no need to...
October 14, 2011 at 2:16 pm
Viewing 15 posts - 6,541 through 6,555 (of 13,469 total)