The replie is quite simple when you go with finding the date as getdate(), the getdate will return you as 2012-02-22 10:03:50.033 if you look carefully it include yyyy-mm-dd hh:mm:ss.nano...

Thanks all

I got good lesson to learn about union and order by

Hi All

I feeling very odd to ask but i am really really very confused by this how to make order by when query have union or union all

Thanks both you gave me better picture for the result ... but today i came to know that case statement cant have In clause

Hi

Try this it will make you insert from other table and id starting with 1000000

DECLARE @START INT

DECLARE @END INT

SELECT @START = 1000000 --START VALUE

SET @END = (SELECT COUNT(*) FROM...

Hi

hey thanks to both yes indeed need to understand the things before taking help and cross checking the good lesson will surely follow in future..

Thanks guys for your support and...

Rookie

This is one of the way you can try for your desire result but for this you need to know what your sp is returning it.

-- create temp...

Hey rookie

may i know what kind of result do your sp retuns. Is it one column result of multicolumn result because you using select not in which means it need...

Hi

I dont know how much this gonna benifite you just try if you this can make thing quite ok

DECLARE @FKVALUE INT

SET @FKVALUE = 1

INSERT INTO TABLE2(COLUMN1,COLUMN2)

SELECT COLUMN1,ISNULL(COLUMN2,@FKVALUE) FROM TABLE1

Hi

Its really getting confuse over here... Just need to ask you need that value to be splite into two columns one with only numerical and other only alpha. Is this...

Hi

here there is a query for the data population you need to do some alter respect to what data you want and from which table you want just make...

Hi

SELECT round(cast(((medacct# - ParticipantsAnnualElection)/26)as money),0) as Money

Hi...

Hey actually you trying to add a column into table that have already containe records and when you introduce a new column with not null that means when new column...

Hi dear

Try to put varchar(20) inside the convert function rather then datetime.

CREATE TABLE MEMBER

(

MemberID bigint

,ControlID bigint

)

INSERT INTO MEMBER

SELECT 712372226, 20111230108660 UNION ALL

SELECT 712397728, 20111230108661 UNION...