Topics
Started by
Posts
Last post
Hi, I have a small problem. In a table there are 4 fields fld1 fld2 fld3 user_id x …
3 replies
We are processing T-SQL batches (series of modifications to table data). Ultimately I would like to…
3 replies
Hi, I am trying to develop a report. Basically we have two tables named A and B. In Ta…
2 replies
I have the following query: ----------------------------- SELECT p.dept as Dept, f.value as O…
4 replies
If there is a Unique Key violation the below SP Code crashes and returns an error back on the Front…
4 replies
Hello All, I need to compare system date to a date out of a table. How can I compare the syst…
2 replies
Hi Guys, I'm writing a hospital departmental database. I want to create a UDF that calculates a pat…
10 replies
Hey Everyone i would like to know how to create extended proc and what are the benefits of creating…
2 replies
I have a bit of a twist on the BOL example of expanding Hierarchies. It's a real brain melter for m…
10 replies
this is the most likely question asked in an interview i have one table in a database iam connecti…
1 replies
Hi I am passing a paramter to a sp which is a variable list of numbers (ie. '1234,1245,5678'). I wa…
11 replies
i have a table returning UDF, it accepts a parameter say customer_no something like this fnMyTABLEU…
5 replies
I need to know if there is any way to efficiently troubleshoot what is the problem when syntax…
7 replies
I have two tables. Table 1 has field1, field2 , field 3 Table 2 has field1, field2, field4 Can somn…
2 replies
When I try to shrink the log file for my databases I am getting following message. Cannot shrink lo…
10 replies
Viewing 15 topics - 11,956 through 11,970 (of 17,082 total)
You must be logged in to create new topics.