Viewing 15 posts - 4,531 through 4,545 (of 8,731 total)
Is '2015/01/01' a fixed value for the query or is it a value that can change from one row to another?
If it's a scalar value, you should change your query...
August 4, 2015 at 8:54 am
SQLRNNR (8/4/2015)
Luis Cazares (8/4/2015)
Companies and government can hire aliens in the USA. However, it's harder to get a job because they will prefer citizens who know the culture.
That and a...
August 4, 2015 at 8:35 am
Grant Fritchey (8/4/2015)
xsevensinzx (8/3/2015)
August 4, 2015 at 8:32 am
SQLRNNR (8/4/2015)
Ed Wagner (8/4/2015)
Eirikur Eiriksson (8/4/2015)
djj (8/4/2015)
Ed Wagner (8/3/2015)
SQLRNNR (8/3/2015)
whereisSQL? (8/3/2015)
djj (8/3/2015)
PunishmentSpank
Flog
Lash
Whip
Tail
Head
Duck
Goose
August 4, 2015 at 8:20 am
This can be a complicated issue and it's called relational division. You can search the web about it and you'll find lots of information to learn about it.
Your sample data...
August 4, 2015 at 8:13 am
You're right, SQL Server 2014 has a new cardinality estimator which will change the behavior of some queries.
That said, you can't change a LEFT JOIN for an INNER JOIN. They're...
August 4, 2015 at 7:27 am
nsca.dev (8/4/2015)
I tried this " select (CONVERT(VARCHAR(MAX),(convert(varbinary(max),body)))) from Table " and I got 86 records whereas there are more than 2000 records...
August 4, 2015 at 7:21 am
Companies and government can hire aliens in the USA. However, it's harder to get a job because they will prefer citizens who know the culture.
August 4, 2015 at 7:13 am
Why? What do you expect to get? The varbinary is the correct way to keep an image on SQL Server.
EDIT: You're getting all the question marks because you use varchar...
August 4, 2015 at 7:05 am
ben.brugman (8/4/2015)
Gazareth (8/4/2015)
Either of these should work, but you're back to the problem of determining column names:
Yes back to the problem of determining the column names. And then de solution...
August 4, 2015 at 6:59 am
I would go with the second option because it allows you more flexibility as you don't depend on traversing the hierarchy using the same route each time. I'm assuming that...
August 3, 2015 at 1:54 pm
Here's an example on how you can do it, you might need to adapt the code as necessary. This article explains the method used: http://www.sqlservercentral.com/articles/comma+separated+list/71700/
SELECT DISTINCT
task_id,
...
August 3, 2015 at 1:44 pm
Check this for examples on how to solve the problem:
http://stackoverflow.com/questions/10591044/how-write-sql-to-select-the-maximum-value-in-each-group
August 3, 2015 at 12:54 pm
If you only need the ITEM_ID, you can use INTERSECT AND EXCEPT.
SELECT ITEM_ID
FROM @t4 t4
JOIN @t2 t2 ON t4.CAT_ID = t2.CAT_ID
WHERE t2.CAT_NAME = 'WHITE'
INTERSECT
SELECT ITEM_ID
FROM @t4 t4
JOIN @t2...
August 3, 2015 at 9:42 am
Wayne West (8/3/2015)
Wellington also had the advantage of having the gentleman English magician Jonathan Strange, at least according to a recent documentary that I saw on the subject. 😛
Is he...
August 3, 2015 at 8:47 am
Viewing 15 posts - 4,531 through 4,545 (of 8,731 total)