Topics
Started by
Posts
Last post
Trying to find a way to commit after N rows inserted to keep the logs from filling up. Here is the …
4 replies
Hi there. I got this simple SP which only deletes records based on some criteria: begin try dele…
8 replies
Okay guys, I'm thinking this should be easy for you this morning, but I'm thinking that maybe my co…
3 replies
I have a table which holds revision number for an item an the date it was created. How do I write a…
4 replies
if i have an option to use either "NOT IN", "NOT EXISTS" or "LEFT JOIN" which would be best perform…
2 replies
dear all, please help me with this query that i still can't find the right solution i have this que…
6 replies
Hi Folks I looked at several issues with regards to decimals but still in the dark I am trying to f…
8 replies
Hi, I am developing an agent statistics half hourly report. The source table structure is as below.…
3 replies
Hello i need help in writing a query, i want to insert monthid (YYYYMM) in a table. My table would …
11 replies
Hi, I've a table with those columns (datetime,int,int) in this table i insert every hour a record o…
12 replies
I need to exceute an store procedure when a row is inserted in a table and when a row is deleted an…
3 replies
can these 2 views give same result and performance? ALTER VIEW [dbo].[vwemp] AS Select * from empl…
3 replies
Hi We have a production DB in SQL server 2005.In most of the table we generating the primary key th…
6 replies
Hi guys, I have a situation whereby I'm passing an XML string to a stored procedure and it extracts…
4 replies
Hello All, One of my 'partners' sends me a csv file where they combine text and numeric data in one…
13 replies
Viewing 15 topics - 2,086 through 2,100 (of 12,234 total)
You must be logged in to create new topics.