Hello
I want to return a count from Dynamic SQL. This is what I have so far...can someone make it work?:
Alter Procedure [dbo].[uspSelectCheckForERCOSPO]
@NavCoID tinyint
AS
declare @sql...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22763681.html
Consider a table called useraccess with just 2 rows. Username and reportname.
These 2 rows define what reports a user is allowed access to.
Now the front end (web selecting individual user and sa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22771365.html
Is there a problem with using the same proc to feed multiple reports?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22830163.html
I am using this query to select data from a table:
SELECT StaffID AS RecipientID,
Title + ' ' + FirstName + ' ' + LastName AS RecipientDisplayName,
Title + ' ' + FirstName + ' ' + La...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22839369.html
I created a chemicalRollup with the fields: chemicalCity, chemicalCityRollup, chemicalState, chemicalCountry but I am running into 2 problems:
1) Since there is Jacksonville in North Carolina an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22839803.html
I thought I was pretty good at stored procedures, however I might be wrong in this case.
Consider a stored procedure (Or the start of it as this is where it's failing) as follows.
CREATE ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22852975.html
Good evening,
I have 2 servers running under NT4 and SQL SERVER 2000. There is one database replication between those servers. The replication monitor is OK (color green).
The problem that I ha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22879768.html
I have sql 2000 installed on a old computer that needs to be replaced. The problem is that we misplaced the product keys. How do I locate the product key on the existing server to be used on the n...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22880201.html
Currently running sql server 2000 and writing a vbscript to store latitude and longitude in a the database. Column defined to store this information is has a type of float with a percision value o...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22883223.html
Hello,
I refer to http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22128281.html
Regarding Char vs VarChar.
I am wondering on this consideration for int, bigint, money a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22886593.html
