Programming SQL

Convert HH,MM to decimal ?
I have a table with a specific column that i get from an AS/400 The column holds worktime specified in HH,MM format. How do i convert that do a decimal number. ie. 7,45 (7 Hours and 45 minutes) i want it to become 7,75. Thanks ... 7 Feb 2006 16:45

Organization Chart (Database Design Problem)
Hi, I want to implement an organization chart. I use adjacency list model (like implementation of Employees table in Northwind). My problem is that sometimes an employee in not directly beneath another employee. For example an employee is parent of three "Divisions" and these divisions contain employees. At fi... 6 Feb 2006 03:08

database object hierarchy
Hello: In my SQL Server databases I have complex related tables and views. There is any tool which allow you to see (print) this complex hierarchy of views and tables as hierarchical tree? Thanks, GB ... 3 Feb 2006 12:25

SQL2005 CLR Framework
We have sql2005 64 bit and framework 2.0 32 and 64 bit. When i try to deploy a UDF 64 bit assembly via vs.net2005 i get following error. Error: Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes. Does any one know how to find wh... 2 Feb 2006 11:56

Unmanaged code from SQLServer 2005 CLR
Hi, I am trying to write a C# user defined function in SQL Server 2005. From there, I have to access a dll that was written in unmanaged C++. I do not think that I can use dllimport since I need to create objects from that dll. So I created a C# wrapper for the work that I need to do with the dll. I then a... 12 Feb 2006 21:42

ClrTrigger.HelpMe("Get Table Name?", Please)
So, I've read some past articles that indciate there's no easy way of knowing within a CLR trigger what table the trigger is acting against?! I read there are 2 possible solutions: 1) Add a String argument to the CLR Trigger to pass the table name. Then Create a user defined function for each table that wil... 3 Feb 2006 01:25

New request is not allowed to start because it should come with valid transaction descriptor.
I have a C# windows service that uses MSMQ, DTC Transactions, SQL server 2005 and Notification services. I am doing the following in the service: OnStart Create the queue set the Peek Complete event call Begin Peek PeekComplete WaitHandle[] waitHandle = new WaitHandle[] { new AutoResetEvent(fal... 7 Feb 2006 11:30

Login process error
Hi guys Just setup a new system running Win2k3, SQL Server 2005, etc (all msdn). I've got a web app (.net 2) which is running perfectly well, most of the time, and then there's one page where I'm getting the following error... Server Error in '/' Application. A connection was successfully established with th... 1 Feb 2006 18:45

Last Date of previous Month
ive been trying very unsucessfully to try and get the last date of the previous month, ie if i run the query today i want the result to be 31/01/2006 ... 2 Mar 2006 15:02

Date functions
Hello, I need help with my function. I need a date difference (actual datetime and another datetime in db) in hours It worked perfectly with DATEDIFF....But now I found out that I should count just the "working "days (Mo-Fri). is there any function or mechanism how to do the same but just with the MONDAY-FRID... 31 Jan 2006 02:19