Topics
Started by
Posts
Last post
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
Ok, I'm sure someone has a better way of separating this data than using CHARINDEX.... 10.1.1.% 10…
4 replies
I have a client who wants a database created for each job they undertake. It works like this: In t…
4 replies
I have a table with 800,000 records that we need to test if the generated name that the records sho…
13 replies
I am trying to pull a field where if the data value has 8 characters, strip off the first and last …
3 replies
Viewing 15 topics - 8,701 through 8,715 (of 12,230 total)
You must be logged in to create new topics.