Topics
Started by
Posts
Last post
I've been tasked to write a stored procedure that will project inventory need into the future. …
2 replies
Hi, I have One SQL Query, Select FormID from Tablename Where Action in (1,2,3,4) And Statu…
3 replies
I fixed with single quote. thanks. CREATE PROCEDURE [dbo].[get_phy_list] @DateFrom dat…
6 replies
Hi, Need help here!!! Have a SP that runs a few imports ect ect.... Now i need to do error han…
2 replies
Hi, I have 2 tables, DataToBeParsed and OrderCatalog The first table DataToBeParsed contains severa…
5 replies
table has a field 'A' containing numeric value... Want a field 'B' to display to cumulative data of…
1 replies
I trying writing a cast but I can't seem to get it correct cast((Qr_Respuestas / dt.total) * 100 a…
2 replies
We log data in our store based on datetime. We have three shifts that the workers can work (f…
5 replies
I'm trying to back up DB1 and restore it as DB2. This is what I'm doing: USE master BACKUP DATABA…
11 replies
1. I have a table simplified as below: Col 1 type int: userID Col 2 type ntext So a sample da…
3 replies
I need to dynamically create a view based on connection parameters supplied. But before I run 'Crea…
5 replies
I'm trying to modify an sproc which goes through and copies all the new tables, or tables which hav…
1 replies
Can I use a case statement in the Where clause of a select statement? Thanks, Ninel
12 replies
I cannot find anything like it in SQL 2000. INFORMATION_SCHEMA.ROUTINES only shows me sp's and fn'…
6 replies
I've got a cursor I've adapted to pick up course history from a table and insert spe…
13 replies
Viewing 15 topics - 7,861 through 7,875 (of 17,082 total)
You must be logged in to create new topics.