querry - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

querry

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2011-12-20 : 09:25:49

hello!!
I need select [wng] without bracket,how I can do this

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-20 : 09:55:48

select substring(col,2,len(col)-1) as col from table

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-20 : 11:57:10

is wng column name or string literal?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2011-12-20 : 13:22:35

[wng]
Provider=SQLNCLI10
SourceServer=WMLDEV-96
SourceDatabase=WNG
UserName=
Password=
OutboundFilesPath=
OutboundBackupFilesPath=
OutboundFixFormat=
OutboundFileType=
OutboundTextDelimiter=
InboundFilesPath=C:\InterfaceData\InboundInboundBackupFilesPath=C:\InterfaceData\backup\InboundInboundFixFormat=
InboundFileType=
InboundTextDelimiter=^
ResourcesFilesPath=
ResourcesBackupFilesPath=
ResourcesFixFormat=
ResourcesFileType=
ResourcesTextDelimiter=
ConfigurationFile=
ExtendedConfigurationFile=
StationId=
QueueManager=
ControlQueue=
DataQueue=
ReplyQueue=
InitQueue=

this is ini file --->txt i need querry for select{wng] without bracket

provider,SourceServer and .....---->column Parametr_name
SQLNCLI10,WMLDEV-96 and......---->column Parametr_value

thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-21 : 02:27:37

Have you tried the logic I have given?

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-21 : 11:57:01

so is it a variable containing connection string info?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-21 : 13:35:13

Are we playing 20 Questions now?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2011-12-21 : 13:47:38

done!!!
thanks to all

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 02:01:25

quote:
Originally posted by nord

done!!!
thanks to all

Hmm..
Whats was the solution?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nord
Posting Yak Master

126 Posts

Posted - 2011-12-22 : 08:56:27

without []:REPLACE(Parametr_value,"]","")
derived column:(DT_STR,50,1252)(ColumnSeparator > 0 ? SUBSTRING([Column 0],1,(ColumnSeparator - 1)) : "brand")

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources