good to hear it helps. But keep in mind that the code I provided will only convert 0-9 from MCS to decimal and will only show results for up to...

since it is an INT datatype a direct conversion is not possible be sql server does a conversion from into to datetime as the value of days since 1900-01-01.

--today's date...

First of all what data type is START. varchar, int, datetime? It will depend on the answer.

You shouldnot need to convert the value to smalldatetme if the format is yyyymmdd. sql server will recognize that string as a date.

What a see from brief glance is that you are trying to update a column that doesn't exist. p_top is not a column in #t_q table. Loginname is not...

Here is an article on how to enable SSL encryption on SQL server

http://support.microsoft.com/kb/316898

this probably isn't the most elegant of solutions and without any test data or table structures i came up with what could be a starting point for you. I did...

A simple google search may get you the information you want or at least the information to form a specific question.

http://www.google.ca/search?q=er+diagram&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Can you post execution plan of the query? I would assume that since you use date as criteria for your query but do not have an index on that column,...

Books online is your friend

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

don't know if this will work for you but...

exec xp_cmdshell 'bcp "select sid from master.sys.syslogins" queryout c:\bcpout.txt -T -c';

go

create table sidtemp([sid] varchar(255));

go

exec xp_cmdshell 'bcp master.dbo.sidtemp in c:\bcpout.txt -T -c';

go

select *...

I assume the single location will be a database so why the need to convert the value to a string? Why not just leave it as varbinary?

I only ask this...

perhaps this will help. It is quite what you are looking for but may be of value.

http://www.sqlservercentral.com/scripts/SID/62274/%5B/url%5D

I must ask, what would you need the actual sid value for?

following the steps below should allow you to attach your database but may not be sufficient for what you need it for as there may be data loss.

1) create new...

Please look at this article on how to post data to get the best help. The more effort you put into forming a question, the more people will be willing...