Viewing 15 posts - 2,881 through 2,895 (of 6,036 total)
Peso (9/1/2008)
Sergiy, that will not work for January 1st dates.However, you are not that far from a working suggestion.
Thanks, Peso, it's good to know there is some tester always around...
September 1, 2008 at 7:05 pm
Count number of whole years between the date and "zero date" (1/01/1900) and add this number +1 to "zero date".
It's gonna be beginning of next year.
Use datetime functions for it.
Same...
September 1, 2008 at 7:35 am
Yes, there are s4ch ones, and thry're installed on your workstation.
Start SQL Profiler against one not busy server, desirably the one where there is nobody else but you.
Go to Entrprise...
August 31, 2008 at 1:08 am
Perfect target for SQL injection!
If you think you product may be interesting for somebody one day you better:
- check that @ColumnName matches one of COLUMN_NAMEs in
INFORMATION_SCHEMA.COLUMNS...
August 29, 2008 at 7:23 pm
Then you need just read what's posted, fight your laziness and open BOL ("help" for SQL Server, F1), find topic about OBJECTPROPERTY and find parameter TableHasForeignRef next to TableHasForeignKey.
I guess...
August 28, 2008 at 6:26 pm
Arthur.Lorenzini (8/28/2008)
but it really isn't a stand alone table because it referenced by the employee table.
Who says it's referenced from the employee table?
What is the evidence that such reference exists?
August 28, 2008 at 4:32 pm
Arthur.Lorenzini (8/28/2008)
Close but is there way to add in if it's referenced by a foreign key? Example:Customer has no foreign key but is referenced by the Employee table.
Referenced by what?
August 28, 2008 at 3:55 pm
I'd use it for cyclic multiplying.
SELECT @product = @product * Value
FROM Table
Just like for string concatenation.
August 28, 2008 at 3:42 pm
rbarryyoung (8/28/2008)
Hmmm, I can't see it either Sergiy. Unless you mean with Dynamic SQL?
Well, if to copy Excel tables to SQL Server then yes, you'll need dynamic SQL and...
August 28, 2008 at 2:48 pm
karthikeyan, it's a good test of how did you learn the lesson about Tally table.
Apparently, not very good. Because you cannot recognize the case where it may be use.
August 28, 2008 at 2:13 pm
You probably need to open help on Excel (F1) and read what PRODUCT is.
August 28, 2008 at 4:50 am
I don't see any implementation of PRODUCT in your query.
August 28, 2008 at 2:10 am
Why don't you make this query a view and call that view via "Import data -> database query" in Excel?
It will allow users to refresh data instantly with single mouse...
August 27, 2008 at 7:00 pm
You welcome.
It's easy to give fast response on so well prepared question as yours one. 🙂
Another hint regarding this query:
if it's used much make sure you've got clustered index on...
August 27, 2008 at 6:27 pm
Any reasonable explanation why are you trying to upload column headers?
WITH
( FIRSTROW = 2,
August 27, 2008 at 6:20 pm
Viewing 15 posts - 2,881 through 2,895 (of 6,036 total)