Viewing 15 posts - 2,611 through 2,625 (of 11,678 total)
OK, here some code using a tally table.
DECLARE @YearStartDATETIME2 = '2014-01-01 00:00:00';
DECLARE @YearEndDATETIME2 = '2015-01-01 00:00:01';
WITH CTE_Tally AS
(
SELECT TOP 8785 n = ROW_NUMBER() OVER (ORDER BY o1.object_id)-- 8784: 24 hours...
June 17, 2014 at 4:09 am
Sushant Yadav (6/17/2014)
Hi Koen,My issue is resolved I just changed query as follows
SELECT * FROM OPENQUERY([MySQL], 'CALL proc_clientdata(''2014-06-16'',''2014-06-16'','''','''','''');')
Glad to know you resolved the issue.
June 17, 2014 at 3:48 am
Just my 2 cents.
Wouldn't it be easier to just store the maximum entrydate you loaded in the last run.
Say you ran the initial load and the max entrydate is 2014-05-17.
Next...
June 17, 2014 at 3:38 am
Datetime only goes back to 1753 (which is for most business far enough in the past :-D).
Try using the datetime2 data type (that one goes back to the year 0).
June 17, 2014 at 3:35 am
Either check that the account that is used by the linked server has execute permissions on the stored procedure (I guess such a things exist in MySQL), or that metadata...
June 17, 2014 at 3:12 am
Can you issue a simple select statement through the linked server?
June 17, 2014 at 2:48 am
hoseam (6/17/2014)
Koen Verbeeck (6/17/2014)
In attachment is a screenshot of a 2012 installation (which is pretty much the same as for SQL Server...
June 17, 2014 at 2:31 am
hoseam (6/17/2014)
This SQL Server 2008 R2SQL Server 2008 R2 Express with Advanced Services just includes SQL Server Reporting Services (SSRS), not SSAS
Well, if you cannot install SSAS, it is pretty...
June 17, 2014 at 2:24 am
What version of SQL Server do you have? Express?
In attachment is a screenshot of a 2012 installation (which is pretty much the same as for SQL Server 2008R2).
June 17, 2014 at 2:23 am
dbowner role is a database role, while sysadmin is a server role. So it might be a instance-level task that the application wants to do.
June 17, 2014 at 2:00 am
Those are samples.
You install SSAS with the SQL Server installation media.
Just like you installed SQL Server itself. It's the same set-up, just a different checkbox.
June 17, 2014 at 1:53 am
Peter.Frissen (6/17/2014)
My problem is a bit more complex, I thought about this concatenation-solution but actually this colB is not one column but several columns. I could still concatenate the values...
June 17, 2014 at 1:51 am
Aaaaand back on-topic!
http://www.sqlservercentral.com/Forums/Topic1582030-391-1.aspx
June 17, 2014 at 1:49 am
ashalatha.cse76 (6/17/2014)
$data=array('order_id'=>$this->input->post('order_id'),
'order_name'=>$this->input->post('order_name'),
'cat_id'=>$this->input->post('cat_id'),
'sub_cat_id'=>$this->input->post('sub_cat_id'),
);
$this->db->insert('order_master',$data);
}
Actually this is my code which i usedto add theorders can u make changes in this how to do that
it will be helpfull for me please
Nope, sorry. First of...
June 17, 2014 at 1:49 am
ashalatha.cse76 (6/17/2014)
in where class ur comparing the ids in the table but where ur getting the association id
In the
SELECT values
FROM somewhere
part.
You actually have to fill in something yourself.
The code...
June 17, 2014 at 1:47 am
Viewing 15 posts - 2,611 through 2,625 (of 11,678 total)