Viewing 15 posts - 2,701 through 2,715 (of 4,820 total)
Okay... last one I'm going to do. You should be able to see what's being done here and start asking questions about what parts you don't understand:CREATE TABLE dbo.TABLEA...
March 28, 2017 at 11:07 am
You've got a data problem. You changed the PersonID values so that one of them has no match in TABLEB..
March 28, 2017 at 10:41 am
March 28, 2017 at 9:45 am
Okay, so have you used a parameter that actually matches a value in the table being selected from?
March 28, 2017 at 9:15 am
New to the group, and been looking around for a solution to this issue, and...
March 28, 2017 at 9:08 am
March 28, 2017 at 9:01 am
The logic which i did is correct?
ALTER PROCEDURE [dbo].[ICATOU]
@ID nvarchar(40)
AS
BEGIN
SET NOCOUNT ON
IF EXISTS(SELECT 1...
March 28, 2017 at 6:52 am
TY, quick question suppose if i am using two If exists blocks here can i...
March 27, 2017 at 12:17 pm
I have a procedure where it has old type of error handling how can i...
March 27, 2017 at 11:06 am
March 27, 2017 at 10:53 am
I too am not sure about the proper solution, as your original data has duplicated values. Here's what I came up with, after assuming that the duplicates are valid:
March 27, 2017 at 5:59 am
Why not create a Script Task in VB language within an SSIS package, that runs the LDAP query results either into a SQL Server table using ADO code, or into...
March 24, 2017 at 2:06 pm
March 20, 2017 at 1:08 pm
As long as you're creating a view, you will not be able to parameterize your query. Views don't have that functionality. If you need to use parameters, then you have...
March 20, 2017 at 12:38 pm
Viewing 15 posts - 2,701 through 2,715 (of 4,820 total)