Viewing 15 posts - 2,911 through 2,925 (of 3,221 total)
BKW - have you thought of creating a dynamic T-SQL statement such as
CREATE PROCEDURE Dbo.GetIT
@TableName VARCHAR(5)
AS
DECLARE @sql VARCHAR(50)
SET @sql = 'SELECT * FROM ' + @TableName +...
August 28, 2008 at 10:38 am
Use SSMS, navigate to the database, expand the database, right click on the table you wish to script, then select "Script table as", select "Create", then select one of these...
August 28, 2008 at 10:22 am
Serigy
That is putting the frosting on the cake, or the cherry on top of the ice cream Sunday. Hope the OP does what you suggest and gets all the...
August 27, 2008 at 8:16 pm
Paul Mc
A very similar question was asked in another forum and here is the most flexible approach given as the answer. This may also be the answer to your...
August 27, 2008 at 6:05 pm
From Access help files
You can use the ListIndex property to determine which item is selected in a list box or combo box.
Setting
The ListIndex property is an integer from 0 to...
August 27, 2008 at 5:47 pm
I want to return only one line per claim. I want to know the claimid and revcode for each claim,
Try this as your select statement
SELECT claimid, Max(revcode) AS 'RevCode'
FROM #myHead
GROUP...
August 27, 2008 at 5:00 pm
Hopefully you would have a test database, even something as simple as the free express version.... then you could try your T-SQL code and answer your own question.
Read these from...
August 27, 2008 at 3:50 pm
Paul_J
A very similar question was asked in another forum and here is the most flexible approach given as the answer. This may also be the answer to your question....
August 27, 2008 at 3:01 pm
Read this article by Jeff Moden it will teach you how to do what you want.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
By Jeff Moden, 2008/08/19
August 27, 2008 at 2:42 pm
If your Excel files are available in CSV format (in which an Excel file consisting of a single work sheet can be saved) then look at this forum posting (made...
August 27, 2008 at 12:40 pm
Is it possible for you to use an INSERT INTO statement? From BOL:
The SELECT INTO statement creates a new table and populates it with the result set of the...
August 27, 2008 at 12:29 pm
If you are using Excel 2007 be advised that some important old limitations have been removed:
The total number of available columns in Excel
Old Limit: 256 (2^8)
New Limit: 16k ...
August 26, 2008 at 1:13 pm
My concern is that a user could inadvertently access the production database when they meant to access the test database
Why would you want users to have access to both databases?...
August 26, 2008 at 12:58 pm
Clas -- I see a lot of data but NO QUESTION [/B]. Also your date value does not appear to be relevant.
August 26, 2008 at 12:46 pm
This is identical to the posting by the same individual to SQL Server 2005 Security.
Ooops Jack you sure can type faster than I can ...
August 25, 2008 at 7:06 pm
Viewing 15 posts - 2,911 through 2,925 (of 3,221 total)