Programming SQL

Help with DateTimeOffset and Floor/Ceiling?
I have a DateTimeOffset value, and want to get the DateTimeOffset "floor" of the day (12:00am) and the "ceiling" of the day (11:59:59pm) and am having trouble creating a concise statement that I can put into a Where clause. Can anyone help with syntax on that? Thanks. ... 25 May 2010 16:53

concatenating
Hello: Below is my query, and I need help with concatenating. I am trying to get each field in this query to be concatenated together. But, the results of running this query displays a huge space between the field "CMTrxNum" and "CASE WHEN TRXAMNT....". How do I get rid of this spacing? SELECT '20000... 25 May 2010 14:40

How to pivot this in SQL 2K
Need help to pivot the following:- counter type AMOUNT ------- ---- ------- 1 A 10 1 A 10 2 A 20 3 A 30 3 A 30 4 A 40 5 A 50 5 A 50 1 B 10 2 B 20 3 B 30 3 B 30 3 B 30 4 B 40 5 B 50 5 B 50 5 B 50 Result :- A B TOTAL - - - 1 $$ $$ $$ 2 $$ $$ $$ 3 $$ $$ $$ 4... 25 May 2010 17:59

How to pivot this
Need help... how to pivot the following:- counter type AMOUNT ------- ---- ------- 1 A 10 1 A 10 2 A 20 3 A 30 3 A 30 4 A 40 5 A 50 5 A 50 1 B 10 2 B 20 3 B 30 3 B 30 3 B 30 4 B 40 5 B 50 5 B 50 5 B 50 result:- A B TOTAL - - - 1 $$ $$ $$ 2 $$ $$ $$ 3 $$... 25 May 2010 16:53

Checking if a view is being used
Hi we have discovered a view that will cause a problem when we next upgrade our database. I need to find a way to tell if it is being used. I have checked dependencies and there is none but that won't tell me if the application is using it or not. With stored procedures, if I want to know if they are being... 25 May 2010 13:33

Incorrect Result
I have a customer with SQL 2000. There is a table MEMBER with a datetime field [FINANCIAL TO] and a view vwFULLMEMBERDETAIL that joins the MEMBER table with a number of others. The view includes the field [FINANCIAL TO]. With ADO.NET the [FINANCIAL TO] field is updated using a standard UPDATE statement. Almost... 24 May 2010 23:27

Thanks a lot
I was trying to do this a long time ago Alex Danger wrote: The account that sql server runs under probably does not havepermission to use 04-Jul-07 The account that sql server runs under probably does not have permission to use that particular folder. Try opening up the services dialog (type services.msc ... 24 May 2010 17:57

Select column with highest value
Hi, How do I get the desired result for the following sample Table1 data: Source Table: Table1 Columns: Mukey State L11 L12 L21 L22 m657753 AL 8.00 0.00 5.00 1.00 m657753 TN 0.00 1.00 3.00 ... 25 May 2010 01:35

how SIN, COS and TAN works on sql server
I ran this: declare @f float set @f = 30 select sin(@f) and got -0.988031624092862 What is this? ... 24 May 2010 11:15

translate string to binary / binary to string
Sql server 2005: Is there a simple way to translate binary to string and vice versa? Example: 011001100110111101101111 = 'foo' 'foo' = 011001100110111101101111 Thanks in advance ...! Bill ... 24 May 2010 11:15