js_0505 (1/10/2012)

---

I have a string that looks like the following:

20110101,glp,100.0,50.0,25.6 hgl,29.0,28.0 jlp, 30.0

how can i split via space and comma so i have the desired output into a sql table.

20110101...

Run DBCC USEROPTIONS on both servers. That will show you the dateformat.

Example usage:

select * from dbo.DelimitedSplit8K('abcd,efg,hij,klmn,opqrstu,vwxyz', ',')

where ItemNumber = 3

This will return 3, 'hij'. I think is exactly what the OP was looking for.

Cadavre (1/10/2012)

---

I can't remember whether or not Jeff Moden's string splitter[/url] already does that, or if I had to edit it but I do know that the TALLY table method...

A couple of things. Simply repeating a vague and non-descript explanation is not going to make it clear for anyone. It is obvious that you are getting frustrated. This is...

OK we are now 20 posts into your request and the details of what you want is still changing with each post. We can't see over your shoulder, we are...

What have you tried? It looks like the script posted above would be a pretty good starting point. That could be modified pretty easily to accomplish what you are after.

I...

You need to find table and column names for any table that contains a numeric value that is exactly 9 digits?

The point is to not post the same question in multiple places. It fragments responses.

Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1232230-391-1.aspx

I searched on google for "sql server convert sysjobschedules to datetime" and the very first hit has the following function.

create FUNCTION [dbo].[udfGetDateTimeFromInteger]

(

@intDate int,

@intTime int

)

RETURNS datetime

AS BEGIN

-- Declare the return variable...

ColdCoffee (1/6/2012)

---

One note on Sean's query. if the SKUs have trailing spaces, then u will not have the trailing spaces cut of.

i may do this:

create function udf_TrimTrailingZeros

(

@Input varchar(50)

) returns varchar(50)

as...

One problem with what you posted is if you passed in a sku of 1300038 it would return 13 38.

If you 100% certain that there are 3 and only 3...

You declared your files array but never instantiated it. In other words, you need to get your files somewhere. You need something like files = GetListOfFileNamesFromSomeLocation

You are going to have to provide a LOT more information before anybody can help. We need to have ddl (create table scripts), sample data (insert statements) and desired output...