Viewing 15 posts - 1 through 15 (of 568 total)
Hello,
If you are not getting any errors then …. on a data load process that I recently worked on, the Import SPs logged their completion to a Central Table. If...
August 29, 2009 at 1:42 pm
Hello,
You could try replacing the Right Function with the following:-
substring(firstname, CharIndex(' ', firstname)+1, 200)
Note that this code assumes a first name is never longer than 200 characters.
Regards,
John Marsh
July 15, 2009 at 2:56 am
Hello again,
Did you try setting up a Mapped Login when creating the Linked Server?
Also do you get any Login Errors reported in the SQL Server Logs on the Branch...
July 14, 2009 at 5:27 am
Hello again,
Did you manage to get the query working Okay, or are you still having problems?
Regards,
John Marsh
July 14, 2009 at 4:15 am
Hello,
May be take a look at this MS Article:-
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Regards,
John Marsh
July 14, 2009 at 3:50 am
Hello,
Just to check a couple of things:-
- Are you experiencing this issue when trying to create a Linked Server to your Branch SQL Server from your Server SQL Server?
- Which...
July 14, 2009 at 3:08 am
Hello
Could you please post the Error Number and State as these help in diagnosing the root cause of the issue?
Regards,
John Marsh
July 14, 2009 at 2:33 am
Hello,
There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.
Regards,
John Marsh
July 12, 2009 at 10:59 am
Hello,
I don’t understand exactly your question but when ANSI_Nulls is On, then direct comparison of Null values do not return True.
May be look at the Books Online Topic “SET ANSI_NULLS...
July 12, 2009 at 7:57 am
Hello,
I suspect you want to be using CharIndex to find the location of the Space and then SubString to extract the Firstnames.
So may be something along the lines of:-
Select
lastname,
case when...
July 12, 2009 at 7:19 am
Hello,
Would SQLH2 be the kind of thing that you are after?
Please see http://www.codeplex.com/sqlh2
Regards,
John Marsh
July 11, 2009 at 10:08 am
Hello,
I have had to do the same kind of thing myself and what we chose to do was, to pre-process the data with a .Net Assembly to split the names,...
July 11, 2009 at 9:51 am
Hello,
Obviously I don’t know the structure of your DB, but would it not be possible to somehow replace the Cursor and Dynamic SQL with a Join on the NoSeriesMaster_Prefix table?
Regards,
John...
July 11, 2009 at 9:42 am
Hello,
Would it be possible to move this information in to a Data Warehouse, which would be better suited for analysis and reporting purposes. If the DW was on a separate...
July 10, 2009 at 9:38 pm
Hello,
I would choose side-by-side in this case.
May be take a look at this MSDN article regarding points to consider for the upgrade:-
http://msdn.microsoft.com/en-us/library/cc966519.aspx
Regards,
John Marsh
July 10, 2009 at 8:36 pm
Viewing 15 posts - 1 through 15 (of 568 total)