I'm trying to create a stored procedure that will create a view based upon 3 values passed as parameters. Stored procedure:
CREATE PROCEDURE spCreateRandomingView
@PubID varchar(50), @...
I have the following view - and its giving me duplicates..
I was wondering if there was a way of re-writing this without using a distinct ?
Thanks
Mo
Hi,
I am unable to see any of my databases with enterprise manager.
This has only just started to happen - and i have no idea why.
If I select the database tab then I am presented with a ...
Hi,
I was wondering if anyone knows how to layout a table structure that would allow someone to search for properties with certain features without having to store features in a table such ...
I have a temp table as followed:
Create Table #TempTable
(
column1 int
, column2 varchar(20)
.
.
.
)
I want to save the result of my stored procedure into thi...
I keep getting this error intermittently: Autogrow of file 'seed16_log' in database 'P21' took 61922 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file." O...
I asked a question about how to make the below sql code easer yesterday and the suggestion was to use ROW_NUMBER function as i am on MS SQL 2005.
so now my question is, can anyone give me a...
Hi all,
Is it possible to use a single stored procedure to insert an entry into multiple tables?
For example, once a user logs in for the first time I want to add their ID to a number o...
I got a phone number column display on my C# window application. I found out some of the phone numbers are null but it shows () - on the grid. Now if I want to change the () - to blank, how ...
Hi All,
I have the following query which gives me results of two rows. I need to delete these two rows from the table evv_eng_var
SELECT isnull(b.evv_envardesc,a.engvardesc) as col1,isnu...
hi guys, i have a csv file that use looks like this
"INVOICE#,""CUSTOMER#"",""CUSTOMER CITY"",""ORDER"",""SHIP DATE"",""PO NUMBER"",""INVOICE DATE"",""INVOICE AMT"",""CASH DISC %"",""CASH DIS...
Hi All
I'm designing a SSIS package where I'm accepting a datetime as a package-wide parameter.
Question: How do I incorporate that parameter into various SQL statements used in OLE DB...
I am building a report with SSRS. The report includes 2 parameters, which encompass a date range: @startdate and @enddate. These date parameters can be null and by default are null. They a...
Hi All,
I am looking for help for some views which has already created by previous dba in my company.
I want to add a primarykey type key to my view which is unique for that particular v...
Following a Hard Drive failure, I have had the data recovered from the drives, and the important files are
.bak /
data.mdf & log.mdf these files have the required file size however when i ...
We use a replacement function on SQL Server 2000 to replace certain characters with certain Unicode-characters. We found an error in the function output because SQL Server considers 'þ' to be ...
We have an MS Access table in which one field is the path to an image. We then regularly upload that data into a corresponding SQL table. But rather than just uploading the path to the image...
Does anyone know how to setup a Sql cluster (Active, Passive) to use sql mail to send out some jobs that process each day. Do i need to install Outlook on the cluster servers? Can i relay it...
H i there
I have a table containing a text field (amongst others).
I want to do a query something like:
Select * from myTable
Where x = 1 and y = 2 and z = 3 and myTextField = 'Y'
...
Hello Experts,
I need some help with sql query...
I have 2 tables.
First has (I mention only relevant columns) 2 columns [pKey] and [Text]
Second has [fKey] and [Vote].
fKey is a foreig...
I am trying to figure out the best way to write a sql query in order to find out how many consecutive days an employee has worked during a designated timeframe .... The sql table, "TIme" that...
Hi Experts,
I am trying to write a stored procedure to select invoices that were payed. My problem is if there were two payments on a invoice it shows 2 times. I have tried using DISTINCT ...
in my system, i have different members from different countries, i want to display their current date in my system based on their country, i am using sql server 2005, how can i get the current...
I have created a VB.Net, Sql Server 2000 application.
I am trying to store some text in a table column. The column is expected to have 50 characters appended everyday. At this rate, the row ...
HI There,
I have two querys that select from the same table. They both bring back the number of votes for and against. already have the current count of all votes but i'm trying to subtrac...
