If you have no concern with what tiem the entered_datetime field is just want to see for day then try this.DATEADD(d,DATEDIFF(d,0,appt.entered_datetime),0) between DATEADD(d,DATEDIFF(d,0,@start_date),0) and DATEADD(d,DATEDIFF(d,0,@end_date),0)
2004-05-06
Hello spongemagnet, quote: "For testing purposes, is there a way to corrupt a db via an .ASP page over http?" don't get me wrong, but I hope there isn't an (at least easy) answer to your question! Cheers, Frank
2003-06-12
1 reads
quote: Sharpe and Treynor = huh? Keep wishing, you never receive a request to implement this! Quite dry theoretical, statistical stuff, but one of the major point when is comes to performance and mutual funds. BTW, what runtime or reaction time is this expected to have? Cheers, Frank
2003-06-05
1 reads
what I do if I want to clean: - change name of SP,table,view with "delete_" string in front- after you are SURE you have talked this thru - make sure that your developers have a list of those changed names. - if no one complains for a given time period(that depends on your database type […]
2003-06-03
2 reads
When you create a linked server, you can make the name of the server anything you want (separately from the actual network name of the server). You can make the name a logical name rather than a physical name. This will help you if you are migrating from development to production (on different servers) but […]
2003-06-02
Don't mess with the system tables. Enterprise Manager has a GUI for modifying server logins and roles, and database users and roles. Click to the Server --> Security --> Logins for Server Logins. Click to the Database --> Users for Database Users. Right click on the Database and select Properties. Then click through the tabs […]
2003-05-29
AAAAAAAAAAAAAAAAAAAAAAAGH!!! Apparently, somehow, the SQL Server on my box was not set for more than the local user. The network person saw that on the Domain and opened up my computer to all. Where is that? Where did I miss that? I don't even know when I changed it but now the person can connect […]
2003-05-29
i have been going through the master database trying to see what all the tables do. like the system messges table has 4333 different kinds of sql messages that can be displayed.
2003-05-29
i wanted to see if database roles and server roles had a menu to do selection. ie any kind of control settings that use a GUI.
2003-05-29
Look in BooksOnline for Aggregate functions: MIN(), MAX(), AVG(), SUM(), COUNT()...
2003-05-29
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers