Finally able to read it, been waiting all day 😀

I've used your code to add the formatting to...

tahirayoub (8/23/2011)

---

The name of the date time column from source file is "dates"

in expression it is [dates] but how to splitt it which function of date/time to use and how...

Not on it's own, no.

IF OBJECT_ID('tempdb..#example') IS NOT NULL

BEGIN

DROP TABLE #example

END

CREATE TABLE #example (id INT PRIMARY KEY IDENTITY(1,1), name VARCHAR(MAX))

CREATE NONCLUSTERED INDEX IDX_NC_temp_example_name ON #example(name)

But you could use it...

As has been said to you repeatedly, storing dates as anything other than DATE or DATETIME is a recipe for disaster later on.

I've not tested this code, so please test...

Slightly easier: -

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = 'SELECT SUM(rn) FROM (' +

ISNULL(STUFF((SELECT ' UNION ALL SELECT COUNT(*) AS rn FROM ' + table_catalog+'.'+table_schema+'.'+table_name

FROM INFORMATION_SCHEMA.TABLES

WHERE table_catalog=db_name() FOR XML PATH('')),1,10,''),'SELECT...

It sounds like what you're looking for is datediff.

If that doesn't help, please read this post[/url] and supply sample data along with expected output/result.

forsqlserver (8/19/2011)

---

Thanx,

Here HRMS persons are not giving rights on there table they only provides data...and the forefront database save the date columns in format of varchar.

Can it possible the date...

Cool, look forward to the updated blog!

SQLRNNR (8/18/2011)

---

Cadavre (8/18/2011)

---

Not...

Not really mine,...

Nice! Does this improve the performance a little: -

DECLARE @SudokuGivens VARCHAR(100)

SET @SudokuGivens = '53 7 6 195 ...

Ah,...

Vlad-207446 (8/15/2011)

---

2. process each date as if they were direct strings and if the date can not be safly converted to a valid SQL date try to massage it...

Is there any problem with just using @@ROWCOUNT ?

DECLARE @RowStart INT

DECLARE @RowEnd INT

SET @RowStart = 1

SET @RowEnd = 100

;WITH CTE AS

(

SELECT *, ROW_NUMBER() OVER(ORDER BY (SELECT NULL))...

Umm, couldn't you replicate with something like this?

USE databasename

GO

DECLARE @srows INT, @erows INT

SELECT @srows = SUM(a.rows) FROM (SELECT object_name(object_id) AS TableName, rows FROM sys.partitions WHERE index_id IN (0,1)) a

EXEC sp_MSForEachTable...