Topics
Started by
Posts
Last post
Hi. I am attempting to construct a query intended for use in a report. The report is to display pay…
25 replies
Hi There, Im having the problem when i tried to update the value in the column. My table has follow…
4 replies
What is wrong with below script select 'EXEC sp_addextendedproperty @name = ''MS_Description'' ,@…
7 replies
I have to concatenate fields from a table into on huge column in another table. Problem is some of …
10 replies
Essentially, I'm curious if the position of an FK column matters for performance. That is, is: CREA…
4 replies
Are there any disadvantages to using t-sql user defined functions? From a coding/maintainability pe…
15 replies
When trying to recreate foreign key FK_ptPhysicalExam_ptDemographics in the following code, I'm get…
6 replies
I am calculating a value in a Select statement, then passing that calculated value into functions e…
19 replies
update tblmCIBC set c_notes = (SELECT ',rtrim (isnull(n.Datetime,' ' + rtrim (isnull(n.N…
2 replies
I have a table with data that has white space between them. How do I remove the white space from th…
6 replies
Hi All I am not a good SQL writer, i got a table as below ProductPriceDate HDD20001/…
6 replies
Hi all, how to update two tables( with foreign key relation ship) at a time using triggers. here is…
2 replies
I went back into a Visual Studio report project today. I have made numerous changes to the stored p…
0 replies
hi iam having this problem with duplicate records, I want a query which will check the table for a…
3 replies
How should I parse this XML so that the output includes the ServiceLineID? SET QUOTED_IDENTIFIER ON…
4 replies
Viewing 15 topics - 8,701 through 8,715 (of 12,234 total)
You must be logged in to create new topics.