Forum Replies Created
Viewing 15 posts - 6,196 through 6,210 (of 13,876 total)
-
RE: A Fun Distraction
PAH-440118 (12/16/2016)
ROUGE 1! :alien:Really hope I get to see this film on the Big screen.
I must admit to wondering whether this was some dodgy French film I needed to...
-
RE: Need sql help
sarwar.ali490 (12/15/2016)
HiI have a following scenario.
File has 4000 records.4(1,2,3,4) sets of records make one final record.I am moving whole set of 4 records if any of the (1,2,3,4)record has some...
-
RE: Must declare the scalar variable appears in SSMS and not in VS (SSDT)
Robert Frasca (12/15/2016)
That's actually the way it is in my code except for the insert and select statements which are one line. Of course, I chose the wrongtag...Sorry...
-
RE: Must declare the scalar variable appears in SSMS and not in VS (SSDT)
Here is the code again, this time with IFCode formatting (please do this in future, to aid your readers)
DECLARE @rowGUID [uniqueidentifier],@InfoXML [varbinary] (max)
,@InfoXMLPerf [varbinary] (max)
,@AppGuid [uniqueidentifier]
DECLARE @LogTable AS TABLE (
LogDatetime...
-
RE: SSIS Process only the "Latest" file based on name
Lowell (12/15/2016)
I've got a situation where csv files are superseded by another in a given month; they gather on an FTP site for collection at my convenience.they do follow...
-
RE: Solving an SSIS Error – Cannot convert between Unicode and non-Unicode
It would be interesting to know how performance varies between the two options (CAST in source and data conversion in package).
For those with separate servers running SSIS, doing the data...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
to be more clear this is an example of what i want to produce (the number in the square is the subnet selected)
What software are you going to use...
-
RE: How to get value based on position of special character string in a column
vikram_patro (12/14/2016)
I attached the sample data in excel to the original post, hope that helps.Also attaching here.
I mean, like this
SELECT *FROM
(
VALUES
...
-
RE: How to get value based on position of special character string in a column
vikram_patro (12/14/2016)
Hi John, thanks for the quick reply but I was not clear earlier. Can you check my post again now.Thank you, Vikram
Are you able to provide your sample data...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
Thanksi want the result to be in some hierarchy (this is after each ip "," followed by depth level
10.0.0.0,0
10.13.15.63,1
10.16.8.2,1
15.0.0.0,0
...
-
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
want to build a table, which contains different ip and there sub-net.when i pull the table i want to get result in way i know who os the...
-
RE: Unable to map an environment variable with the sensitive property set to True
PSB (12/13/2016)
Not sure what I need to fix and where in environment variables. Can you please elaborate ?Change the 'Sensitive' property of either the environment variable or of the package...
-
RE: Unable to map an environment variable with the sensitive property set to True
PSB (12/13/2016)
Hi,I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally the package works fine.
Description: Unable to map an environment...
-
RE: GROUP BY in SQL Server 2014
zouzou (12/13/2016)
Hello all,The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i...
Viewing 15 posts - 6,196 through 6,210 (of 13,876 total)