Topics
Started by
Posts
Last post
I'm trying to write a query to give me the latest EntryDate record based on the value of the AsOfDa…
5 replies
I have a cursor with a nested cursor. The outer cursor gathers data then inserts the ID number and …
24 replies
Hello, I have a situation where a very large SP is being used to handle the business logic for upda…
13 replies
Hi All, I have to tune a SP which has more than 3000 lines. Below thecode is part of that procedure…
4 replies
i tried to insert a single column from a txt file a sql DB say the file contains 1 tab field2 tab f…
21 replies
Hello, I was hoping someone out there can help me out with a question/issue I'm running into. I inh…
17 replies
Hi, I am trying to automate a process where I add a user and set its permissions to most, but not a…
6 replies
Buddies, A table is designed with a value-encrypted column. I'd like to read its values. How can …
3 replies
Hi All I have 2 tables Employees IDM Employees contains 2 triggers. 1 insert and 1 update which in…
6 replies
Hello all, I have to update more tables in same query using SQL. But i dont know how many tables i …
3 replies
Greetings folks. I have been asked to show some information to a user, and I want to make sure I t…
2 replies
I m trying to insert a .csv file to a table i have saved my file in the c drive root this is the co…
1 replies
I know it is possible to replace a word with the edit button on a script, but is there a way to rep…
1 replies
Hi, I am positive some SQL Gurus can help me with this complicated query. I am not sure if it is po…
4 replies
Dear All, Am facing problem while using a truncate or DBCC command inside a function. An error mess…
1 replies
Viewing 15 topics - 3,151 through 3,165 (of 17,082 total)
You must be logged in to create new topics.