Question:
I need to create two arrays I have done this but its not ideal:
ReDim LogicANDArray(0 To (RowCounts – 1), 0 To 5)
ReDim LogicORArray(0 To (RowCounts – 1), 0 To 5)
I have a main array that i cycle through and get the logical OR and logical AND data and i want to add that data to [...]
Question:
I am new to T-sql. Can I use Reg ex I TIsql? Can you show a bit of code?
Solution:
Check this info:
http://msdn.microsoft.com/en-us/magazine/cc163473.aspx
Question:
How can I find specific position of each space? Sample: This is a test only.
Solution:
Treat yourself to fn_split
Declare @S Varchar(max)
Select @S=’How can I find specific position of each space? Sample: This is a test only.’
declare @p int
Select @p= CHARINDEX(‘ ‘,@S)
While @p > 0
Begin
Print ‘There is a space at position ‘ + cast(@p as varchar(10))
Select @p= [...]
Question:
Hi all,
I need to setup DFS on 2 Windows Server 2003 SP2. On SVR1 I need to do and save the namespaces and SVR2 has all the original files that i need to synchronise on SVR1.
Can you please guide me how to set i t up? Since when i created the namespaces in the event [...]
Question:
HI All,
Please consider the folowing data in an xml data type
<Entity name=”Category”>
<Column name=”Updated” type=”datetime2″ nullable=”1″>
<Properties>
<Hide />
</Properties>
</Column>
</Entity>
I need to remove all Column nodes that have a Hide node descendant resulting in the folowing xml:
<Entity name=”Category”>
</Entity>
But I am unable to find the correct xpath syntax to do so.
SET @xmlResult.modify(‘delete (//Hide/parent()/parent())’);
results in an error when trying to alter [...]
Question:
Hi All,
how to schedule a REORG index on job in SQL Server 2000?
Solution:
I am not sure that is such a good idea, but if you insist you can simple add that command to a SQL Server Agent job and schedule it appropriately.
Question:
I have a database that i created for the organization i work for, and I have set a few fields on the main table to allow multiple values to where they can check all that apply, but when we try to input data, it doesn’t allow the selection to save.
Solution:
You haven’t correctly setup your MultiValue [...]
Question:
I would really like to have a feature where I can click a button and have the code pull currency exchange rates (USD to CDN) for example directly into my Access97 app.
Right now I go to XE.COM and look up the rate I need, and cut-n-paste it into Access97 form.
Any suggestions??
High points for a speedy [...]
Question:
Hi there,
i want to count student_attendance.type from student_attendance table for each DISTINCT entry of student_attendance.student_id.
student_attendance.student_id is FK of student_information.student_id.
for this i have wright following query,but it will only return only those student_attendance.type count whose entry present in student_attendance table but i need all DISTINCT student_id from
student_information.student_id.
——————————————————————————————-
SELECT Student_Attendance.Student_Id, COUNT(Student_Attendance.Type) AS att
FROM Student_Attendance
Inner JOIN Student_Information ON Student_Attendance.Student_Id [...]
Question:
Hi,
I’m trying to use the MS SQL 2008 Import and Export Data to convert an Excel spreadsheet with per minute stock data into MS SQL. One example of the time shown in the spreadsheet is ‘16:40′ for 4:40PM.
When I get to the column mappings section of the wizard, when I change the ‘type’ from ‘varchar’ [...]