5,308 reputation
11341
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 4 months
seen 9 hours ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc

SQL Server MVP


Sep
30
comment Database design for an online babyShop ,Toy shop
I think about Amazon. There if I'm buying Tea it might show up in "Grocery & Gourmet Food" or it might show up in "Home & Kitchen". Do you really think your customer wants to lose sales because a box of Lego is categorized as a "Boy" toy? I would think not. Therefore, I would think a Product could have multiple categories
Sep
30
comment Database design for an online babyShop ,Toy shop
You do not want to call a table Order unless you really want to escape the name every time you reference it
Sep
29
revised SSIS Get max value in column and create new column?
added 1206 characters in body
Sep
29
comment SSIS Get max value in column and create new column?
Providing specifics in your questions can never hurt the supplied answers.
Sep
29
answered SSIS Load using SQL Command
Sep
26
revised How I convert it to SQL Server please
added 190 characters in body
Sep
25
comment SSIS Get max value in column and create new column?
@GlenSwan Help me understand the concern. How will a poisonous record in A pooch the results?
Sep
25
revised SSIS Get max value in column and create new column?
added 2855 characters in body
Sep
25
answered SSIS Get max value in column and create new column?
Sep
25
comment SSIS Get max value in column and create new column?
Ah, so SourceA would show units sold over time. Source B shows RIGHT NOW. You need to only pull in what was sold for the last date and then pull all the inventory and mash that together where possible
Sep
23
revised Not able to create SSISDB catalog
Linked to Connect with other possible reason for failure
Sep
23
answered Not able to create SSISDB catalog
Sep
23
comment 700 million row mixed text/numeric data - read-only in a single table
Maybe they confused SQL Server with Access
Sep
23
comment Not able to create SSISDB catalog
As noted over on stackoverflow.com/questions/25971803/…, It appears you do not have access to that part of your SQL Server installation (that or the account that is attempting to create it does not have access). Can you confirm/deny this?
Sep
23
comment Friendship and Messages in a MySQL table relational schema problem (concerning big data manipulation)
What is the advantage, in your mind, of using the file system for storing anything?
Sep
23
reviewed Reject and Edit suggested edit on convert string allow null col to int?
Sep
23
revised convert string allow null col to int?
The formatting didn't pick up for the C# after my list
Sep
22
revised SSMS 2014 (and 2012) CTRL+TAB requires pressing enter
Since I was looking up the bindings, figured a screenshot wouldn't hurt the question.
Sep
22
comment not able to create SSISDB catlog in Sql server 2014
It appears you do not have access to that part of your SQL Server installation (that or the account that is attempting to create it does not have access)
Sep
22
comment Alternatives for a LEFT OUTER JOIN query
Have you thought about RIGHT OUTER JOIN...