Topics
Started by
Posts
Last post
We have situations in our application where the 1st business day of September of specified year is …
7 replies
Hello all - So, I have been hunting down and resolving deadlock issues over the past week, but hav…
6 replies
Hello, I have a question on the nonclustered index consolidation topic. There 2 tables called Recor…
4 replies
hello guys i want to import a big text file with a fixed record length(288) to tables.i need to rea…
2 replies
I am trying to write a script that will calculate overtime hours by day. There will be a column th…
2 replies
I am working on a project that will require the transfer of thousands of records from one DB to ano…
6 replies
Please help! There will be csv file from SQL Server of the contractor will send to me new reading e…
7 replies
Hi all, I am currently working as a Lettings Manager for a small company, and part of that roll is…
4 replies
Hello, I'm using BULK INSERT to laod a comma delimited file into a SQL table. I only need a number …
3 replies
Hello, How can I lock a table to prevent user from reading it while deleting and inserting records …
2 replies
Hello, I need help creating a format file using bcp. All resources I have read on MS web is not cle…
2 replies
Please help in the below trigger to update the immediate children of parent and children of the imm…
2 replies
I have this: UPDATE table SET column = ELT(FLOOR(RAND()*3)+1, 'string1', 'string2', 'string3'); Jus…
4 replies
I have the following script, which was returning all the months, regardless of whether there was da…
2 replies
Hi Guys, I have to update all address fields in a table by a year. One of the columns has a datatyp…
14 replies
Viewing 15 topics - 286 through 300 (of 2,735 total)
You must be logged in to create new topics.