Is there any way to Truncate a Variable table i.e.
declare @t table
insert into @t
1 month, 1 week ago
I like to calculate payment for loan monthly
In excel it should look like this:
3 months, 1 week ago
Does anyone in here know how to generate a stored procedure dependency tree?
4 months, 1 week ago
I have a table that contains data in 2 columns that I need to calculate percentages on. An example…
8 months, 2 weeks ago
I need help pulling multiple number values out of a string
field name is Details and here are some …
9 months, 3 weeks ago
By: Jeff Moden
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP hos…
11 months, 3 weeks ago
By: herbert.tobisch 95615
I have a query where I join a table to another table that stores email addresses. So a query…
1 year, 1 month ago
By: Brahmanand Shukla
Is it possible to query Active Directory for user account information? I thought I hear…
In my stored proc, I'm trying to set/pass a datetime variable to NULL. Then I want to check if…
I have a stored procedure mySP and I'd like to use a local variable to store the ouput from sp_…
1 year, 2 months ago
By: Jonathan AC Roberts
I need help with a string with delimiter that needs to be split into column names. I have b…
I know you can't use GetDate() in a UDF, but does anyone know a way of passing the output from …
David le Quesne
By: Chris Harshman
Does anyone know how to write the T-SQL that checks if a job is still running? I need to make…
1 year, 3 months ago
I have an output in my queries that gives me:
xxxxxxx xxxxxxxxx : 123456 (xx) - xxxxxxx...
1 year, 5 months ago
Hey, I'm looking for t-sql that can take two dates and determine how many mondays are between them?
Viewing 15 topics - 1 through 15 (of 17,074 total)
You must be logged in to create new topics.