Topics
Started by
Posts
Last post
I start by saying that I am really new at SQL coding. My task is to identify all members who as of…
2 replies
I have a table like CREATE TABLE [dbo].[test]( [empno] [varchar](20) NOT NULL,[startdate] [datet…
14 replies
Greetings all. I need to capture the date a certain field is updated, so I put a simple update tri…
3 replies
When I use opendatasource() and try to get data from the sysobjects table I get OLE DB provider 'SQ…
4 replies
Hello All, I have the following; Table1 Name County A Adair B A…
5 replies
I'm trying to update a text field with the value in a date field but without any slashes appearing …
1 replies
i tring to run SP but i m getting i using SQL 2000 with Sp 4 Plz give me solution
1 replies
So, of course multiple sessions can have temporary tables with the same name at the same time in te…
2 replies
I have a stored procedure that is taking employee payroll clock-ins / clock-outs and populating a t…
10 replies
So I have a table of Items, each with a quantity, and a type. CREATE TABLE dbo.Items ( name varch…
4 replies
Hi, Processes are locked for an excessive time.how can we see that which blocked processes are blo…
3 replies
I have some code that works fine in SQL Query Analyzer, but fails with an error when running as a j…
5 replies
Can this be done in T-SQL? I have a table with the following information: RowId CustomerNumber Inv…
8 replies
[font="Courier New"]Is there a way to autoincrement a column by group using group by function under…
6 replies
Hi All, I need to prepare a checklist to ensure the data has been moved correctly. what are the thi…
3 replies
Viewing 15 topics - 2,521 through 2,535 (of 17,082 total)
You must be logged in to create new topics.