Topics
Started by
Posts
Last post
I was wondering if there is a wildcard version of the following IN statement: select top 10 * from…
4 replies
I am using SQL through an Excel spreadsheet. Problem is, my code is giving me a headache. I have …
4 replies
Hi there I am trying to do a query on a table. It is sort of a self join. For eg. The table contain…
5 replies
So, I have a bit of code as a stored procedure. It takes 2:19 to run. When I pull it out, declare…
15 replies
Good Morning everyone, I've run into a weird scenario and managed to stump my friend who is usually…
3 replies
Hi all, Any help appreciated greatly ..... This is a small simulated scenario to make u understand …
10 replies
Hi DBA's Could someone help with my problem. Im running my JOBS when error appeared: Executed as us…
2 replies
I have a table that is in this format: enc_id, code 1 a 1 b 1 c 2 d 2 a 2 b…
7 replies
I'm working on a migration script and drawing a blank on how to do the following. Basically, I hav…
2 replies
I have customized about 200 stored procedures. There was a spelling mistake in some of them. I sp…
7 replies
USE PRACTICE go IF NOT EXISTS ( SELECT * FROM SYS.OBJECTS WHERE TYPE = 'FN' AND NAME = 'GETMONTHEND…
3 replies
Hi every one I have table which has values like this PT_Window_IDPT_UD_KeyPT_UD_NumberSTRGA255 S…
5 replies
Hi All I'm not sure this is even possible, certainly doesn't appear to be using the approach of a C…
3 replies
what is the maximum storage of data using bigint? Bigint doesn't store the value of 922337203685477…
1 replies
Hello I have a table that consist of a unique field (CC #), and what I want to do is to retrive the…
4 replies
Viewing 15 topics - 8,836 through 8,850 (of 12,234 total)
You must be logged in to create new topics.