Viewing 15 posts - 8,641 through 8,655 (of 13,876 total)
If the layout for each client is the same and it's a one-spreadsheet-per-client thing, it would seem that SSIS is quite a good fit.
The trick, obviously, is in the design...
March 2, 2015 at 11:01 am
Or this?
select Customer
,Type
,DueDate1
,DueDate2
from dbo.myTable mt
where...
March 2, 2015 at 8:38 am
Is this problem specific to synonyms, or are you having problems with direct cross-database references too?
February 28, 2015 at 6:25 am
Have you checked the execution plan? Are there any unexpected implicit conversions happening?
February 28, 2015 at 6:24 am
* while executing this query im getting error. (like varchar cant convert to numberic)
* Here I have no clue in which column it is
* also dont know which row...
February 27, 2015 at 4:57 am
Works fine for me. Check the compatibility level of the database you are executing it in.
February 27, 2015 at 4:52 am
Not exactly what you want, but in SSMS you can right-click on a proc in Object Explorer and select 'View Dependencies' to see what depends on the proc (or what...
February 27, 2015 at 4:00 am
Not that link. The one on the word 'here'.
February 26, 2015 at 10:16 pm
I am finding your question difficult to follow. Can you take a look at the first link in my signature and then provide your consumable sample data, with DDL and...
February 26, 2015 at 6:58 am
Did you check the link which I provided in my previous post?
February 26, 2015 at 6:55 am
Have a look here.
February 25, 2015 at 10:32 am
PHYData DBA (2/25/2015)
GilaMonster (2/25/2015)
PHYData DBA (2/25/2015)
https://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx
A heap is a table without a clustered...
February 25, 2015 at 9:15 am
gopi6417 (2/25/2015)
I don't know exactly.Could you please tell the syntax on Oracle.
The poster realised after posting the original question that they were in the wrong forum.
So if you are providing...
February 25, 2015 at 5:41 am
gopi6417 (2/25/2015)
select replace(CONVERT(VARCHAR(11),GETDATE(),106),' ','/')
Does this syntax work on Oracle?
February 25, 2015 at 5:33 am
Thank you Hugo. Looking forward to the rest of the series.
February 25, 2015 at 3:00 am
Viewing 15 posts - 8,641 through 8,655 (of 13,876 total)