Madhivanan - All Comments

re: When was my Server restarted?

vmvadivel — Mon, 08 Jun 2009 12:48:40 GMT

Though checking the creation date of TEMPDB will do the trick. Its not a guaranteed method.

Bcoz PSS when they do troubleshooting some tempdb issues could have used T3609 to recover tempdb instead of recreating it.

So the best method and the only method to trust 100% is to check the time in sysprocesses as I have shown in my blog post.

vadivel.blogspot.com/.../how-to-find-when-sql-server-was-last.html

Server Side Guy » Escaping Single Quotes in MS SQL Server (T-SQL)

Server Side Guy » Escaping Single Quotes in MS SQL Server (T-SQL) — Tue, 02 Jun 2009 15:34:27 GMT

Pingback from Server Side Guy » Escaping Single Quotes in MS SQL Server (T-SQL)

Fishy feature? | keyongtech

Fishy feature? | keyongtech — Thu, 28 May 2009 12:08:30 GMT

Pingback from Fishy feature? | keyongtech

Multiple Rows into One Row w/ Multiple Columns - dBforums

Multiple Rows into One Row w/ Multiple Columns - dBforums — Sat, 16 May 2009 03:15:31 GMT

Pingback from Multiple Rows into One Row w/ Multiple Columns - dBforums

final cumulative value | keyongtech

final cumulative value | keyongtech — Thu, 14 May 2009 10:07:15 GMT

Pingback from final cumulative value | keyongtech

re: Import from Text file - Single column to multiple columns

Madhivanan — Wed, 06 May 2009 12:22:57 GMT

kongstad,

It is ok for fixed number of columns. What if new column is added like State? You need to modify the query. Thats why I used dynamic sql which will take care of any number of columns

re: Import from Text file - Single column to multiple columns

kongstad — Wed, 06 May 2009 10:56:47 GMT

I think this select statement is a lot more intuitive than what you suggested.

select

MAX(case when data='AccountNo' then value else null end) AccountNo,

MAX(case when data='AccountName' then value else null end) AccountName,

MAX(case when data='City' then value else null end) City,

MAX(case when data='Country' then value else null end) Country

from

(select (id-1)/4 id, data,value from test_data) a

group by id

It replaces all your code after you have added the identity column.

It assumes that the data is ordered, and uses the id column to make a new value as (i-1)/4, assuring that connected rows have the same id.

It then simply uses the max function to unpivot the table.

re: Dynamic PIVOT in SQL Server 2005

Madhivanan — Tue, 28 Apr 2009 14:34:09 GMT

gr leon,

Refer method 2

sqlblogcasts.com/.../select-columns-from-exec-procedure-name-is-this-possible.aspx

re: Dynamic PIVOT in SQL Server 2005

lcarpay — Tue, 28 Apr 2009 13:05:16 GMT

Hi Madhivanan, do you have a clue how to INSERT INTO the result of this fantastic SP in a new table. I thought about making a function of your SP but as the columns are not know a design time I see no way to define such a udf.

Can you help me out?

gr leon

Data types of result of stored procedure | keyongtech

Data types of result of stored procedure | keyongtech — Tue, 21 Apr 2009 14:07:47 GMT

Pingback from Data types of result of stored procedure | keyongtech

Filling random passwords - Set based approach

SQL Server Transact-SQL (SSQA.net) — Mon, 30 Mar 2009 14:24:21 GMT

In this post , I showed a way to generate 8 characters random password If you have table with data and

Filling random passwords - Set based approach

Madhivanan — Fri, 27 Mar 2009 14:23:28 GMT

In this post , I showed a way to generate 8 character random password If you have table with data and

re: Dynamic Crosstab with multiple PIVOT Columns

veera — Thu, 19 Mar 2009 04:23:19 GMT

itemno wh1 wh2 wh3 tot

----------------------

F1 10 10 0 20

F2 10 0 10 20

F3 0 0 30 30

----------------------

i need this type of format report. please give some idea to do this report

columnar to row-based data - dBforums

columnar to row-based data - dBforums — Tue, 10 Mar 2009 09:23:29 GMT

Pingback from columnar to row-based data - dBforums

sql_variant in SQL Server and ANYDATA Type in Oracle « Systems Engineering and RDBMS

Fri, 06 Mar 2009 00:20:02 GMT

Pingback from sql_variant in SQL Server and ANYDATA Type in Oracle « Systems Engineering and RDBMS