I would look to join it to a date table - if you don;t already have one the below would create one on the fly for you...

declare @Dates table (Dt...

Not sure if I am missing something - would you simply look in

[dbName] >>> Programmability >>> Stored Procedures

through the ssms object explorer??

No worries 🙂

http://www.sqlservercentral.com/articles/Miscellaneous/2959/

Excellent Lutz - learn something new everyday...

not thought of putting the results to text

declare @table table (EmpID int, FirstName varchar(45), LastName varchar(45))

insert @table values(1, 'First', 'Second')

insert @table values(2, 'Chris', 'Cintrella')

SELECT...

Got ya - think I'd probably create a report template with the company details as a dataset and placed in the report header and then generate further reports from the...

You can see which jobs are scheduled through the job activity monitor - however if jobs are invoked from stored procedure fairly sure they wouldn't show here - think the...

Not a web expert - but would you write a constant in the web config file or something like that ??

As far as I am aware SQL will not be able to provide the dataset in the way you require - you would need to handle the display of the...

another way would be as shown below...

declare @table table (EmpID int, FirstName varchar(45), LastName varchar(45))

insert @table values(1, 'First', 'Second')

insert @table values(2, 'Chris', 'Cintrella')

select empid

,'FirstName' NameType

,FirstName

from @table

union all

select empid

,'LastName' NameType

,LastName

from @table

order...

howabout the unpivot operator ?

If you looking to learn just SQL then you could try http://sqlzoo.net/ and definitly use BOL

If using reporting services this would be possible by using a Matrix / tablix and applying grouping

Have you tried the suggestion in this post ??

http://www.sqlservercentral.com/Forums/Topic162801-19-1.aspx

This should help you write an update statement...

-- Create Table

declare @MyBinary table(

ID INT,

ParentID...