|
Hi
i have following tables
Table:Messages, Fields: msg_id,message
Table:Msg_groups, Fields:msg_id,Group
now i want to select msg_id and group, a msg_id can have more than one group it should display like this:
msg_id....group
123.......22,23,24
222.......22
122.......23,24
Any help will be appreciated.
Shahzad Aslam
-- modified at 5:37 Tuesday 27th March, 2007
|
|
|
|
|
the below query select groups for each msg_id
SELECT Messages.msg_id, Msg_groups.Group
FROM ( Messages INNER JOIN Msg_groups
ON Messages.msg_id=Msg_groups.msg_id )
enjoy it
|
|
|
|
|
can write a function which accepts "msgid" and fatches all "group" returns concatenated group.
using
select msgid, fugroup(msgid) ......
will give output as required.
Regards
KP
|
|
|
|
|
can u help to develop the fugroup(msgid) function
Shahzad Aslam
|
|
|
|
|
CREATE FUNCTION fnRegions (@msgid int) RETURNS VARCHAR(100) AS
BEGIN
DECLARE c1 CURSOR FOR SELECT DISTINCT CAST(groupid AS VARCHAR(40))
FROM msg_groups WHERE msg_id = @msgid
DECLARE @row VARCHAR(50)
DECLARE @retval VARCHAR(50)
OPEN c1
FETCH c1 INTO @row
SET @retval = ''
WHILE @@FETCH_STATUS = 0
BEGIN
SET @retval = @retval + @reg + ', '
FETCH c1 INTO @row
END
RETURN @retval
END
Regards
KP
|
|
|
|
|
its great
Thanx!!
Shahzad Aslam
|
|
|
|
|
|
hi all,
I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost)also.In the subsription section of the report manager ive mentioned a emailid to whom ive to send the report.Ive selected the report server email delivery method from the dropdown list.After entering the emailid and scheduling the report and when i click ok i find that the report was not delivered.Im getting this error.
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
I culdnt find enything in the log files.
Can any1 help me as how to accomplish this?
T.Balaji
|
|
|
|
|
You do have the SMTP server configured
|
|
|
|
|
yup smtp server has been configured..stil then pls help me
T.Balaji
|
|
|
|
|
Hi
Northwind database is not installed in my Database Server. I have installed this database from Microsoft's Site.
Anybody can tell me how to include this database in my SQL SERVER 2005.
Replay ASAP
Thanks
CARE CARRER
|
|
|
|
|
Have you tried attaching the database?
|
|
|
|
|
Most examples for SQL Server 2005 involve a sales table that you split based on date, i.e. sales records prior to 2000 go to this partition, and the ones after that go to another one. Nice and simple.
Say I have a sales table:
id.....Amount....Date
1......10........1/1/1999
2......9.99......1/1/2007
Now then, I put all the records prior to 2000 in it's own partition.
So when I do something like this: SELECT * FROM Sales WHERE DATE = 1/1/1999
the SQL server will know which partition to look at. Very nice.
Now then, if I do this: SELECT * FROM Sales WHERE id = 1
How will the SQL server know which partition to look at?
Thank You!
|
|
|
|
|
It will look in both partitions. However, you probably have a unique index on "id" so the cost will be minimal.
|
|
|
|
|
when more than one user connect to the database in server with application, they have very low return!
is there any settings for connection that more than one user could connect in same time without low spead?
|
|
|
|
|
What's the database ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
hamid_m wrote: MS Access
There's your problem. Upgrade to a real database.
|
|
|
|
|
what's your mean? your talking about sql server?
i have to do this project by ms access
|
|
|
|
|
Why? You can get free versions of SQL Server that should satisfy your needs.
If you want to get true Database Server performance, then you should really use a database that was designed from the ground up to be a database server.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
There is no way to make MS Access deliver reasonable performance in a multi-user environment. If you want performance in a multi-user scenario, use a server, not a file-system based database. There is a free version of SQL server, if cost is the issue.
|
|
|
|
|
Hi!
I have installed MS SQL Server 2005 on my Company's server (c drive) and I want to create my databases so that the Data is on another hard drive (N:\) is is possible to do that.
Thank you
phokojoe
|
|
|
|
|
You can Attach the .mdf file
|
|
|
|
|
I do not understand. I know how to attach the database. My question is, when you install ms sql server, the default directory is c:\ whatver the name of the hard drive it is. And the .mdf file is located at c:\program files\microsoft sql\mssql\data\databasename.mdf. Now I want this database to be in the other drive not the default drive. Is it possible?
phokojoe
|
|
|
|
|
" CREATE Database Mydb
ON (Name = mydbdat. FILENAME = 'N:\Mydbdir\mydb.mdf', SIZE = 5MB, MAXSIZE = 10MB FILEGROWTH = 1MB)
Log On (NAME= MydbLog, FILNAME = 'N:\Mydbdir\MyDb.ldf', SIZE =1MB, MAX SIZE = 5MB, FILEGROWTH = 1MB)"
TO move an existing database:
"sp_detach_db Mydb;
GO
--Physically move the full-text catalog to the new location.
--Attach the myDbdatabase and specify the new location
CREATE DATABASE Mydb ON
(FILENAME = 'N:\Mydbdir\MyDb.mdf'),
(FILENAME = 'N:\Mydbdir\MyDb.ldf'),
FOR ATTACH;
GO
|
|
|
|