Viewing 15 posts - 1 through 15 (of 17 total)
Remove last comma or dilimiter without substring ...
Check it out here at www.sqlsuperfast.com
March 21, 2011 at 11:58 pm
Nice and useful script.
The same approach is used to find number-of-string-occurrences-with-in-a-string
look at here.
March 19, 2011 at 10:01 pm
gr8, well written
March 17, 2011 at 12:51 am
You can choose according to your need. But if you have single partition schema nad function then its easy to manage. Problem here is when you have different archival approche...
March 17, 2011 at 12:47 am
you can create procedure and your business logic to edit the records.
March 17, 2011 at 12:43 am
Just join the tables as per the relations and apply filter for reviewers.
March 17, 2011 at 12:40 am
Chek if there are NULL records. If there are NULL records compaire it with having some default value to nullable records. for example ISNULL(Id, 0)
March 17, 2011 at 12:36 am
partitioning would help greatly to delete large amount of data.
March 17, 2011 at 12:33 am
another simple way of doing this see at http://www.sqlsuperfast.com/post/2011/02/17/T-SQL-to-Convert-rows-into-single-column.aspx
March 6, 2011 at 5:18 am
Another simple way of doing this ... see the example at http://www.sqlsuperfast.com/post/2011/02/17/T-SQL-to-Convert-rows-into-single-column.aspx
March 6, 2011 at 5:16 am
New EXECUTE statement in SQL Server Denali. See wxample on www.sqlsuperfast.com
March 6, 2011 at 5:06 am
Will enabling filestream help if its not a BLOB?
September 3, 2009 at 4:59 pm
Thanks for quick reply.
Actually i need last record for X and Y combination.
Hope you get my question.
Thanks,
Amol.
August 30, 2009 at 11:07 am
Viewing 15 posts - 1 through 15 (of 17 total)