grkanth81 (12/28/2007)

---

Thanx Madhavinan...i got it....

but thr is a small probs still...

when i run tht query...i am getting data for only oct,nov and dec months...for the rest of the months...the rows...

grkanth81 (12/28/2007)

---

Thanx Madhvinan...for ur response

when i run the query which u have sended with my actual data...its working i.e i am getting the output correctly...but i am getting the following...

1 You can also use Coalesce() in place of isnull

2 Dont single quote...

maynor_ramirez (11/28/2007)

---

Hello everyone! I have a table that have a field type nvarchar(6) and it suppost to be dates, the way that the data is display is like this...

Matt Miller (11/19/2007)

---

Mick - are you trying to build a row for each day between 2 dates?

If so - you probably want to use something involving what is known here...

Some more methods

1 EXEC sp_tables

2 In QA, dont point any content and press Alt+F1

Would you mind posting the solution? 🙂

It would be more readable if the title of the atricle is included in the url replacing hyphen for space instead of removing it

ex

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspxYou can clearly...

and you can find lot of informations here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

sqldba (12/14/2007)

---

Hi,

I have a table with

C1- ID

C2-Date

C3-Date with time

C4-quantity

I need to create a daily process that will remove the oldest data(data older than 30 days) on the table and...

Mike Levan (12/17/2007)

---

When i do the following query

select fromdate from emp where fromdate>'2/16/2007' (here fromdate is varchar)

I get the follwing result set

3/18/2004

9/28/2004

2/19/2004

5/24/2006

9/29/2004

5/10/2001

9/13/2001

6/30/2006

8/25/2000

7/18/2006

5/01/2007

8/02/2000

4/25/2001

8/17/2006

9/27/2006

but i need the dates greater than '2/16/2007'...

grkanth81 (12/17/2007)

---

i have a column named datecolumn varchar (5). it contains data something like this:

datecolumn

26NOV

09DEC

18NOV

22DEC

now i want to make that data as this format :

26/11/

09/12/

18/11/

22/12/

i am trying to...

Sandy (12/18/2007)

---

Hi,

In my web page, the Datagrid gets the data from SQL server 2000 by using Stored procedure. After getting the data, it need to be saved an Excel...

Christine M (12/18/2007)

---

I have this simple update query...

update CEM_smcsAssignments

set MGR =

(SELECT a.MGR

...

Jeff Moden (12/27/2007)

---

Until they fix it, there's a work around...

1. Put your cursor one line above the code box.

2. Click and drag to one line below the code...