Convert Rows into Columns
Convert the rows of a SELECT statement into a predetermined number of columns.
2015-12-11 (first published: 2014-07-17)
26,993 reads
Modulus
Need the First Tuesday Beyond Y days after X Date
A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.
2011-10-13
1,549 reads
RE: import issue
This problem is can be sorted out by eitherSelect the column in excel right click ,select format cells, in category list select text press ok. This will solve the problem . If you are using DTS wizard you are free to select the column data typeOne more tip , just keep some alpha text filed in the first […]
2004-09-02
RE: Stored Procedure - Expecting 2 input parameters - WHY??
Steve Jones:I see now - I was using VS.NET 2003 to run the Stored Procedure and now that I set the VALUE for @RowCount to NULL, it works perfectly. I now understand that it is expecting a parameter.Thanks a bunch!
2004-04-13
RE: Dynamic operator in where clause
Thanks for your responses. There is a standard query that will return all rows to the customers view. We will be allowing the customer to create their own filters on the fly. So, they will select a field from a list of fields and then pick an operator such as in, between, less than etc. […]
2003-08-21
RE: How to move Transaction Logs(.LDF) and Temp files
Just by curiosity, In what cases would I need to move tempdb files. Isn't the TEMDB recreated once sql server is restarted. Pay Respect to People on your way up. For you will meet the same People on your way down.
2003-08-21
2 reads
RE: System generated indexes
_WA.. are not indexes. They are internally kept and updated column statistics that SQL Server can use to assist a query if it finds no index on which to base the query plan for the SQL statement.
2003-08-18
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers