Viewing 15 posts - 7,171 through 7,185 (of 9,715 total)
Quick note that has nothing to do with resolving your problem, but could save you a lot of typing. You don't have to Declare each variable on a separate statement....
October 19, 2010 at 5:49 am
The only thing I can think of at this point is either that the GUIDs already exist in the table that you're trying to load the Excel sheet into or...
October 19, 2010 at 4:31 am
Please start a new thread for your question. Most people consider this one resolved and won't answer.
October 19, 2010 at 4:28 am
Stefan Krzywicki (10/18/2010)
Which is great and correct for light, but pigment is exactly the opposite. White is an absence of all pigment, black is a combination of all pigment.
Not quite...
October 19, 2010 at 4:23 am
Stefan Krzywicki (10/18/2010)
The Dixie Flatline (10/18/2010)
I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?
My opinion is that brothers...
October 18, 2010 at 12:42 pm
The Dixie Flatline (10/18/2010)
I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?
How about scientific fact?
Color is just the...
October 18, 2010 at 12:41 pm
Brandie Tarvin (10/18/2010)
As far as your primary key violation goes... Is the GUID in the Excel file or are you defaulting on that?
Please answer this question.
October 18, 2010 at 11:46 am
Steve Jones - SSC Editor (10/18/2010)
Aren't most trees green?
Ahem. Trees are brown (some are white). The leaves (or needles) are green.
There's a difference. @=)
EDIT: Opps. Missed your rebuttal. Still stand...
October 18, 2010 at 11:31 am
Adding an aggregate to previously-coded statements and forgetting to add a Group By.
DOH.
October 18, 2010 at 10:36 am
Which version of SSRS? 2000, 2005, or 2008?
October 18, 2010 at 8:56 am
No. You don't convert. Just create the datatype as type Nvarchar(Max). It's really that simple.
EDIT: SQL Server will known how to handle your datatype and will only use the amount...
October 18, 2010 at 8:36 am
I did read your first post. You didn't say anything about "passes" in that post. Hence the reason I asked the question.
As far as your primary key violation goes... Is...
October 18, 2010 at 8:33 am
sqldba_icon (10/18/2010)
October 18, 2010 at 8:23 am
Viewing 15 posts - 7,171 through 7,185 (of 9,715 total)