Hi,

Please let us if you are facing any problem. If youa re not clear on the process then Check out the below link

http://support.microsoft.com/default.aspx/kb/321686

Thanks -- VJ

http://dotnetvj.blogspot.com

hi,

You can't implement this logic in DB side, it would be easier to have this logic in Front-end application.

Thanks -- Vj

http://dotnetvj.blogspot.com

HI,

it would be great if you can post some sample data and your requriement so that we can help you in writing the right query.

Thanks - Vj

http://dotnetvj.blogpsot.com

Hi

It depends on your background if you are from Java then you can learn C# otherwise VB is good.

Thansk -- VJ

http://dotnetvj.blogspot.com

Hi

Check out the below link

http://www.cpearson.com/excel/pivots.htm

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

Check out the below link

http://www.dotnetspider.com/resources/1266-Split-e-String-Using-char-separator.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column...

HI,

This is the only way that you can do.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

1. Check if temporary table exists...

IF OBJECT_ID('TempDB..#temp_table','U') IS NOT NULL

PRINT 'Temp Table Exists'

ELSE

PRINT 'Temp Table Doesnt Exists'

2....

Hi

Please verify the data lenth of the datatype. I am sure this is causing the problem.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

You should provide more description on your questions so that we can answer in better way.

if you are looking for something to modify the textfiles using T-SQL then check out...

Hi,

What is the error are you getting?

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Use the below query,

-- Last Sunday (Inclusive)

SELECT DATEADD(day, DATEDIFF(day,

0 /* Any Base Date */,

GETDATE()) - (DATEDIFF(day,

6 /* Base Sunday Date */,

...

Hi are you sure its an issue with order by clause? why dont you remove order by and try the query. If you are getting the same error then its...

Hi,

DELETE FROM table_xx WHERE A + B + C IN (

SELECT A + B + C FROM table_1 where A + B + C NOT IN ( SELECT A +...