Viewing 15 posts - 1,021 through 1,035 (of 1,409 total)
xmanletoy (6/27/2013)
Msg 1033, Level 15, State 1, Line 13
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless...
June 27, 2013 at 11:47 pm
To transfer data you can use BCP or SSIS (create from scratch or use import/export wizard from SSMS). These perform real good. Keep in mind the key-relations between the tables...
June 27, 2013 at 7:48 am
Again: what is the message in the SQL Server log of the instance you're connecting to? Even if the login failes not all the times, you should be able to...
June 27, 2013 at 7:41 am
Krishna1 (6/27/2013)
But if you see my query it has got differnt where clasues for the 2 query hence can not use roll up.
I overlooked that the WHERE clause is different....
June 27, 2013 at 7:34 am
You could shrink the LOG file when this has grown by a large one-time action. But if this (kind of) action is periodically recurring the LOG will grow back to...
June 27, 2013 at 5:24 am
Create a linked server connection and use a
SELECT ... INTO {linkedserver}.[{database}]..[{table}] FROM [{database}]..[{table}] WHERE statusflag = 0
Update the statusflag on the source table after the insert (perhaps include an inner...
June 27, 2013 at 5:18 am
Change the current schedule to match the execution times the reports needs to run. Create multiple schedules if you won't be able to solve it with just one schedule.
June 27, 2013 at 5:06 am
There could be several options you should check. I'm not sure if all options I list below are required/related nor if the list is complete because I've never dealed with...
June 27, 2013 at 4:32 am
Look in the SQL Server log of the instance you're trying to connect to. There should be a bit more specific error message, including a "severity" and "state". Depending on...
June 27, 2013 at 3:29 am
A value is nothing more then that; just a value. This is also applicable to currency. Every amount in currency just represents a decimal value independent of the currency.
Your application...
June 27, 2013 at 3:15 am
It depends on your "dodgy" data. Why is your data 'dodgy'?
One option is to drop the keys on the target, insert all data and recreate the keys. Perhaps a better...
June 27, 2013 at 3:01 am
Krishna1 (6/26/2013)
What i wanted was like cube or rollup is there a way to make single query rather than union
These functions are available in SQL Server (2008+). Take a look...
June 27, 2013 at 2:50 am
Add a rownumber to your resultset. Create the blocks of the resultset with the values in your interval table:
SELECT
...
WHERE {rownumber} > (SELECT low_value FROM interval_table)
AND {rownumber} <= (SELECT high_value FROM...
June 27, 2013 at 2:42 am
Duplicate post, add reply to http://www.sqlservercentral.com/Forums/Topic1467913-391-1.aspx
June 27, 2013 at 2:37 am
If you just want to combine the results of all three queries to one single result, you'll can use UNION ALL to put the three queries together. Make sure all...
June 27, 2013 at 2:02 am
Viewing 15 posts - 1,021 through 1,035 (of 1,409 total)