Viewing 15 posts - 706 through 720 (of 3,348 total)
The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.
That tool is specifically built for this...
March 2, 2016 at 12:45 pm
IBeDatMan (3/2/2016)
I won't need any specific fields, so in place of selecting certain fields I would use *.
No, please don't. That wastes bandwidth between the server and the client, it...
March 2, 2016 at 12:44 pm
My first option would be to change the process that reads the rss feed to not read duplicates. I know nothing about rss readers and rss feeds, but I assume...
March 2, 2016 at 12:40 pm
szejiekoh (3/2/2016)
March 2, 2016 at 12:27 pm
IBeDatMan (3/2/2016)
Hey Phil - the source data doesn't seem to be in any particular order, just random...although it might be on date but it is not arranged by customer.
I don't...
March 2, 2016 at 8:53 am
It should work if you remove the COUNT from the SELECT list. If it doesn't, then perhaps post your code (plus a full repro script - i.e. CREATE TABLE statements...
March 2, 2016 at 8:50 am
Talvin Singh (3/2/2016)
is this an effective way of batching?
If you ask that from a logistic point of view, then I have no idea.
But if the logistical experts of your company...
March 2, 2016 at 8:39 am
Grant Fritchey (3/2/2016)
March 2, 2016 at 8:23 am
If this was a fact table with hundreds or thousands of inserts per second, I would be concerned about the impact of the additional page splits.
For a lookup table, though,...
March 2, 2016 at 8:19 am
tony28 (3/2/2016)
For example I need get top 5 like result below for two columns ( this is after night...
March 2, 2016 at 4:42 am
Hi Steve,
In your case, you and your partners are the domain experts. And even if your partner cannot answer the questions, it can help to get in a sort of...
March 2, 2016 at 4:34 am
Ed Wagner (3/2/2016)
Nice catch, Hugo. The first one with VARCHAR being the problem is one I still don't get, but the TRY_CONVERT bring the problem makes sense.
TRY_CONVERT was introduced...
March 2, 2016 at 3:45 am
patrick.mccausland (3/2/2016)
Got the same result, an errorTried SELECT TRY_CINVERT(FLOAT, 234523) and got
Msg 195, Level 15, State 10, Line 2
'TRY_CONVERT' is not a recognized built-in function name.
Try running it on SQL...
March 2, 2016 at 3:24 am
jiken (3/2/2016)
SELECT TRY_CONVERT(VARCHAR(1), 234523)
An error
Msg 195, Level 15, State 10, Line 1
'VARCHAR' is not a recognized built-in function name.
When execute...
March 2, 2016 at 3:23 am
Fair enough. It's not uncommon to have to import stuff looking like that comning from external sources. The first part of my reply (Google "Unpivot sql server") should help with...
March 2, 2016 at 3:15 am
Viewing 15 posts - 706 through 720 (of 3,348 total)