Viewing 15 posts - 76 through 90 (of 93 total)
the answer is no. and you are better off doing
select sum() from, as suggested above, but cast to money at the end.
March 22, 2007 at 6:49 am
If you have the drive mapped, then go to Server Objects, right click on backup devices and create a new one from File.
I don't know why management studio only shows...
March 22, 2007 at 6:42 am
March 22, 2007 at 6:29 am
that happens when you are importing the table for the first time, 'cause it does not exist. I just tried it. Second time around, the table already exist and you...
March 22, 2007 at 6:25 am
may be this link will help understand: http://msdn2.microsoft.com/en-us/a912f2a0(VS.71).aspx
March 21, 2007 at 8:18 am
Luis, check the BOL for the value range for FLOAT (
- 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308
), then review the source data to find out if they are...
March 21, 2007 at 7:58 am
Check this SP out
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:...
March 21, 2007 at 6:34 am
Well, the question is Why you cannot query the datasource if you have the a Linked Server.
You can always do this:
select *
into NEW_TABLE
from
openquery
March 21, 2007 at 5:41 am
I had to re-install SQL 2005 to get rid of this issue.
March 21, 2007 at 5:34 am
Try viewing the email in Text and HTML format and see there is any differece (in Outlook). When you open the email go to Format and the options are there....
March 15, 2007 at 11:01 am
Have you use INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS before? Well you can create a script to select from the TABLE schemas the tables you need, then the columns. Build a couple of list and pass...
March 15, 2007 at 10:14 am
I have seen INSERT working faster than DELETE so, I will:
1) copy monster_table to temp_table
2) script the table to CREATE first then DROP and build a script that will do...
March 15, 2007 at 9:54 am
A zettabyte is one heck of a number (2^70), but still less than a yottabyte (2^80).
March 14, 2007 at 6:31 am
Your inquire is very general. However, make sure to populate the list box with unique values. If populating it with a data set, make sure the SELECT in your query...
March 14, 2007 at 6:07 am
Try this
select *
from table1
where column1 in(value_a, value_b)
UNION
select *
from table1
where column2 in(value_a, value_b)
March 13, 2007 at 12:28 pm
Viewing 15 posts - 76 through 90 (of 93 total)