Programming SQL

using between to seach for date
I am trying to search for a table for some information using this query select * from table A where lastdate between '07/01/06' AND '07/30/06' the lastdate column dates are listed as date and time '2007-01-08 15:38:50.877' but I am interested in only the date. the sql above does not return anything - ... 2 Jul 2008 13:58

Using an SQL function as part of a view
I am using SQL Server 2000 and have written a fucntion that I would like to include in a view. The function returns a decimal value. When I go to my view, right click and select "Add table..." and then click on the "Functions" tab, there is nothing there to pick. What am I missing? How do I include an SQL serv... 5 Jul 2008 19:40

can dynamic SQL be stored in tables?
Hello, I would like to store multiple dynamic SQL in some meta table and use a cursor to read selected dynamic sql and execute to increase flexibility. Is this even possible? See code example below:... declare @csql nvarchar(4000) DECLARE c1 CURSOR READ_ONLY FOR SELECT sql FROM dbo.AH_Test_Meta OPEN ... 2 Jul 2008 20:09

how to strip specific email address from nvarchar field with m
The problem is the "..." you have specified before the email server name: replace(sentto,'...@google.com','') The replace function doesn't do a LIKE comarison search; it can only replace one literal string with another. What my previous example does is remove all occurrances of "@google.com" from [sentto] and... 3 Jul 2008 14:34

Distinct Count Help
Hi All, I need some help with distinct count on mulitple field e.g Select count (distinct Field1, Field2, Field3, Field4, Field5, Field6, Field7, Field8, Field8) from tableA Where Field1 = 'somecondition' Thanks A ... 2 Jul 2008 11:54

Default date format for convert(datetime,TextDate)
Hello: I have a web application with a lot of stores procedures running under SQL Server 2000 in English but the languaje of the application is Spanish. In many of these stored procedures there are transformations of text dates like convert(datetime,'01/07/2008 19:45:23') before I store it in a datetime fiel... 2 Jul 2008 08:49

Linked Server and Stored Procedure
I didnt get it to work the way i wanted. So the only thing was to put the files where the sql server was installed. Any ideas why the unc pathing doesnt work? Regards Martin "Martin Arvidsson, Visual Systems AB" <martin.arvidsson(a)vsab.net> skrev i meddelandet news:%23RASLZ22IHA.4164(a)TK2MSFTNGP03.phx.gbl.... 2 Jul 2008 08:49

can any one post coding for taking
foreach (Table NewTable in TblCollection) { if (NewTable.IsSystemObject == false) { string ObjectName; Scripter NewScripter = new Scripter(); DataRow dr = dbTable.NewRow(); ... 2 Jul 2008 10:52

SQL Wishes , Correct path
Hello, since sqlwish(a)microsoft.com is gone , anyone knows where people can set new wishes for future versions of SQL Server ? all links i searched does not work thank you Bassam ... 2 Jul 2008 06:46

query on max()
Hi, In a table I have the value like following: X_CREATE_SOURCE INTEGRATION_ID Sales SR0000000082 Sales SR0000000083 Sales SR0000000084 Sales SR0000000085 Sales SR0000000086 Sales SR0000000087 Sales 23000.0000084 Sales 220000.000084 Sales 13000000.0084 Sales 5600000.00084 when I r... 2 Jul 2008 13:58