Viewing 15 posts - 61 through 75 (of 402 total)
Michael Valentine Jones (2/13/2013)
Andy Hyslop (2/11/2013)[/b
...
Why should User Defined Functions not be prefixed UDF or udf, views not Prefixed with VW or vw and Stored Procedures not USP or usp
...
That...
February 13, 2013 at 8:44 am
Thanks all for the replies - most helpful 🙂
I have never prefixed tables with tbl but I have prefixed usp's and views
It just seemed like an odd question the way...
February 12, 2013 at 4:02 am
kravitej9 (1/29/2013)
Can u send me the query
This may help..
DECLARE @temp AS TABLE
(v1 INT, v2 INT, v3 INT)
INSERT INTO @temp
SELECT 1,3, NULL UNION ALL
SELECT 3,4,5 UNION ALL
SELECT 4,2, NULL UNION ALL
SELECT...
January 29, 2013 at 3:59 am
Hi
Your DDL seems to be missing VOYAGE_NUM in the table MG_VSLVOY_HEADER
Andy
January 11, 2013 at 6:14 am
January 8, 2013 at 8:30 am
Debug the source columns and ensure that the destination columns match the correct data types and lengths.
+1
What I find interesting is that the package works fine when I point to...
January 3, 2013 at 8:41 am
Because I don't know your structure it's a little difficult, but...
I have had to do similar things in the past (although I insisted on design changes) however a concatenation of...
January 3, 2013 at 8:09 am
Any reason why you can't use the PK from the source table as the PK in the destination?
But for some reason they have gone by this design.
Crazy! :crazy:
January 3, 2013 at 7:43 am
The Destination table does not have an identity field. Hence, i would have to increment the PK value myself before inserting
This sounds like a nightmare waiting to happen for you!
Is...
January 3, 2013 at 7:38 am
case when field ='' then NULL
else field
END as field
NULLIF(YourColumn, ' ')
January 3, 2013 at 6:03 am
Hi
This should help
SELECT a1.CUSTID, a1.COMPANY AS [Co Name], a2.STATUS AS [TYPE], a3.ORDPROD AS [Product]
FROM dbo.TABLE1 AS a1
INNER JOIN dbo.TABLE2 AS a2 ON a1.CUSTID = a2.CUSTID
LEFT OUTER JOIN...
October 24, 2012 at 9:00 am
Where is the DDL? What is yuor question? Why did post half a statement in 1970's Sybase dialect? Is this what you meant, but did not know how to write?...
October 19, 2012 at 7:26 am
Hi
The easiest way to achieve this is too use a calendar table with a isWorkingDay or some such column you can then just use on this based on the current...
October 19, 2012 at 7:22 am
Viewing 15 posts - 61 through 75 (of 402 total)