Here is:

- Working with Transaction Log Backups -

http://msdn.microsoft.com/en-us/library/ms190440.aspx

😉

A little bit late, but I expect that still could be of any kind of help.

-- employee

declare @e table

(employeeId int

, hireDate...

If your table already have a field with the type of service, only need to add it to the cursor and to your output.

But If you have to calculate...

Just yesterday in the SQL Server Central newsletter there is an article of Phil Factor talking about how to automate the scripts generation to migrate tables from one server to...

I'm afraid you're in troubles. I'll try to explain you this item as clear as my limited english let me do.

The message "The workgroup information file is missing or opened...

Cadavre (2/3/2012)

Oh for the love of. . .

1) That...

To do this without joins, you can use this deprecated, but still useful sintaxis:

SELECT a.*, b.*

FROM Table1 a, Table2 b

Best regards!

According to this reference http://msdn.microsoft.com/en-us/library/ms191203.aspx, there are only 3 rules in hierarchy of options. I would like to know from where comes option no. 4?

Option no. 5 should have to...

This would be another solution:

SELECT [NAME],

CASE WHEN [ID] = 1 THEN [VALUE] ELSE NULL END AS Col1,

CASE WHEN [ID] = 2 THEN [VALUE] ELSE NULL END AS Col2

FROM #Table

I...

Instead of trim the last character, you can trim the first, using STUFF function:

DECLARE @ColumnListNVARCHAR(MAX)

SET @ColumnList =''

SELECT@ColumnList = @ColumnList + ', ' + CAST(COLUMN_NAME AS VARCHAR(128))

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'TExtras'

ORDER...

Personally I thing that life doesn't ends with the dead, life could ends before if you don't find nothing to keep on living.

Do you have heard about Ernestine Shepherd? At...

This will return an extra comma on the right, but trimming it should be an easier task:

select ID,

(case when var1 = 1 then 'var1,' else '' end +

case when...

Ok, I'm assuming that @date_from and @date_to are of type varchar. If so, you only need to add an space before the hour part in the @temp assingment:

set @temp =...

Im assuming that @cfrc_id is of type int, If @cfrc_id is null, then you have to compare the field [cfrc_id] with its own value, something redundat but necesary:

WHERE cfrc_id=cfrc_id

Otherwise, you...

Altough you can see a resultset when you run a sp, the sp always returns an int value, usually zero if there isn't execution errors.

If you need to handle a...