Viewing 15 posts - 2,851 through 2,865 (of 3,221 total)
Jason, might I suggest that you look at EXCEL's help file. In particular the subject Automatically numbering rows. An extract of what can be done is:
Select the first...
September 19, 2008 at 9:28 am
The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way.
You might want to read this:
http://www.sqlservercentral.com/articles/Development/2734/
A partial extract from the above article.
PIVOT FUNCTION:
It widens...
September 18, 2008 at 5:17 pm
The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way.
You might want to read this:
http://www.sqlservercentral.com/articles/Development/2734/
A partial extract from the above article.
PIVOT FUNCTION:
It widens...
September 18, 2008 at 5:15 pm
You could use the CONVERT function for example:
DECLARE @Num4 AS DECIMAL(10,4)
DECLARE @Num2 AS DECIMAL(10,2)
SET @Num4 = 1234.9876 ...
September 18, 2008 at 4:57 pm
Hanshi and Cy
A technique I have used in SQL 2000 to determine which tables are used or not used is contained in Forum posting
http://www.sqlservercentral.com/Forums/Topic562824-145-1.aspx#bm564071
I will be fair and honest, if...
September 18, 2008 at 4:43 pm
Declarative Referential Integrity (DRI)
From:
http://www.cvalde.net/document/declaRefIntegVsTrig.htm
This is a metadata declaration that enforces a dependency relationship between two tables through one or more fields. So, the engine itself is in charge of verifying...
September 17, 2008 at 7:42 pm
Randy -- Application roles are not assigned to users -- for a rather lengthy, but valuable discussion of how to use Application Roles and how users access these roles please...
September 16, 2008 at 10:15 am
Has Sergiy properly understood your question? If so then ignore what follows.
Your data for item 2 is:
CustomerID TestID
2 ...
September 15, 2008 at 6:12 pm
Arthur.Lorenzini
I have duplicated what I can deduce as your Customer and Customer_Income tables, using both SmallMoney and Money as the data type for your gross_income column. I...
September 15, 2008 at 4:08 pm
There must be many scenarios where there is a need to prevent the dba from viewing the data - eg medical, criminal, psychiatric records etc etc.
. Isn't this a...
September 14, 2008 at 11:26 am
To expand beyond the simple parsing of Last name, first name to what you have asked may I recommend reading an excellent article by Steve Jones at http://www.sqlservercentral.com/articles/Advanced+Querying/20010422115807/91/
Also consider Steve's...
September 14, 2008 at 9:07 am
Had a project using Windows 2000 which was using an ACCESS DB rather than SQL server, performing much the same task as you have outlined. One problem was discovered...
September 13, 2008 at 8:06 pm
True enough... my question is why you'd want to do anything to all tables from outside the database when the database does it so well?
Jeff: I am taking it...
September 13, 2008 at 3:04 pm
If you wish to do this programmatically then use ADOX. This Microsoft site presents the ADOX object model, with links to just about everything else concerning ADOX. By...
September 13, 2008 at 12:45 pm
Original answer to you was faulty so I removed same. Sorry about that.
September 12, 2008 at 10:15 am
Viewing 15 posts - 2,851 through 2,865 (of 3,221 total)