ya now I know the table structure of two table returning

they are dif from each other

i want to move each of them to sepatrate tables

how ??//

2013-09-26 19:59:45 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered

2013-09-26 19:59:45 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered

2013-09-26 19:59:45 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'

2013-09-26 19:59:45 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'

2013-09-26 19:59:45...

summary:

Overall summary:

Final result: SQL Server installation failed. To continue, investigate the...

CREATE TABLE addrname(addnam varchar(50))

insert into addrname

values('roshan,hrithik(india)')

go

create table separated(firstname varchar(50),lastname varchar(50),address varchar(50))

go

insert into separated

select

SUBSTRING(addnam,PATINDEX('%,%',addnam)+1,PATINDEX('(%',addnam)-1-PATINDEX('%,%',addnam))as firstname,

SUBSTRING(addnam,0,PATINDEX('%,%',addnam))as lastname,

SUBSTRING(addnam,PATINDEX('%(%',addnam)+1,PATINDEX('%)%',addnam)-1-PATINDEX('%(%',addnam))as address

from addrname

it looks messy check if it works for you

how to disable it i haven't installed it .

where to find it.

i tried same thing in google chrome its showing tooltip

in image

----

google chrome

Version 29.0.1547.66 m

try to change the version

----

another option is going to registry and changing option as in...

CREATE TABLE [dbo].[gotilla](

[ID] [int] NULL,

[Category] [varchar](50) NULL,

[Weekof] [varchar](50) NULL,

[Total_hur] [int] NULL

)

select category ,id,Sum(case when weekof='7/2/2012'then total_hur end)as '7/2/2012',

SUM(case when weekof='7/16/2012'then total_hur end)as '7/16/2012',

SUM(case when weekof='7/9/2012'then total_hur end)as '7/9/2012'

from gotilla

group...

create function returnnumerics(@inputword varchar(256))

returns varchar(256)

as

begin

declare @indexpositon int

set @indexpositon=PATINDEX('%[^0-9.]%',@inputword)

while @indexpositon>0

begin

set @inputword=STUFF(@inputword,@indexpositon,1,'')

set @indexpositon=PATINDEX('%[^0-9.]%',@inputword)

end

return isnull(@inputword,0)

end

try this query let me it works for you

ya thanks guys I got it.

I have basic knowledge of sql.

Actually I am just restoring to a new database .

ya i used sql server agent thanks.

thank you all I think i got it

ROUGH and lengthy query if you have more records ..

using some other method i think you can make it short

SELECT A.P,A.AGENCY1,A.AMOUNT1,B.AGENCY2,B.AMOUNT2 FROM

(select PROJECTID AS P, AGENCY AS...

thank you very much

yes your query is shorter and faster than main?

there is another problem?

I want result to be like this

time ...

try this

with pvt

as

(

select customertypepvt,sumpvt

from dbo.Customersnumber

unpivot

(

sumpvt for customertypepvt in([LoyalCustomers]

,[DiscountCustomers]

...

how for xml path('') works here to get all values in single row?please explain

thanks and regards

sudarshan

I THINK

your flat file content is not arranged as matching to database table, add commas(,) correctly between as shown below .use below edited data as flat...