Topics
Started by
Posts
Last post
I want to update the overbook_flag = 'Y' for all the overbooked appointments. for example: For the …
2 replies
Hi, In this below xml, how can I select the list of employee ids (as int) where location id is 3? I…
1 replies
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
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
Viewing 15 topics - 6,811 through 6,825 (of 12,234 total)
You must be logged in to create new topics.