Viewing 15 posts - 196 through 210 (of 330 total)
Elliott W (9/15/2009)
September 15, 2009 at 5:40 pm
kjs714 (9/15/2009)
September 15, 2009 at 4:59 pm
Yep - go with int like I originally said 😀
September 15, 2009 at 4:45 pm
Elliott W (9/14/2009)
There is also RIGHT but you take a HUGE processing hit to do it so I'm not going to demonstrate it.
I must say I found the complete opposite...
September 15, 2009 at 4:15 pm
No worries.
Bear in mind smallint will only do you for up to 32,767 records before the IDENTITY field wraps round to -32,768.
Use smallint only if you are *sure* the DB...
September 15, 2009 at 4:05 pm
I've just gotten to the end of a long project doing exactly that. And it's not an easy thing to do. I started out about 2 1/2 years ago, thinking...
September 15, 2009 at 3:57 pm
look at the help for CONVERT and see if you can provide a style code.
September 15, 2009 at 3:52 pm
If you have the option to use the CLR for that, then do.
string[] parts = String.Split(input, new char[] { '-' });
return (parts.Length > 3) ? parts[3] : string.Empty;
September 15, 2009 at 3:51 pm
mm (9/15/2009)
Thanks for the advice Matt, but I think I just got hungry reading your post...
-Michelle 😉
Heh - snap...
September 15, 2009 at 3:44 pm
SELECT DISTINCT CRM_Orders.TRANSACTION_ID,
CRM_StatusCodes.USER_STATUS,
...
September 15, 2009 at 3:43 pm
Ok - it sounds to me like you want to know about how to use AND and OR.
This example is entirely silly - but there you go:
If I want to...
September 15, 2009 at 3:36 pm
I have two things to say:
1) You seem to have all your primary keys as Char() fields. Unless there's a compelling reason for that, go with int, or bigint if...
September 15, 2009 at 2:53 pm
Chad Crawford (9/15/2009)
September 15, 2009 at 1:55 pm
Lynn Pettis (9/15/2009)
September 15, 2009 at 11:18 am
Lynn Pettis (9/15/2009)
That was not obvious based on your original post. There was nothing there to indicate how many rows were to be deleted.
He did say there was a...
September 15, 2009 at 9:30 am
Viewing 15 posts - 196 through 210 (of 330 total)