Viewing 15 posts - 23,656 through 23,670 (of 26,490 total)
Marios Philippopoulos (11/19/2008)
UPDATE A
FROM tbl1 A JOIN linkedServer.db1.dbo.tbl2 L
...
Service Broker won't help you with this...
November 20, 2008 at 8:23 am
Kicking_Fish0713 (11/19/2008)
Thanks for a quick response.I don't use hardcoded values that's why I'm using a cursor.Can you pls send me a sample script using a cursor?Thanks in advance.
First of all,...
November 20, 2008 at 7:17 am
Hopefully the following test code will help you figure out what you need:
create table #MyTest (
Number int,
Code char(4),
...
November 19, 2008 at 9:18 pm
Nandy (11/19/2008)
Hi All,Now I can able to delete the data from the table using cursor.
Cheers,
Nandy
Not sure what you are talking about here. You never did answer my question or...
November 19, 2008 at 8:51 pm
Let us drop back 10 yards and punt.
First, answer the following question, what are you attempting to do with this particular query? Are you trying to return all records...
November 19, 2008 at 3:26 pm
Different angle of attack. When making a reservation, do you keep trying until you find an available RunNo & RunType? You don't have a screen that returns open...
November 19, 2008 at 12:36 pm
Here is a question that should be asked of the system:
Given:
CheckInDate = 11/11/2008
CheckOutDate = 11/14/2008
RunType = Large
What RunNo is available?
Based...
November 19, 2008 at 12:21 pm
Nope, doesn't help. Based on your current sample data, we have 6 reservations for a Large runtype, and run number L100. Based on the information provided, 2 of...
November 19, 2008 at 12:16 pm
From Books Online (BOL) :
Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.
So, answer, yes.
November 19, 2008 at 11:36 am
It does, but it points out an error in your sample data as well. If we make the assumption (as ReservationID is an identity column) that the reservations were...
November 19, 2008 at 10:51 am
Post the DDL for the tables and indexes. Can't really tell what the issue is based solely on your post. Also, post the DDL for the database as...
November 19, 2008 at 10:46 am
How about showing us what your are talking about? Could you post the DDL for the table and some sample data?
November 19, 2008 at 10:44 am
Not really. Based on that some of the sample data should have been rejected. Could you please explain the results expected based on the sample data. I'm...
November 19, 2008 at 9:37 am
Is there more to the error message than just this: Error: 913, Severity: 16, State: 8?
November 19, 2008 at 9:20 am
Could explain in a little more detail exactly what you are trying to accomplish? Also, could you explain in more detail what is supposed to happen with the following...
November 19, 2008 at 9:08 am
Viewing 15 posts - 23,656 through 23,670 (of 26,490 total)