Topics
Started by
Posts
Last post
Hi, I have table emp in dbserver1 and i need to utilise these table data in dbserver2 in sql server…
1 replies
I have a query that I am trying to convert to from VBA for Access to T-sql. Here is the query liste…
4 replies
I have been tasked with making sure a group of stored procedures all have the transaction isolation…
11 replies
By: krypto69
I have a table with data. Daily new rows are added. How to select first 2 rows having max date? Dat…
3 replies
Hi folks, What I am trying to do is update a table with the results of some aggregate functions in …
8 replies
If the compdte (completed date) = '1900-01-01 00:00:00.000' then count the days from the entered …
7 replies
I am trying to query a table that is structured as id, type, old value, new value and I want the re…
4 replies
Hi All, I m populating the XML resultset from the stored procedure through the temp table. The pro…
3 replies
Hi, I would like to know if it's possible to retreive Windows user logged on to the PC (domain\use…
7 replies
Hi All, I have two date time and have to calculate difference between these date time. But the pr…
4 replies
Have a very simple trigger that has worked flawlessly for years on 2000. Moved the database to a 20…
1 replies
I know that cursors is not a very good option but I haven't come with a better solution.... Not to …
2 replies
Hi, I have this sample xml data. DECLARE @depxml XML SET @depxml = '12100102' If I do a SELECT li…
2 replies
Here is my table: Create Table #Bar ( EmployeeID int , EName varchar(50) , VisitedState varchar(…
4 replies
Hello, I have a Table (#TCompanyNames) that has database names. I query a master table to get a lis…
9 replies
Viewing 15 topics - 6,811 through 6,825 (of 12,232 total)
You must be logged in to create new topics.