Viewing 15 posts - 5,206 through 5,220 (of 8,731 total)
Why don't you define your column as a date data type in your flat file connection and save yourself some problems? Your destination column should be a date data type...
February 19, 2015 at 9:18 am
My bad, I didn't review the formula correctly.
The problem is that you're counting characters before the first X and you're using that length to chop the last part which isn't...
February 18, 2015 at 3:12 pm
If full text search is not a possibility for you (but hopefully it will), you could try an alternative by splitting the names/phrases into separate words to validate that at...
February 18, 2015 at 2:52 pm
Drop the RTRIM().
February 18, 2015 at 2:41 pm
I wouldn't say that a plan is better than the other one, just different. The only difference is that in one plan it's a single statement and in the other...
February 18, 2015 at 2:27 pm
Read the following article regarding CROSS TABS. [/url]
This is an example on how to do it.
SELECT [Date/Time],
MAX( CASE WHEN Tag = 0 THEN Value END) Tag0,
...
February 18, 2015 at 11:52 am
An experienced developer that likes to work with heaps in SQL Server is as good as a newbie.
I guess the correct option would be to prevent her on what you're...
February 18, 2015 at 9:07 am
A suggestion would be not to have the concatenated groups on the view and build only those needed.
If you have your view with each group on a single row, you...
February 18, 2015 at 8:31 am
Maybe you'd like to check a different method to unpivot.
http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
February 18, 2015 at 8:25 am
Lowell's solution is very complete, but if you only need one part of the string, it seems as an overkill to me.
WITH MyCTE([jmaPartShortDescription])
AS
(
SELECT '5.625X11.25-2.875x8.5 ' UNION ALL
SELECT '5.625X35.25-2.875x32.5 ' UNION...
February 17, 2015 at 9:35 am
Just to give an example on what can be done. But I agree that future replies should be done on a new thread.
CREATE PROCEDURE _SearchCustomer
@IdClient INT,
...
February 17, 2015 at 9:06 am
SQLRNNR (2/16/2015)
Grant Fritchey (2/16/2015)
Lynn Pettis (2/15/2015)
TomThomson (2/14/2015)
Lynn Pettis (2/14/2015)
TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Tom, must say that I...
February 16, 2015 at 9:43 am
You can look for some in here
I've read that Trascender is a good option to study.
February 16, 2015 at 9:28 am
Check the following page from BOL: https://msdn.microsoft.com/en-us/library/ms187833.aspx
In the Sample XML Format Files section (bottom of the page):
F. Importing fixed-length or fixed-width fields
The following example describes fixed fields of 10 or...
February 16, 2015 at 7:55 am
Basically, you want to divide the proportion by the running total of proportion.
Quick question. How do you define the order? I think I know the answer but want to be...
February 14, 2015 at 7:55 am
Viewing 15 posts - 5,206 through 5,220 (of 8,731 total)