Is it possible to call a stored procedure in a select statement
For example
SELECT Account_ID, Account_Number, Currency, (Exexute the stored procedure passing to it the Account_ID) AS Cu...
I am trying to write a new stored proc based off an exisiting one that counted the number of ads placed and inserted the data into a table. But now I want to break it down by class, so I am wo...
Hi
i have a set of datetimes records stored in a sql server database. i need to determine if any of these entries occured on the current day.
i have used both
select * from daily_inve...
Hi, Experts:
Does SQL Server 2000 has any function or extended storeprocedures that has
the same functionality as Split() function in VBScript or Javascript? I try to split the
followi...
Dear all,
I know this question has been asked many times, but I still got the error after tried their solution.
I have MS sql Db table named [Testing] contains four rows and column
[my_...
I have an Excel Source component hooked to an OLE DB Destination component in my SSIS 2005 Data Flow Task. After I mapped the excel columns to the OLE DB table columns i get these errors belo...
How to do this:
select * from consent_properties where
(select streetaddress,count(con_consentid) as consents
from CONSENTS con, adults adl, CONSENT_PROPERTIES conprop, property_ids pids...
Hello, I'm a relative newbie to this since the SQL database person at my work is out for an extended period of time. Recently, on of the applications we use stopped working and returned the er...
Hello all,
Thank you for viewing this query. My query is as follows:
I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd s...
I'm looking to return a date format of DD:MM:YY in query analyzer and I keep getting the same format (YYYY:MM:DD)..
Here is my query: select convert(smalldatetime, getdate(), 1)
I also ...
Hi,
While restoring the SQL serverdatabase, I obtain the following error:
Microsoft SQL DMO(ODBC: SQLstate 42000):
The backup of the system database on devise XXXX cannot be restored ...
In SQL we can do the following
insert into Test(va1, va2, va3)
select va1, va2, va3
from Other
where ......
How do I do the same thing like above but in format of update-select ?
I need to update a field of a table that is itself used in the query to determine what to update. The only error I get out of SQL is a general syntax error.
UPDATE tblInvoice_Master SET tb...
Hi,
Kindly assist how can we convert a datetime to string?
select ID, 'present ' + DTstart from table1
adding the word present to a datetime column
Thanks.
Hi,
Im having a big problem with yet another simple task :)
Trying to get MS SQL to convert its datetime type to a UNIX timestamp
How can this be done? I know in MySQL there is the UNIX_TI...
Hi..
I have a big problem, hope that you can help...
I have windows 2003 server with CA brightstor 11.0 (Build 2670)
and is making backup to all my SQL Servers.
so I need to restor...
Hello,
Could someone tell me how what the syntax is to convert a Julian date to a regular date format in SQL? Thanks.
d-
Where can I find an entire list of the trappable SQL error codes? Is there a web site that contains a list of the error codes.
hell there,
i am having problem viewing reporting service reports i created.i get this error.how do i create a user with a trusted SQL Server connection.
the error i get is.but in my stu...
Why doesn' t the following work in the scalar valued function? I keep getting an error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '10/16/' to ...
I have a field that I would like to only display the date as mm/dd/yyyy. Current field shows mm/dd/yyyy hh:mm:ss AM.
I would most likely create a view that will create a field that will di...
Windows Server 2003 Enterprise Edition
RAM = 16 GB
SQL 2000 Enterprise Edition
AWE is enabled with Min and Max set and /PAE Switch only is used in boot.ini file .The OS can see all 16 GB ...
I have SQL Server Std. running on a Win 2003 server. Everything has been fine except for the past few days the Default Instance/Service does not launch anymore. I have uninstalled and reinstal...
Can't quite get my head around this Run-Once script, at the moment, appreciate any quick help, so I can get on with my favourite job, reviewing all the uploaded images, for approval. - LOL
ht...
We are developing an Intranet for our organization and are using SQL 7.0 as the database for it. We have a content table with a field to hold the text for the various html pages. Can somebod...
