Viewing 15 posts - 13,381 through 13,395 (of 26,486 total)
I agree with the both of the above regarding the use of varbarnary(max) or filestream.
Yes, you could also store a pointer to a file on disk.
There are pros and cons...
March 28, 2012 at 7:51 am
patrickmcginnis59 (3/28/2012)
Ninja's_RGR'us (11/23/2011)
Dev (11/23/2011)
(XYZ is still waiting for thanks :hehe:).
The most prolific poster post because it's the RIGHT thing to do. Not to get anything of any...
March 28, 2012 at 7:49 am
Eswin (3/28/2012)
Hi Lynn,Thanks a lot for your help.
Actually im importing the values using import export wizard.
If you save the package, you can edit it with BIDS to make the...
March 28, 2012 at 7:16 am
Jeff Moden (3/27/2012)
Just remember that none of these tools guarantee a good design. The...
March 27, 2012 at 4:32 pm
Okay, one customer, many orders; where do you want to store the customer information, in the customer table or the order table?
March 27, 2012 at 4:23 pm
Lunch/work back for a bit.
Okay.
Let's think about the relationship between Customers and Orders. How many orders could a customer have?
March 27, 2012 at 3:46 pm
Here is a link that covers what I was talking about regarding the master database: http://msdn.microsoft.com/en-us/library/ms191488.aspx.
March 27, 2012 at 2:31 pm
Aty01 (3/27/2012)
so whatam i looking for
How are you going to related the customer table to the orders?
Now to discuss normalization. If you store customer information in both the order...
March 27, 2012 at 12:18 pm
SQLRNNR (3/27/2012)
Lynn Pettis (3/27/2012)
SQLRNNR (3/27/2012)
Stefan Krzywicki (3/27/2012)
Lynn Pettis (3/27/2012)
David Burrows (3/27/2012)
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
And No 😀
And the gentleman from the UK WINS!
That's the best part...
March 27, 2012 at 12:15 pm
ColdCoffee (3/27/2012)
Can we get sample data please?
And expected results based on the sample data.
March 27, 2012 at 12:14 pm
SS999 (3/27/2012)
I will make sure to post in a right way next time. Apologies!!!
None needed. Now that we know we are dealing with SQL Server 2005, we just make...
March 27, 2012 at 12:12 pm
SQLRNNR (3/27/2012)
Stefan Krzywicki (3/27/2012)
Lynn Pettis (3/27/2012)
David Burrows (3/27/2012)
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
And No 😀
And the gentleman from the UK WINS!
That's the best part about milestone posts,...
March 27, 2012 at 12:11 pm
Aty01 (3/27/2012)
you need to store it with order so that they know whos order it is
Not necessarily. This information is also stored in the customer table, correct?
March 27, 2012 at 12:10 pm
MyDoggieJessie (3/27/2012)
Thanks for the hints, I never bothered attempting CTE's for this...definitely something to try - In your example though, where is dbo.Numbers coming from?
Looks like a tally table. ...
March 27, 2012 at 12:07 pm
Viewing 15 posts - 13,381 through 13,395 (of 26,486 total)