We use them here for Total Calculations using UDF functions.

But since we are developping the application, we are beeing very careful that they are only used when there aren't too...

perfect! that was my goal.

Since I learned about it, I wanted to share the knowledge.

Since at least one person has learned something, my goal has been reached... 🙂

I also would like to add.

The QoD is a great way to learn... I've learned so much answering and reading answers.

I would like to thank SQLServerCentral for this great service.

I...

Sorry about the ambiguous answer.

What I was trying to get to is...

Retrieving data from a normal column is much faster then having to calculate the value every...

Found It!

declare @test-2 as SQL_Variant,@test2 as Varchar(max), @Test3 as SQL_Variant

select @test-2= defaultvalue from mytable where MyColumn = 'MyTest'

Select @test-2 -- this is a binary...

I have a question... I've changed the script to use C:\ for both files as follows:

Create Database Mytestdb

on

( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB

)log on(

name ='MyTest_2', Filename= 'C:\MYTEST.doc',...

I read this article quickly and as soon as I saw you using the Profiler I stopped reading thinking this isn't the easiest way for sure... there must be a...

using the Dynamic Management View (DMV) in SQL server 2008 and without using the profiler, here's a start to find unsused Stored procedures (you can modify it to use the...

Funny how this article just came out today... I was actually on a similar thread last week and someone came up with a great solution...

My personal opinion the article...

Thanks for the offer... I read about the "With" Statement... I like it ... Very nice and powerful

Thank You

WOW...

That one works too.

I just need to try to understand it.:-)

This is great to know...

I've used the previous post to delete all duplicates....

Thanks

Select min(%%LockRes%%) as ident,* into #test from MyHeap group by HeapName, SomeNullColumn, SomeId, phone

delete...

you need to use the ROW_NUMBER() function

by using the ROW_Number function every row will have a different row id.

I personally never used it but I saw my ex-colleague use it.

Wow!!! I found it!!! (3 hours later)

The answer for those interested is to put the escape character ^ before the 2 first <.

and also need to put an escape...

Exactly... when you preview th data it seems fine... but when sending it to the destination it bugs...

Do me a favor and sort the excel spreadsheet before passing it...