Viewing 15 posts - 4,771 through 4,785 (of 7,191 total)
Amit
The row(s) you are inserting contain values that already exist in the table for the column(s) that make up your primary key. Search the internet for PRIMARY KEY if...
February 2, 2012 at 4:29 am
Greg
Your FROM clause is simpler than that:
FROM table t1 INNER JOIN table t2
ON t1.hour = t2.hour + 1
(I've kept it simple since all your sample data is for the same...
February 2, 2012 at 4:26 am
Amit
That's interesting. Do you have a question?
John
February 2, 2012 at 3:51 am
Do a self join on Hour = Hour + 1 and subtract one Monday from the other.
John
February 2, 2012 at 3:40 am
Jon
I'm afraid I don't know what you mean. Please will you post a CREATE TABLE statement along with some sample data from the table? One problem I can...
February 1, 2012 at 6:16 am
Ram
OK, I don't know why you're getting those messages, then. Sorry.
John
February 1, 2012 at 5:04 am
Flex? Never heard of it. But create a stored procedure on the SQL server and it's easy to call from any language. The code you posted looks...
February 1, 2012 at 3:55 am
I would seriously recommend that your boss read through the link I posted. It's heavy going, but rewarding. If he stills thinks dynamic SQL is the way to...
February 1, 2012 at 3:31 am
Ram
Unless there's someone here with a lot of experience with TDP, I think you'd be best off posting this question on a TSM/TDP forum, or getting support from IBM or...
February 1, 2012 at 3:01 am
I think the syntax error is because you've wrapped your parameter declarations in parantheses. However, I'm confused. You say your stored procedure creates a stored procedure, but there...
February 1, 2012 at 2:53 am
Mike
It's not seamless, I'm afraid. During a failover, the services stop on one node and start up again on another. Any open connections are therefore killed.
John
January 31, 2012 at 9:52 am
Write a formula in Excel or whatever spreadsheet package you're using. Then you can copy and paste it into your query.
John
January 31, 2012 at 9:02 am
Or right-click anywhere in the query window and choose Connection -> Disconnect. Then do the same, choosing Connection -> Connect.
John
January 31, 2012 at 6:38 am
Is this homework? What have you tried so far? Hint: use CROSS JOIN.
John
January 31, 2012 at 6:23 am
Isn't it like this:
LIKE '%''%'
I've got two single quotes in there instead of one double.
John
January 30, 2012 at 9:50 am
Viewing 15 posts - 4,771 through 4,785 (of 7,191 total)