Viewing 15 posts - 2,086 through 2,100 (of 7,429 total)
Take a look at this recent thread and see if it helps.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=107880
March 25, 2004 at 6:22 pm
Good luck and does sound like a far better choice.
March 25, 2004 at 6:15 pm
What are you using to view them and how are you handling you insert specifically?
March 25, 2004 at 6:14 pm
This should do it but might be a better way I didn't see.
SELECT
x1.master,
x1.type
FROM
tblX x1
INNER JOIN
(
SELECT
x2.master,
x2.type t1,
x3.type t2
FROM
tblX x2
INNER JOIN
tblX x3
ON
x2.master = x3.master
WHERE
x2.type...
March 25, 2004 at 6:11 pm
FIrst you really need to normalize this table by moving Part_No into another table with Order_No and any other field to use as a key to tie back.
However that said...
March 25, 2004 at 5:58 pm
Not sure and I don't have a test system running here at the house right now.
March 25, 2004 at 5:51 pm
No not directly using a variable to a select statement. You could do in an SP an IF for each table and run the right query against the right table...
March 25, 2004 at 5:50 pm
Is the SQL server on a different domain or are these boxes setup local accounts only and is the SQL server defiend as Windows Accounts only or SQL and Windows...
March 25, 2004 at 5:46 pm
I assumed you meant 1st day being the start of week one and each week being a new week. If not you may be able to go from here.
CREATE FUNCTION...
March 25, 2004 at 5:43 pm
Your query doesn't look right at all. Can you post you table structure and explain you goal, looks like you want
Time,
Density,
and Sum([fn_botsort].[avg_thick])
But there is no alias fn_botsort which...
March 25, 2004 at 5:36 pm
COnsider that SQL Agent can actually be run under local system accoutn and talk thru a trusted connection. However I am not sure if anything else goes on behind the...
March 25, 2004 at 5:22 pm
Sorry there but as for unique rows I would have to say yes.
The reason is if you need to delete rows the compiler is unable to distinguish between two...
March 25, 2004 at 4:58 pm
Thank you for posting back your answer. Will maybe help someone in the future. Sorry I wasn't much help but now I know.
March 25, 2004 at 4:49 pm
Have you tried reconfiguring or reinstalling service to see if corrects? Unfortunately too new to have much in KB on it and I have not seen this before.
March 25, 2004 at 12:55 pm
The stats for a composite index are based on the first item in the index, So place you most unique first to the least unique and it should. You still...
March 25, 2004 at 12:22 pm
Viewing 15 posts - 2,086 through 2,100 (of 7,429 total)