|
DIMPLE_R wrote: U
DIMPLE_R wrote: ur
Your answer would be easier to read if you wrote properly structured sentences and didn't use "txtspk"
|
|
|
|
|
What is txtspk?? Are you talking to me or to DIMPLE_R?? I understood him 100%!!
|
|
|
|
|
|
ma se wrote: What is txtspk??
AKA SMS Speak.
ma se wrote: Are you talking to me or to DIMPLE_R??
DIMPLE_R, that is why I quoted from his message.
ma se wrote: I understood him 100%!!
Really?? I didn't. It hurt my head.
|
|
|
|
|
Ahhh.. come one, it wasn't that bad, at least he tried helping. I appreciate his reply!
|
|
|
|
|
Thanks, but I was not thinking clearly.
I changed it to the following and it works fine:
SELECT
WineryID_PK,
WineryName,
WineryEstablishedYear,
WineryOwner,
WineryDescription,
CountryID_PK,
CountryName,
RegionID_PK,
RegionName,
WineryDateInserted,
WineryDateUpdated,
(m2.MemberFName + ' ' + m2.MemberLName) AS WineryUpdatedBy,
WineryStatus,
WineryHasImage
FROM
MemberInWinery
INNER JOIN Winery
ON MemberInWinery.WineryID_FK = Winery.WineryID_PK
INNER JOIN Members AS "m1"
ON MemberInWinery.MemberID_FK = m1.MemberID_PK
LEFT OUTER JOIN Members AS "m2"
ON Winery.WineryUpdatedByID_FK = m2.MemberID_PK
INNER JOIN Region
ON Winery.RegionID_FK = Region.RegionID_PK
INNER JOIN Country
ON Region.CountryID_FK = Country.CountryID_PK
WHERE
MemberInWinery.WineryID_FK = 20
AND MemberInWinery.MemberID_FK = 12;
Thanks for your help!!
|
|
|
|
|
hi all,
I am copying a table to another table using
select * into targettable from sourcetable .
The new table named "targettable" is created but the primary key (constraints) and default values for the table are not coming as "sourcetable".
Is there any way to have a table copy with the same table structure and design??????.
vivek
|
|
|
|
|
vivek-g wrote: Urgent
Sorry, but not to us it isn't.
|
|
|
|
|
Currently there is no such method to copy the constraints from the source to target table during table creation. For applying the constraints you must Alter the table.
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
Hi,
I would like to find duration in hh:mm format between two dates.
Example:-
Duration between '2006-06-29 09:01:13.637' and '2006-06-29 12:09:13.637'
in HH:MM Format.
Regards
Rajesh
rajesh
|
|
|
|
|
Hi Rajesh,
You may want to take a look at the following articles:
http://blogs.wdevs.com/irtaza/archive/2005/02/04/2195.aspx
http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk
Hope this helps.
Dimple
|
|
|
|
|
hello,
does anybody know how to write a query that returns the maximum value of a column? here is what i have so far:
<br />
SELECT barcode, wellname, well.ph, proteinname, score, time FROM well INNER JOIN welldrop ON well.wellkey=welldrop.wellkey INNER JOIN imageset ON welldrop.dropkey=imageset.dropkey WHERE well.barcode=1111<br />
this query returns several rows for each "wellkey". i only want to return one row for each wellkey, with the most recent date (found in the time field of the imageset table). i tried using MAX(time), but i got an error...
thanks!
RC
-- modified at 17:20 Wednesday 28th June, 2006
|
|
|
|
|
i think i figured it out. the following serves my purposes:
SELECT barcode, wellname, well.ph, proteinname, score, MAX(time) AS time FROM well INNER JOIN welldrop ON well.wellkey=welldrop.wellkey INNER JOIN imageset ON welldrop.dropkey=imageset.dropkey WHERE well.barcode=1111 GROUP BY barcode,wellname
|
|
|
|
|
This question requires experience with Visual Studio .NET 2005.
I created an n-tiered application and in the Data Access Layer I used a direct connection to the Database by specifying the server, username, password, etc in the connection string. Now I want to change this so that the application connects to the Database through a DSN defined on the local machine that connects to the server.
So I went ahead and changed the connection settings to point to a dsn. The connectio string looks like this after the change:
Dsn=dsnname
But I get an error when the connection is initialized at run time telling me that 'dsn' is not a recognized string in the connection string. Please remember that in both cases I did not generate the connection string manually, VS did it for me.
Any help will be appreciated.
|
|
|
|
|
|
Yes, I did figure it out a few hours ago. The DAL was created using a SqlConnection and since a DSN will utilize an OdbcConnection, the SqlConnection object that was created as part of the project did not recognize it. Since I used a visual editor to change from a SqlConnection to a OdbcConnection, I figured VS.NET will do the work for me. Apparently it doesn't. Thanks for your help.
|
|
|
|
|
I'm trying to find a way to grab a given rows cell information, for now just the primary key, and store it in a variable to use somewhere else. If I use listbox's I can simply use .selectedValue() and it gives me exactly what I need, but in this case, I'm needing to do it with a datagridview and this attribute doesn't exist. Thanks!
|
|
|
|
|
Hi Champs
I am writing DTS first time so need little help.
I need to check 2 columns (Col A and Col B) of Table A .
If there is no entry for these columns for current date then i need to send mails to some recipients same day at 12:00 PM.
*** Can i get the query help *** and any link where i can understand this functionality
Thanks A Lot !!!
|
|
|
|
|
Hi - We have a bunch of tables in our database but no schema was created. Is there a way we could created the schema using the existing tables automatically in SQL2005, just a basic version - or we just have to create it manually?
Is there a feature in 2005 that would do this?
Many thanks.
Vani
|
|
|
|
|
|
the database diagram which shows all the relationships between the tables.
-- modified at 7:22 Thursday 29th June, 2006
Like reverse engineer the tables and create the schema since one was not created while the tables were designed.
thanks,
vani
|
|
|
|
|
|
You can use the "Database Diagram" to create the schema.
thanks for your time.
|
|
|
|
|
|
Expand the node for the database, click Database Diagrams. If you haven't created one before, Management Studio will prompt you to to create the support objects required for diagramming. Right-click Database Diagrams and choose New Database Diagram. From here, select the tables you want in the diagram and click Add. Click Close when you've finished adding tables to the diagram.
Management Studio now arranges the tables so that the key relationships don't cross each other.
Note that key relationships are only shown where you've actually defined a FOREIGN KEY relation between tables. They're normally shown as one-to-many, unless the relationship is between the primary keys at both ends, in which case they're shown as one-to-one.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|