Viewing 15 posts - 8,701 through 8,715 (of 8,731 total)
Is this the right place to demonstrate how good is greater than evil, just by using SQL?
July 16, 2012 at 3:06 pm
dwilliscp (7/16/2012)
The insert fails.. due to too many parts... it shows "this.that.dbo.table_name" not what whas typed in "[this.that].dbo.table_name".
It's hard to know if you don't give the exact error, code and/or...
July 16, 2012 at 1:21 pm
One tip I could give you is to use the debugger to check you have the correct value in the sSQL variable.
The other thing I noticed is you wrote the...
July 16, 2012 at 9:49 am
This is a repeated post and was solved in here
http://www.sqlservercentral.com/Forums/Topic1329746-392-1.aspx
By the way, I made the same mistake as Stewart
July 16, 2012 at 8:12 am
To start with the suggestions, you can always use:
SELECT @@VERSION
to define the version of SQL Server you're working with.
In the other hand, bitwise operators will return an integer (the result...
July 16, 2012 at 7:38 am
IMHO the best way is to create a carriers table with the information needed and add a field column (Insert Celko's quote saying "columns are not fields":-D) for a...
July 16, 2012 at 7:00 am
How do you know if you should use @txt.att or @messaging.sprintpcs.com or something else?
July 14, 2012 at 3:17 pm
You're right, I got confused with the term as I haven't used it in a long time.
July 14, 2012 at 2:15 pm
I'm not sure what you're trying to do because there's no cursor in there.
You're updating a table in the worst way possible (well, there might be something worse).
To update the...
July 14, 2012 at 11:56 am
I believe that the correct answer to this question is the most popular answer in this community:
It depends.
Because it depends on the Operating System maximum.
July 13, 2012 at 6:55 am
This would make the trick. But as noted by others, formatting should be done on the front end.
DECLARE@Datedatetime
SET @Date = '20120523 18:03:12.523'
SELECT CONVERT( char(10), @Date, 101) + ' ' +...
July 12, 2012 at 7:47 am
In my experience, Smash would need a slightly different approach if he needs the total due for each contact, because Chris' query will only return the total from one sale.
UPDATE...
July 12, 2012 at 7:15 am
Have you tried a cross join on the same table?
SELECT a.product,
b.product
FROM ProductTable AS a
CROSS JOIN ProductTable AS b
WHERE a.product <> b.product
That will give...
July 10, 2012 at 2:04 pm
As they say, it's not clear to see exactly what's going wrong. But I believe that there's an extra column in your GROUP BY clause (or maybe there's another reason...
July 10, 2012 at 11:29 am
I'm not sure if it was a trick question or an easy question, but I followed my instincts on the way TRUNCATE works and got it right.
It's a good way...
July 10, 2012 at 7:23 am
Viewing 15 posts - 8,701 through 8,715 (of 8,731 total)