Viewing 15 posts - 916 through 930 (of 3,543 total)
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...
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(':',...
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...
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)
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...
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...
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...
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...
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...
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 =...
October 9, 2013 at 7:05 am
Try adding the page break before in the 'material code' group settings
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...
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...
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...
October 4, 2013 at 6:43 am
Based in Chris' data
001Alvin12013-09-20 06:30:00.000
001Alvin22013-09-20 17:50:00.000
001Alvin12013-09-21 06:30:00.000
001Alvin22013-09-21 17:50:00.000
002Rebecca12013-09-20 22:10:00.000
002Rebecca22013-09-21 07:30:00.000
002Rebecca12013-09-21 22:10:00.000
002Rebecca12013-09-21 23:10:00.000
002Rebecca22013-09-22 07:30:00.000
002Rebecca22013-09-24 07:30:00.000
002Rebecca12013-09-25 22:10:00.000
002Rebecca22013-09-26 07:30:00.000
002Rebecca12013-09-28 22:10:00.000
003Aliyah12013-09-20 09:08:00.000
What should the output look like?
October 4, 2013 at 6:35 am
Viewing 15 posts - 916 through 930 (of 3,543 total)