Topics
Started by
Posts
Last post
I have a production database that I will be running queries against. I am not allowed to modify tha…
13 replies
I'm developing a complex T-SQL procedure which uses nested cursors; or at least tries. Using the d…
6 replies
Because JD Edward uses Julian Dates from 01/01/1900, you can use this code for converting CONVERT(V…
12 replies
I am working on a simulation which takes 120-300 records, randomly assigns them to 10 arbitrary gro…
4 replies
Hello Everyone, At work, I've been getting more involved with hosting and database stuff. I current…
4 replies
Hi, I'm trying to execute a script that uses OPENROWSET to execute a procedure which intern has ano…
12 replies
Hi, In my query it needs to return records which were created in past 12 months. I'm not familiar w…
8 replies
What I want to do is to issue a START command inside the xp_cmdshell. This should start a new…
13 replies
How can I determine the startdate and enddate of a given ISOweek number and a year?? Can …
9 replies
I have a table that contains data in 2 columns that I need to calculate percentages on. An example…
6 replies
Hello, I have a stored procedure that is passed an IP address that I would like to do a reverse DNS…
7 replies
I am trying to figure something out and hitting a brick wall. If I had some code I would post it, …
8 replies
Hi, I try to extract number from a string, is there a SQL Server function to do that? If not, how t…
32 replies
Is there any way to Truncate a Variable table i.e. declare @t table ( f1 int ) insert into @t sele…
3 replies
Please anyone! I like to calculate payment for loan monthly In excel it should look like this: =PMT…
34 replies
Viewing 15 topics - 1 through 15 (of 17,076 total)
You must be logged in to create new topics.