Viewing 15 posts - 916 through 930 (of 3,544 total)
My solution (bet Jeff picks holes in it :Whistling:)
Create a format file containing
9.0
6
1 SQLCHAR 0 ...
Far away is close at hand in the images of elsewhere.
Anon.
October 31, 2013 at 8:57 am
How are you importing?
What version of SQL Server are you using?
To make this work properly you will need to import the data into a table with an IDENTITY columns to...
Far away is close at hand in the images of elsewhere.
Anon.
October 28, 2013 at 8:03 am
Or another (just for fun 😉 )
WITH SampleData (ID, MyString) AS
(
SELECT 1, '1:1,3,5,7,4:56,43,58,5:34,67r,234'
),
split AS
(
SELECT b.ItemNumber,b.Item
FROM SampleData a
CROSS APPLY dbo.DelimitedSplit8K(MyString, ',') b
)
SELECTLEFT(s2.Item,CHARINDEX(':',s2.Item)-1),
CASE CHARINDEX(':', s1.Item) WHEN 0 THEN s1.Item ELSE SUBSTRING(s1.Item,CHARINDEX(':',...
Far away is close at hand in the images of elsewhere.
Anon.
October 25, 2013 at 7:19 am
HanShi (10/25/2013)
Why do you have the restriction of using the LIKE operator?But you can accomplish this for example by using the LEFT or the SUBSTRING operator.
Bear in mind thet LEFT...
Far away is close at hand in the images of elsewhere.
Anon.
October 25, 2013 at 6:47 am
Define an InStr expression in the filter to return an Integer and check for zero value.
e.g.
=InStr(Join(Parameters!ReportParameter1.Value,","),Fields!Area.Value)
Far away is close at hand in the images of elsewhere.
Anon.
October 23, 2013 at 7:06 am
L' Eomot Inversé (10/16/2013)
David Burrows (10/14/2013)
Due to the amount of criticism of previous QOD of the phrasing of the Q'a and A's I am surprised that no one posted...
Far away is close at hand in the images of elsewhere.
Anon.
October 16, 2013 at 6:34 am
Hugo Kornelis (10/14/2013)
Yes, technically the rows were inserted and then rolled back. But from a logical point of view, the inserts never happened. Which makes the answer correct.
The answer was...
Far away is close at hand in the images of elsewhere.
Anon.
October 15, 2013 at 2:05 am
Nice question.
Due to the amount of criticism of previous QOD of the phrasing of the Q'a and A's I am surprised that no one posted anything about the wording of...
Far away is close at hand in the images of elsewhere.
Anon.
October 14, 2013 at 6:01 am
Yes I think that is the essence of it. You need a way to group the groups, either fixed within the query like Nevyn posted or alter the design (if...
Far away is close at hand in the images of elsewhere.
Anon.
October 11, 2013 at 2:09 am
Users have User_Group of BSP INC but there is no BSP_LOB_GRP entry with this value
BSP_LOB_Grp_Lookup has NULL in BSP_LOB_CD column so it cannot be matched to BSP_LOB_CD in IMPACTED_LOB table
This...
Far away is close at hand in the images of elsewhere.
Anon.
October 9, 2013 at 8:43 am
Best guess
SELECT up.User_Id, up.User_FullName, up.Email, up.User_Group ,i.Event_ID
FROM User_Profile a
JOIN User_Profile up ON up.User_Group = a.User_Group
JOIN Group_Lookup g ON g.LOB_GRP = up.User_Group
JOIN Impacted_LOB i ON i.LOB_CD =...
Far away is close at hand in the images of elsewhere.
Anon.
October 9, 2013 at 7:05 am
Try adding the page break before in the 'material code' group settings
Far away is close at hand in the images of elsewhere.
Anon.
October 9, 2013 at 6:53 am
I had something similar a while ago but not dynamic columns.
In my case I was building a temp table from multiple data.
What I did was create the table with all...
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2013 at 7:18 am
er.deepikagoyal (10/4/2013)
Yes i am able to export my data. BCP uses format to export the data using comma separated.
I have to define each column name to export the data...
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2013 at 7:07 am
er.deepikagoyal (10/4/2013)
I am not using reporting services.
Basically i am creating pivot of my data using TSQL and trying to dump the data into flat file using...
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2013 at 6:43 am
Viewing 15 posts - 916 through 930 (of 3,544 total)