Solved

add a named Column to where statement

Posted on 2009-05-19
15
235 Views
Last Modified: 2012-05-07
See attached text file.  I am trying to add in a named colum to my where clause to make it work correctly.  All of this select goes into a datagrid for presentation.
Help.txt
0
Comment
Question by:kdeutsch
  • 5
  • 5
  • 3
  • +1
15 Comments
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24421704
It looks like you're trying to say when both your case condition is met and when your substring > 0.  If this is the case, try the following snippet.

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

  and at.AUTH_DOC_POSN_TITLE like '%(%)%'

  and substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END > 0

Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24421733
The other way I could read your question is that if auth_doc_posn_title is like '%(%)%' then you want to check the substring and include >0, otherwise if auth_doc_posn_title isn't like that, don't bother checking the substring and include it anyway.  If this is what you're looking for, try the below instead.

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

  and ((at.AUTH_DOC_POSN_TITLE like '%(%)%' and substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END > 0)

   or (at.AUTH_DOC_POSN_TITLE not like '%(%)%'))

Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24421818
I keep getting an error of incorrect syntax near else on line 22.
I tired something like taht before but received 0 records.
0
 
LVL 41

Expert Comment

by:pcelba
ID: 24421845
The CASE structure is allowed in WHEN clause, so you should look at its values first and then you may decide if it works or not.
0
 

Author Comment

by:kdeutsch
ID: 24421869
Hi I provided some data, it might provide more insight.
Help2.txt
0
 
LVL 41

Expert Comment

by:pcelba
ID: 24421892
You have duplicate END in your case, try this WHERE:

where      Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
and       case when at.AUTH_DOC_POSN_TITLE like '%(%)%'
        then substring(at.AUTH_DOC_POSN_TITLE,
                       1 + charindex('(', at.AUTH_DOC_POSN_TITLE),
                       charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1))
        else '0' end - at.ASGN_STR > 0
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24421926
You can put that in a CTE expression. Try this:

;with FilterVAC as (

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT 

		when 'E' then 'M' 

		when 'W' then 'M' 

		when 'O' then 'M' 

		else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC(case when at.AUTH_DOC_POSN_TITLE like '%(%)%' 

					then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', 						at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) 

				else '0' end ) = 0 THEN 0 

	ELSE 

		case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

)

select * from FilterVac

where VAC > 0

Open in new window

0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 41

Expert Comment

by:pcelba
ID: 24421969
You can use your select as subquery:
SELECT * FROM (

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726') SUBQ

WHERE SUBQ.VAC > 0

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24421988
pcelba
Tried taht and it always comes up with zero records,  from the sampling I showed it should come up with a few.

ralmada, these are the errors on this script
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ';'.
Msg 156, Level 15, State 1, Line 29
Incorrect syntax near the keyword 'Order'.
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422019

;with FilterVAC as (

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

)

Select * from FilterVac

where VAC > '0'

Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422027
sorry
;with FilterVAC as (

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

)

Select * from FilterVac

where VAC > '0'

Order by UPC, Auth_Para_Dsg, Auth_Line_Dsg

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24422086

ralmada:  Still getting this erro, tried to remove but brings more error, i tired single quote on select asl well with no result.

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ';'.
0
 
LVL 41

Accepted Solution

by:
ralmada earned 250 total points
ID: 24422120
Are you SQL 2005? ";with" only works in SQL 2005. If not try this:



Select * from (

SELECT	at.UPC as UIC, 

	ut.Addr_City as City,

	at.Auth_Para_Dsg as PARA, 

	at.Auth_Line_Dsg as LINE, 

	at.GRADE, 

	substring(at.POSC, 1,4) as DMOS,

	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 

	at.AUTH_STR,

	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,

	at.ASGN_STR,

	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 

	ELSE 

	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,

	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  

	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat

FROM    PERS_UNIT_TBL as ut Inner join

	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join

	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC

where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'

) FilterVac

where VAC > '0'

Order by UIC, PARA, LINE

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24422191
argh,
My development is in sql 2000 but prodcution is in sql 2005.
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422219
Well, you can use my last approach. It will work in both SQL 2000 and 2005.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now