Topics
Started by
Posts
Last post
Hi, Please can you help with the following statement.I am trying to create a column called Harvest …
5 replies
Table1 - personID, firstName, lastName Table2 - personID, badgeID, validFrom, validUntil I would ne…
7 replies
I do bulk insert from CURRENCY.TXT It's a TAB delimited file with CR+LF row delimiter -------------…
5 replies
This is a simple stored proc. CREATE PROCEDURE [dbo].[usp_rpt_report1] (@col1 varchar(8)) AS SELE…
2 replies
Hello, I have a stored procedure named [sp_test]. When I call this in query analyzer (exec sp_test)…
5 replies
I'm trying to help someone that needs a view that averages an integer value grouping by day. There…
6 replies
Hi people....... HELP ME PLEASE !!!!!!! I have a table with 5 fields with this value FIELD A …
2 replies
Hi Could any body plz help differece between IN And OR Clauses i hope both are give same result any…
4 replies
Hi, I have a txt file with comma field terminator: e.g. 1, tablname1, datacolumn1, datacolumn2, dat…
22 replies
I'd like to modify an insert trigger so that I take the NT User Name associated with the insert sta…
2 replies
I'm using sql syntax like the following: CODE select * from OpenRowset('MSDASQL', 'Driver={Microsof…
5 replies
I am having some trouble with the following query in one of our production databases: select * fr…
15 replies
I have a stored procedure that if I call it directly in ssms it never stops running. But if I run …
1 replies
I'm using the following to return the current month in a comparison statement: cast(month(getdate()…
16 replies
I need to create a check constraint on a phone table. This table has : phone_id (PK, identity), use…
5 replies
Viewing 15 topics - 7,171 through 7,185 (of 12,234 total)
You must be logged in to create new topics.