|
|
Wish I could have had that link a couple months ago. I wound up doing the same general query after digging around inside Access :->
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
you can see list of table in sysobjects table of your database.. this is where the names of table is reside...
|
|
|
|
|
Hi all ,
What is your solution for Reading/Writing persian date from/into Sql Server 2005 and do calculations on persian dates?
Thanks in advance.
-- modified at 2:55 Monday 29th October, 2007
|
|
|
|
|
Hello
I need to view the data in the datagridview from the table through an sql statment but i don't want the date will be like: "1983-01-01 00:00:00" i want just show:"1983-01-01" or show:"01-01-1983"
Thanks in advance
Assaf
|
|
|
|
|
You can done it by convert(varchar,getdate(),101)
umesh
|
|
|
|
|
there are two ways to achieve it either from sql server by using Convert(varchar(30),getdate(),101) it will convert your date to desired format.
other one is use Format(XXX, "dd MMMM, yyyy") function in .NET ...
Arun Singh
Noida.
|
|
|
|
|
Set:
DataGridView.Columns(n).DefaultCellStyle.Format = "dd/MM/yyyy"
The Fanatical All Black Supporter - Kea Kaha
|
|
|
|
|
I am creating a report using Reporting Services in SQL Server 2005 that contains a table. Table only has two columns both containing 20 or less characters. I would like my table to wrap into a 2nd or 3rd column before going onto the next page.
Thanks
|
|
|
|
|
I don't believe that this is possible. You can't add columns dynamically to a Table object at runtime. You can only represent the data in the structure returned by your SQL query and programmatically work with the data and apply visual formatting through the expression-based programming model.
Paul Marfleet
|
|
|
|
|
Thank you for your reply, however I do not want to add columns to my table I just want my table to wrap before running onto the next page.
|
|
|
|
|
SELECT Work_Requests_1.id, Work_Requests_1.work_req_name, Work_Requests_1.description, Work_Requests_1.req_name,
Work_Requests_1.cost_center,
CASE [type] WHEN 'Inst' THEN 'Installation' WHEN 'Dein' THEN 'Deinstall' WHEN 'Powe' THEN 'Power' WHEN 'Rout' THEN 'Routing' WHEN 'Fire' THEN
'Firewall' WHEN 'IPRq' THEN 'IP Request' WHEN 'DHCP' THEN 'DNS/DHCP' WHEN 'Hire' THEN 'New Hire' WHEN 'Tick' THEN 'Trouble Ticket' WHEN 'Asst'
THEN 'Asset Management' WHEN 'Spec' THEN 'Spectrum Allocation' WHEN 'Othr' THEN 'Other' ELSE 'Not Specified' END AS type,
Work_Requests_1.type AS lookup_Type, Work_Requests_1.location, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.compdate, 107),
107) AS compdate, Work_Requests_1.phone, Work_Requests_1.email, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.sendate, 107),
107) AS sendate, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.wishdate, 107), 107) AS wishdate,
CASE status WHEN 'INP' THEN 'In Progress' WHEN 'COM' THEN 'Completed' WHEN 'HOL' THEN 'On Hold' WHEN 'CAN' THEN 'Cancelled' END AS status,
Work_Requests_1.status AS lookup_Status, REPLACE
((SELECT dbo.Work_Requests_Staff.name
FROM dbo.Work_Requests_Staff INNER JOIN
dbo.Work_Requests ON dbo.Work_Requests_Staff.alias = dbo.Work_Requests.lead
WHERE (dbo.Work_Requests.id = dbo.Work_Requests.id)), 'na', 'NOT Assigned') AS lead, Work_Requests_Staff_1.alias, REPLACE
((SELECT Work_Requests_Staff_1.name
FROM dbo.Work_Requests_Staff AS Work_Requests_Staff_1 INNER JOIN
dbo.Work_Requests AS Work_Requests_1 ON Work_Requests_Staff_1.alias = Work_Requests_1.contact
WHERE (Work_Requests_1.id = Work_Requests_1.id)), 'na', 'NOT Assigned') AS contact
FROM dbo.Work_Requests AS Work_Requests_1 INNER JOIN
dbo.Work_Requests_Staff AS Work_Requests_Staff_1 ON Work_Requests_1.lead = Work_Requests_Staff_1.alias
When I execute the above query it is returning an error:Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery used as an expression.
Rajee
|
|
|
|
|
Sub Queries can only return one value try using SELECT DISTINCT or use TOP 1 if approapiate
|
|
|
|
|
Greetings everybody:
I need to know how to export a database query to a .CSV file instead of to a MS Excel file.
The code is as follows to export to MS Excel, but how do I export to a .CSV file?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"qryFinalResult", strOutputFilePath, True
|
|
|
|
|
you could just use string builder and build the thing yourself.
|
|
|
|
|
hi all
i need help to write a query
I have a table with the coloumns SNo ,ProductId and brandId
SNo is given as identity true
now want to retrive a ProductID whose SNo is maximum value
thank u.
siri
|
|
|
|
|
Hi....here is the query........
SELECT ProductID from tablename where SNo = (SELECT MAX(SNO) from tablename)
Regards,
Sandeep Kumar.V
|
|
|
|
|
|
Welcome........
Regards,
Sandeep Kumar.V
|
|
|
|
|
Hi all,
I've got the following function:
CREATE FUNCTION Test(....)
RETURNS @ReturnTable TALBE
(
.................
)
AS
BEGIN
DECLARE @MyTable TABLE
(
.............
)
INSERT INTO @MyTable
SELECT ......
FROM AnotherTable1 Inner Join AnotherTable2 .......
INSERT INTO @ReturnTable
SELECT ......
FROM
(
SELECT ......
FROM @MyTable
WHERE .......
UNION
SELECT ......
FROM @Table
WHERE ......
)
RETURN
END
When i call this function, an error message appears "Must declare the scalar variable "@MyTable"."
Please help me work out this problem
Thanks so much
|
|
|
|
|
vuthaianh wrote: CREATE FUNCTION Test(....)
RETURNS @ReturnTable TALBE
There's a typo here.
vuthaianh wrote: SELECT ......
FROM @Table
WHERE ......
Where is @Table declared?
Paul Marfleet
|
|
|
|
|
Hi pmarfleet,
Sorry, i made a typing mistake
@Table must be @MyTable
But the error does still appear.
Thanks again
|
|
|
|
|
I'm still not sure what your problem is, but it may have something to do with how you are using the table variable in your queries. You haven't posted all your code so I can't say for sure, but have a look at this link[^].
Paul Marfleet
|
|
|
|
|
Thanks a lot. The link you gave to me is very useful. I already sovled my problem.
Thanks again.
|
|
|
|
|
i am a biggner in .net and database..
i have herard that sql 2005 is better than 2000
i would like to know what are the additional features in 2005 that are not in sql 2000
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
