Topics
Started by
Posts
Last post
Our ERP accept only sql statments for reporting.(I can write select ... but I can not Write E…
5 replies
Hi, I was creating a stored procedure. Inside my stored procedure, I have statements like Trunca…
4 replies
I have four tables created that are linked by EmpID, DeptID, SecLvlID and ReceiptID. The four…
7 replies
How can I insert a "-" into "char10" field that has trailing spaces ? I tried the following but it …
3 replies
I need to improve performance in a complex stored procedure "sp_mbvarInit" that was written 2 years…
11 replies
I have a 2 column tabel, with column name Person_id and Comp_id I would like to select the Person_i…
11 replies
Hi, In sql server we can have a select query like Select [var1] = ‘Hello’,[var2] = t.col1 from tabl…
7 replies
How do I pull the month out of date, and convert it to a string value? In other words, if the month…
4 replies
Hello, I am trying to create a CASE statment which will update a column depending on the outcome of…
1 replies
Hi all, I am trying to loop through the rows in a temp table, and change the status of these rows f…
2 replies
Hello, I need to remove spaces,commas,full stops etc from a string in a column. For examp…
4 replies
Does anyone know how to return the number of occurances of a string from a TEXT field. Thanks …
5 replies
Can I do this with SQL statements :- Input String : "I …
4 replies
I am working on a report Which would be like following This is what i have: company_no dept_…
5 replies
Hi all, I need help setting up a check constraint. When someone enters a machinenumber into ta…
3 replies
Viewing 15 topics - 11,731 through 11,745 (of 17,082 total)
You must be logged in to create new topics.