Topics
Started by
Posts
Last post
How do I do the following? 1) Do I put the 0700 in quotes or not? ...DATEPART(hh,@start_date_time) …
3 replies
Dear everyone, I use AFTER INSERT triggers to insert records in one table based on another table. W…
1 replies
I want to set a holiday flag on a temp table if a date on my temp table(@Orig_Calendar) is in the h…
1 replies
Hi All, I have the following scenario. I need to create sums for a field in a view grouped o…
3 replies
DBAs, What is the best way to determine the total number of data elements/fields in a SQL Se…
2 replies
Hi, (sorry for the dodgy title) I have 3 tables: <SCHEMA> tblProduct pro…
6 replies
Is there a way to aggregate strings (concatenate), in a similar way as the Sum functions does with …
7 replies
I have 2 servers, Test & Prod. Prod has all the data. Test's applications and DBs have already…
2 replies
HI! I want to get positive and negative sums of one product, how can i do that? My query: se…
3 replies
Hi All, I hope you can help. I have a menu table setup as follows: MenuID …
1 replies
Hi is it possible to call a stored procedure from t-SQL. like select raised_date from table where i…
4 replies
I have a datetime column. I want to update the time portion of the column with a value. The value I…
2 replies
Is there an easy way to get the number of records inserted or updated from an insert or update…
2 replies
I have a query that does a Select from a VIEW consisting of 4 tables. Since this is PeopleSoft…
5 replies
Hi All, I am getting an error saying that there is no "Begin" statement, even though it is present …
15 replies
Viewing 15 topics - 13,441 through 13,455 (of 17,082 total)
You must be logged in to create new topics.