Programming SQL

SQL: Spelling out numbers to words for month
Hi, How do we spell out numbers like "1, 2, 3..." to words like "January, February, March..." for month? The database is MySQL. YC ... 11 Mar 2010 18:01

Help with passing a string variable into a parameter
hello! here is my problem. I have built a dynamic string called @filepath as char50 i need to place it in: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', @filePath, 'SELECT * FROM [Sheet1$]') does any one know the correct syntax??? for passing a parameter here ... 11 Mar 2010 18:01

Connection string at asp.net app for data mirroring
Hi Don, I have also facing same problem. Did u get any solution? It is very helpful. Thanks Rit From http://www.developmentnow.com/g/113_2006_9_0_0_824660/Connection-string-at-asp-net-app-for-data-mirroring.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 11 Mar 2010 12:19

transaction history for a table
Does sql have a method of tracking transaction history for a table by user From http://www.developmentnow.com/g/113_2004_9_0_13_0/sql-server-programming.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 11 Mar 2010 12:19

GUIDs can be ordered, but can't get MIN or MAX?
DWalker07 wrote: Declare @InvalidId As NVarchar(40) Set @InvalidId = (Select Min(SomeId) From SomeTable Group By SomeOtherColumn Having Count(Distinct ThirdColumn) > 1) But I can't do this! (I know how to accomplish what I need, but it's a much longer statement.) There is ... 12 Mar 2010 15:05

DBTYP.NET Studio 2010 - Database Comparison Suite Released
DBTYP.NET Studio 2010 - Database Comparison Suite Released Vienna, Austria - March 8, 2010 Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the newest version of the cross-database comparison tool that compares SQL Server, MySQL and Oracle databases (schema and data). DBTYP.NET Studio 2010 ... 10 Mar 2010 15:21

Infinite Recursive CTE
I have a situation where you can have an infinite recusion. There is an issue where editing a page could cause infinite recursion. This would happen if a distribution folder were put into itself. It would also happen if you put folder "A" into folder "B" where folder "B" is in any of the folders contained in an... 10 Mar 2010 17:35

SP parameter optional
I have a stored procedure that I want to make the last parameter optional and default to NULL if not sent. Below is the procedure declaration and I want to have the @Week1Ending date as optional and null. How do I do this? Thanks. ALTER PROCEDURE [dbo].[mc_insTimesheetsTemp] @WorkerLinkID int, @ClientL... 10 Mar 2010 13:06

Some comment.
RETURN (DATEADD(wk, DATEDIFF(wk, 0,@CURRENTDATE),0)) this one doesn't return the date of last monday, @currentdate is today but this one only return the date of this monday. Not the last one. gv wrote: Function to get last Monday of current week 29-Oct-08 Hi guys, trying to create a function to r... 10 Mar 2010 11:58

SQL connections
Hi All, I have a requirement to be monitoring the SQL connnection to one server, and before to do a process to be loggin into a table each log in and each log out, I would like to ask you if you know if exists something in SQL that could be saving all the conections for a range of time. I don't want to use th... 10 Mar 2010 11:58